| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I summarize total hours over multiple days
EXCEL 2003- How can I modify
"=IF((OR(C10="",B7="")),0,IF((C10<B7),((C10-B7)*24)+24,(C10-B7)*24))" to add up total hours over multiple days with a start time in one cell and end time in another cell. And how do I link those cells to a date. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting total number of hours (24 hours) into days | Excel Discussion (Misc queries) | |||
| Running total of hours based on last 7 days | Excel Worksheet Functions | |||
| How do I summarize time that exceeds 24 hours? | Excel Worksheet Functions | |||
| Convert days in decimal to days:hours:minutes | Excel Worksheet Functions | |||
| Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions | |||
Threaded Mode
