Spreadsheet: 775335d1649036437-calculate-pay-rate-depending-on-the-time-of-day-weekly-time-sheet-help
Sheet: Time Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  | Basic Pay |  |  |  |  |  | Over Time
 |  |  |  |  |  |  |  |  |  | Over Time |  |  | 14 | 13 | 13.5 | 14 | 14.77 |  | 14 | 13 | 13.5 | 14 | 14.77
 | Day | Duty No | Board 1 | In | Out | Board 2 | In | Out | Regular hrs | Board | In | Out | Sunday | Mon-fri | sat <13 | [NAME] | BH | Total | Sunday | Mon-fri | sat <13 | [NAME] | BH | Total | Overall Total |  |  | BH Dates
 | 2022-03-27 00:00:00 | 9405 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022
 | 2022-03-28 00:00:00 | 6119 |  |  |  |  |  |  |  | 6203.af - 112 | 08:38:00 | 11:16:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-03 00:00:00 | Monday | New Year’s Day (substitute day)
 | 2022-03-29 00:00:00 | 6003 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-15 00:00:00 | Friday | Good Friday
 | 2022-03-30 00:00:00 | 6004 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-18 00:00:00 | Monday | Easter Monday
 | 2022-03-31 00:00:00 | 6005 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-02 00:00:00 | Monday | Early May bank holiday
 | 2022-04-01 00:00:00 | 6101 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-02 00:00:00 | Thursday | Spring bank holiday
 | 2022-04-02 00:00:00 | RD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-03 00:00:00 | Friday | Platinum Jubilee bank holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-08-29 00:00:00 | Monday | Summer bank holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-26 00:00:00 | Monday | Boxing Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-27 00:00:00 | Tuesday | Christmas Day (substitute day)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-02 00:00:00 | Monday | New Year’s Day (substitute day)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-07 00:00:00 | Friday | Good Friday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-10 00:00:00 | Monday | Easter Monday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-01 00:00:00 | Monday | Early May bank holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-29 00:00:00 | Monday | Spring bank holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-28 00:00:00 | Monday | Summer bank holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-25 00:00:00 | Monday | Christmas Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-26 00:00:00 | Tuesday | Boxing Day