Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Formats of Time Duration

    Hello,

    As per the attached XL file, I'm trying to get the Custom format right to convert Decimal Time into the Hours:Mins:Secs format.

    The format I'm using doesn't seem to work.
    It converts 100 Mins (Decimal Time) into 2400 Hours!
    It should be 1 Hour 40 Mins 0 Secs.

    How can I fix this problem?

    Thanks,

    BD.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Changing Formats of Time Duration

    You need to use =A3/1440

    Excel stores times as a fraction of 1 day, so you need to divide by the number of minutes in 1 day

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Changing Formats of Time Duration

    Excel measures dates and times in days. So you must convert minutes to days in addition to applying custom formatting. There are 24 * 60 = 1440 minutes in a day, so put the following formula in cell B3:

    =A3/1440

    The custom formatting will take care of the rest.

  4. #4
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Formats of Time Duration

    That's Bril. Thanks,

    BD.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •