adding up total time
Sorry, I wasn't clear, but thank you for your quick response. That is the
output is just part of what I would like to achieve. I would like to get the
swim, bike and run to go into a pie chart or the like. Unfortunately, the
charts only pick up the swim because it thinks it is a 24 hour time not an
amount of hours.
My question should have been: How do I get the three time amounts to become
a graph (ignoring the total obviously)?
--
Kevin
Cloverdale, BC
"Joel" wrote:
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
|