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
and get the total in Decimal time
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top