Time factor
That one didn't work.
I entered: =SUM(D4:D13)/1440
It totaled my time as 2 min 50 sec.
Should be 4 hrs 44 min
00:02:50
0.10
0.34
0.13
0.49
0.24
0.11
0.86
0.20
0.24
0.13
"Bernie Deitrick" wrote:
Debbie,
Use
=SUM(cells)/1440
and format that cell as time (hh:mm:ss)
1440 is the number of minutes in a day (24*60), which converts the sum of minutes to fractions of a
day (a value between 0 and 1), which is how Excel does timevalues.
HTH,
Bernie
MS Excel MVP
"Debbie" wrote in message
...
I'm sure I'm overlooking something simple...
Please help:
I'm adding time differences of:
0.02 (Minutes)
0.09
0.02
0.99
0.20
My total minutes equal:
132
I want to convert this number to the number of hours minutes which should be:
2:12
I can't seem to wrap my brain around this to find the answer.
|