Hi guys,
I need help with my time-sheet.
I work different shifts all the time so start times vary from 6:00 to 9:30, 12:00 16:00 21:00 etc. The shifts are mostly over 12 hours.
I have different rates of pay for day shift 06:00 to 18:00 £12/hour, night shift 18:00 to 6:00 £13 and overtime is x1.5 accordingly. SO if day O/T it is £12*1.5=-£18 and if night O/T £13*1.5=£19.5
I would like to calculate all the rates automatically and then sum up into 1 cell. I don't mind extra columns for data on side.
I will attach a sample of my current time-sheet.
Thank you in advance for your help. I have spent 2 nights on it already without any good results
Bookmarks