Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have created a table which shows the amount of volunteer hours I have
worked each day. I then created another column which I wish to create a running total of the hours worked each day. e.g: A B C 1 Date Hours Running Total 2 01/09/09 03:30 03:30 3 02/09/09 03:30 07:00 However, when I get passed 24 hours, it goes back to 0 because the cells are in time format. How can I create the running total to count the hours for each day whilst overriding the 24 hour rule? Thank You in anticipation for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Elapsed Time | Excel Worksheet Functions | |||
Calculating elapsed time | Excel Discussion (Misc queries) | |||
Calculating Time elapsed | Excel Worksheet Functions | |||
Calculating elapsed time | Excel Worksheet Functions | |||
Calculating a rate for elapsed time? | Excel Discussion (Misc queries) |