| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Working Time Night Shifts
Hi
I am new to this forum but desperately need help. I am creating a time sheet, and cannot find a solution to calculate the duration of time worked on a night shift. The night shift rate starts from 11:00 PM until 7:00 AM and is written in the format given. Therefore any period worked between these hours is classed as a night shift rate. Excel I believe does not recognise AM or PM therefore I have problems. Finally in addition I need to multiply the answer by the hourly rate. Please can anybody assist, Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time formula returns night time by mistake | Excel Discussion (Misc queries) | |||
| calculating night time | Excel Discussion (Misc queries) | |||
| calculate finishing time if night shift aren't working | Excel Worksheet Functions | |||
| Working night and day..... Timesheet | Excel Worksheet Functions | |||
| Subtracting Night-time-hours | Excel Programming | |||
Linear Mode
