adding up total time
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 |
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 |
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 |
adding up total time
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 "bikierguy" wrote: 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 |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com