Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting Dates to get total time work time excluding weekends | Excel Discussion (Misc queries) | |||
Sumproduct and adding the total time in a column | Excel Discussion (Misc queries) | |||
Grand total time between two total cells | Excel Discussion (Misc queries) | |||
Sum total formula for adding 2 columnson time sheet | Excel Worksheet Functions | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |