MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Time Format


Posted by Ian on April 20, 2001 7:12 AM

Could some one provide me with a time format that would show cumulative hours and fractional sections?
For example 36 hours 5 minutes and 30 seconds would appear as something like:
36:05.5

Thanks in advance,
Ian


Posted by Big bob on April 21, 2001 7:35 AM

::::::::The format for showing hours greater than 24 is[h]:mm .However since you want seconds to be dealt with as a decimal you will have to use the SECOND function to get only the number of seconds in your time value then divide it by 60 to get the appropriate decimal portion
Format the result to get a sensible number of figures after the decimal point and then append it to the minutes portion of the time value
HTH