adding up total time
The total is correct. It is displaying 7 hours and 25 minutes. what answer
are you expecting? If you are expecting 7.416666 then you need to convert
the format of the cell to a number instead of a date. This will give you a
fraction of a day like .30902777777. Then you need to multiply by 24 to get
the true hours.
"bikierguy" wrote:
I would like to know how to format simple hours to add up in hours vs. 24
hour clock time. Here is an example of what I am thinking:
Swim Bike Run Total
1:30 3:35 2:20 7:25
I can't seem to convice Excel 2007 to format the time I entered as an amount
of time vs. an actual time.
Any help would be appreciated.
--
Kevin
Cloverdale, BC
|