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.

Share This Page