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.
|