| 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 |
| 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 | |||
Threaded Mode
