| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotaling of hours
Example:
A B C TIMESHEET In out Hours 8:00 17:15 8:15 [Hours is calculated, B - A, "In", "Out", formatted as hh:mm) 9:00 17:00 8:00 Total xxxx PROBLEM: If I use SUM() to calculate xxxx the number is wrong. What function can I use to come up with the correct total of 16:15 ? Thanks a lot, Thomas |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
| Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
| Can this adjusted GPA formual be accomplised? | Excel Discussion (Misc queries) | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Threaded Mode
