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. 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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
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:
    226
    jennie
    Apr 5, 2004
  2. Replies:
    2
    Views:
    400
    BenjieLop
    Nov 23, 2004
  3. Guest
    Replies:
    8
    Views:
    1,895
    Bob Phillips
    Jan 20, 2005
  4. Guest
    Replies:
    2
    Views:
    1,412
    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:
    191
    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:
    298
    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:
    423
    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:
    388
Loading...