MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting hh:mm:ss to hours with two decimal places


Posted by Titian on September 12, 2001 6:38 AM

I need to convert the format [h]:mm:ss to number with 2 decimal places, but without loosing the displayed value.

e.g. 81hrs 45mins and 21 secs = 81:45:21
I need this in the format of just hours rounded up to the nearest 2 decimal places = 81.75hours.

Anyone got any ideas???


Posted by Ian on September 12, 2001 6:47 AM

if 81:45:21 is in a1

try:

=MROUND(A1*24,0.15)

if you need it to the nearest .05
which will give the answer 81.75

or just

=A1*24

if you want the answer to be 81.76

Any help

Ian