Monday 8.02

Is 8.02 supposed to be 8 hours and 2 minutes?

If so, why don't you just enter those values as *time*:

8:02
8:00
8:54
8:09
7:59

=SUM(A1:A5)

Format as [h]:mm

Result = 41:04

Quick time/date entry:

http://www.cpearson.com/Excel/DateTimeEntry.htm


--
Biff
Microsoft Excel MVP


"smiley61799" wrote in message
...
I am trying to add time and I am having some difficulties finding a way to
format my numbers to be on a time scale. Example:

John worked
Monday 8.02
Tuesday 8.0
Wednesday 8.54
Thursday 8.09
Friday 7.59

This would total to 41.04 hours for the week but if I try to add this on
Excel it is using the number scale of 100 instead of a time scale of 60 so
I
am getting a total of 40.24. Is there any way to format this to add it
correctly??