| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding hours scheduled for week
I have created a work schedule with start/end time cells formated hh;mm
AM/PM. The "total hours scheduled" cell is formated [h]:mm. I need a formula for the "total" cell that will add the weekly shifts. Ex; Monday 10-5 + Tuesday 12-8 etc. equals 15:00 I've tried to SUM (time out-time in) and it will work for one day, but I can't figure out how to add the remaining work days - all it get is errors. Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count scheduled staff between hours | Excel Worksheet Functions | |||
| Clearing scheduled work hours for weekends | Excel Worksheet Functions | |||
| scheduled hours total | Excel Discussion (Misc queries) | |||
| scheduled hours total | Excel Worksheet Functions | |||
| equation that adds hours as scheduled. 11:00 to 5:00 +6hrs. res. | Excel Discussion (Misc queries) | |||
Threaded Mode
