Convert to decimal time?

M

Major

G'day All

I need to sum a list of standard times eg. 1:25 [h]:mm and get the total in Decimal time
This would seem fairly simple but I can't find a way to do it.
Any help would be appreciated
 
M

Mike

Time is already stored as a decimal value. One day = 1.
6 hours = 0.25. Just format your cell to decimal.
-----Original Message-----
G'day All

I need to sum a list of standard times eg. 1:25 [h]:mm
Click to expand...
and get the total in Decimal time
 
Top