How do I convert more than 24 hours time to decimal?

Discussion in 'Microsoft Excel Misc' started by Guest, Sep 2, 2007.

  1. Guest

    Guest Guest

    How do I convert more than 24 hours time to decimal?
    --
    Many thanks for your help in advance. Have a wonderful day!
    Zsolt
     
    Guest, Sep 2, 2007
    #1

    1. Advertisements

  2. Guest

    Sandy Mann Guest

    Custom Format the cell as [h]:mm the square brackets will stop the hours
    rollong over into days when they get to 24 hours.

    --
    HTH

    Sandy
    In Perth, the ancient capital of Scotland
    and the crowning place of kings


    Replace @mailinator.com with @tiscali.co.uk


    "Zsolt Szabó" <> wrote in message
    news:D...
    > How do I convert more than 24 hours time to decimal?
    > --
    > Many thanks for your help in advance. Have a wonderful day!
    > Zsolt
    >
     
    Sandy Mann, Sep 2, 2007
    #2

    1. Advertisements

  3. Guest

    David Biddulph Guest

    But that's not in decimal.. To convert from Excel time format to decimal
    hours, multiply by 24 and format as number or general.
    --
    David Biddulph

    "Sandy Mann" <> wrote in message
    news:e%...
    > Custom Format the cell as [h]:mm the square brackets will stop the hours
    > rollong over into days when they get to 24 hours.

    > "Zsolt Szabó" <> wrote in message
    > news:D...
    >> How do I convert more than 24 hours time to decimal?
    >> --
    >> Many thanks for your help in advance. Have a wonderful day!
    >> Zsolt
     
    David Biddulph, Sep 2, 2007
    #3
  4. Guest

    Sandy Mann Guest

    Oh yes! I forgot about that bit <g>

    Time for bed I think.

    --
    HTH

    Sandy
    In Perth, the ancient capital of Scotland
    and the crowning place of kings


    Replace @mailinator.com with @tiscali.co.uk


    "David Biddulph" <groups [at] biddulph.org.uk> wrote in message
    news:...
    > But that's not in decimal.. To convert from Excel time format to decimal
    > hours, multiply by 24 and format as number or general.
    > --
    > David Biddulph
    >
    > "Sandy Mann" <> wrote in message
    > news:e%...
    >> Custom Format the cell as [h]:mm the square brackets will stop the hours
    >> rollong over into days when they get to 24 hours.
    >
    >> "Zsolt Szabó" <> wrote in message
    >> news:D...
    >>> How do I convert more than 24 hours time to decimal?
    >>> --
    >>> Many thanks for your help in advance. Have a wonderful day!
    >>> Zsolt
    >
    >
    >
     
    Sandy Mann, Sep 2, 2007
    #4

    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. jennie

    Show more than 23:59:59 hours with time calculations

    jennie, Apr 5, 2004, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    259
    jennie
    Apr 5, 2004

  2. converting time more than 24 hours to a decimal

    , Nov 23, 2004, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    635
    BenjieLop
    Nov 23, 2004
  3. Guest

    convert decimal number to time : convert 1,59 (minutes, dec) to m

    Guest, Jan 20, 2005, in forum: Microsoft Excel Misc
    Replies:
    8
    Views:
    2,023
    Bob Phillips
    Jan 20, 2005
  4. Guest

    How do I sum hours in Excel and convert to decimal numbers?

    Guest, Mar 5, 2005, in forum: Microsoft Excel Misc
    Replies:
    2
    Views:
    1,551
    Niek Otten
    Mar 5, 2005
  5. Guest

    hours are less than eight hours

    Guest, Jul 31, 2006, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    216
    Harald Staff
    Jul 31, 2006
  6. Guest

    Convert dd:hr:mn:ss to Decimal number of hours

    Guest, Apr 17, 2007, in forum: Microsoft Excel Misc
    Replies:
    1
    Views:
    335
    JE McGimpsey
    Apr 17, 2007
  7. Guest

    How can I convert decimal commas to decimal points?

    Guest, Oct 2, 2007, in forum: Microsoft Excel Misc
    Replies:
    0
    Views:
    485
    Guest
    Oct 2, 2007
  8. Josh

    how to turn decimal hours into hours and minutes?

    Josh, Mar 1, 2008, in forum: Microsoft Excel Misc
    Replies:
    18
    Views:
    446
    Josh
    Mar 6, 2008
Loading...