Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating/displaying elapsed time TOTALS
I need some help resolving a calculation formula and/or display in Excel 2003.
I need to keep track of actual time worked on a project for variuos clients and total that time. I enter the start time in column B (display format is hh:mm:ss) and the finish time in Column C (display format is hh:mm:ss). Depending in a code entered in column A, the elapsed time is displayed in either column D, E or F. I calculate the elapsed time using the formula =(($Cn-$bn)+($Cn<$Bn)) where n is the relevant row. The result is correctly calculated and is displayed in the format hh:mm:ss I wanted to be able to calculate the total time for each Category (Columns D, E, and F) but using the =SUM($dn:$dx) where n is the starting row and x is the ending row. Here is where I come unstuck as the total hours simply do NOT add correctly if the total hours exceed 24! I also wanted to sum the totals of Columns D, E, and F but encounter the same problem. Can anyone suggest a solution to my problem? Thanks very much (in anticipation). D. Bruce USAOz Services |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating elapsed days and hours | Excel Discussion (Misc queries) | |||
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) |