adding up total time

[bikierguy]

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.

 

[Joel]

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]

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)?

 

[Mike H]

Hi,

Insert a row between your headings and times and put this formula in A2 and
drag right. Format as %

=A3/$D$3

You should end up with something that looks like this

Col A Col B Col C Col D
Swim Bike Run Total
20.22% 48.31% 31.46%
01:30 03:35 02:20 07:25

Now select the 3 headings and 3 percentage results (not the total) and make
a pie chart of those.

2:20 for a marathon!! what kind of ironman is that

Mike