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



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

or just


if you want the answer to be 81.76

Any help