| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help: Trying to get hours for 11pm-7am shift
I have a third shift and using excel to calculate time 10:30 to 7am all the
other shifts calculate fine useing =sum((A6-A5)*24(A4-A3)*24), But useing this formula the third shift comes out in negative numbers any suggestions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Total hours worked during workdays within given shift time. | Excel Discussion (Misc queries) | |||
| Program for assigning work shift hours | Excel Discussion (Misc queries) | |||
| IS THERE A FORMULA TO MAKE E=6:00PM ETC SHIFT TIMES AND HOURS | Excel Worksheet Functions | |||
| How do I show schedule 11pm to 8 am in Excel? | Excel Discussion (Misc queries) | |||
| Need a function that separates over-lapping work shift hours. | Excel Worksheet Functions | |||
Threaded Mode
