Spreadsheet: 675847d1588523002-roster-pay-with-4-different-wages-based-on-time-period-tmesheethelp
Sheet: Sheet1

Employer | Post Code | Address | Mileage | Day 8 | Day O/T | Night | Night O/T | Saturday | Sunday
Client 1 | PO12 12CD |  | 20 | 12 | 18 | 13 | 19.5 | N/A | N/A
Client 2 | PO12 12CD |  | 26 | 12 |  |  |  | 13 | 15
Client 3 | PO12 12CD |  | 27 | 11 |  |  |  | 13 | 16
Client 4 | PO12 12CD |  | 26 | 11 |  |  |  | 13 | 15
Client 5 | PO12 12CD |  | 48
Client 6 | PO12 12CD |  |  | 11 |  |  |  | 12 | 15
Client 7 | PO12 12CD |  |  | 11
Client 8 | PO12 12CD |  | 46 | 12 |  | 13 |  |  | 18
Client 9 | PO12 12CD |  | 30 | 12 | 16
Client 10 | PO12 12CD |  | 60 | 10 |  |  |  | 12 | 14
Client 11 | PO12 12CD |  | 34 | 10.5 | 14.53 | 11.78 | 15.77 | 14.67 | 15.94
Client 12 | PO12 12CD |  | 18 | 12
Client 13 | PO12 12CD |  | 34 | 12
Client 14 | PO12 12CD |  | 44 | 12 | 12 | 13 | 13
Client 15 | PO12 12CD |  | 15 |  |  |  |  |  | 21
Client 16 | PO12 12CD |  | 8 |  |  |  |  | 16
Client 17 | PO13 13CD |  | 26 | 12.5 |  |  |  | 14.5
DAY OFF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6:00-18:00 | 18:00-6:00 | x1.5 | x1.5
 |  |  |  | 5819 |  |  |  |  |  |  |  |  |  |  |  | 12 | 13 | 18 | 19.5 |  | All rates are per hour
Week | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | Night
Day | Date | Worked @ | Postcode | Milage | Start | Finish | Breaks | Hours | Paid |  | Pay |  | Day 8 | Night | Over Time | Day 8 | Night 8 | Over Time | Over Time
Sunday | 2017-12-31 00:00:00 | Day Off
Monday |  | Day Off |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Tuesday |  | Client 1 | PO12 12CD | 20 | 16:45:00 | 7:15:00 | 0:45:00
Wednesday |  | Client 1 | PO12 12CD | 20 | 23:00:00 | 13:45:00 | 0:45:00
Thursday |  | Client 1 | PO12 12CD | 20 | 23:00:00 | 14:00:00 | 0:45:00
Friday |  | Client 1 | PO12 12CD | 20 | 23:00:00 | 12:00:00 | 0:45:00
Saturday |  | Client 17 | PO12 12CD | 20 | 7:00:00 | 17:45:00 | 0:45:00
Hours /p week |  |  |  |  | mls
 |  |  |  |  | mls
Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | Night
Day | Date | Worked @ | Postcode | Milage | Start | Finish | Breaks | Hours | Paid |  | Pay |  | Day 8 | Night | Over Time | Day 8 | Night 8 | Over Time | Over Time
Sunday |  | Day Off
Monday |  | Client 1 | PO12 12CD | 20 | 14:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Tuesday |  | Client 1 | PO12 12CD | 20 | 12:30:00 | 3:15:00 | 0:45:00
Wednesday |  | Client 1 | PO12 12CD | 20 | 12:15:00 | 2:30:00 | 0:45:00
Thursday |  | Client 1 | PO12 12CD | 20 | 11:30:00 | 2:00:00 | 0:45:00
Friday |  | Client 1 | PO12 12CD | 20 | 11:00:00 | 23:45:00 | 0:45:00
Saturday |  | Client 17 | PO12 12CD | 20 | 11:15:00 | 0:00:00 | 0:45:00
Hours /p week |  |  |  |  | mls
 |  |  |  |  | mls
Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | Night
Day | Date | Worked @ | Postcode | Milage | Start | Finish | Breaks | Hours | Paid |  | Pay |  | Day 8 | Night | Over Time | Day 8 | Night 8 | Over Time | Over Time
Sunday |  | Day Off
Monday |  | Client 1 | PO12 12CD | 20 | 1:15:00 | 15:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Tuesday |  | Client 1 | PO12 12CD | 20 | 2:30:00 | 13:15:00 | 0:45:00
Wednesday |  | Client 1 | PO12 12CD | 20 | 1:30:00 | 15:30:00 | 0:45:00
Thursday |  | Client 1 | PO12 12CD | 20 | 2:30:00 | 15:30:00 | 0:45:00
Friday |  | Client 1 | PO12 12CD | 20 | 3:45:00 | 17:45:00 | 0:45:00
Saturday |  | Day Off
Hours /p week |  |  |  |  | mls
 |  |  |  |  | mls
Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | Night
Day | Date | Worked @ | Postcode | Milage | Start | Finish | Breaks | Hours | Paid |  | Pay |  | Day 8 | Night | Over Time | Day 8 | Night 8 | Over Time | Over Time
Sunday |  | Day Off
Monday |  | Client 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
Tuesday |  | Client 1 | PO12 12CD | 20 | 16:45:00 | 7:15:00 | 0:45:00
Wednesday |  | Client 1 | PO12 12CD | 20 | 5:45:00 | 19:45:00 | 0:45:00
Thursday |  | Client 1 | PO12 12CD | 20 | 5:30:00 | 19:45:00 | 0:45:00
Friday |  | Client 1 | PO12 12CD | 20 | 5:30:00 | 18:45:00 | 0:45:00
Saturday |  | Client 17 | PO12 12CD | 20 | 8:00:00 | 20:45:00 | 0:45:00
Hours /p week |  |  |  |  | mls
 |  |  |  |  | mls