Spreadsheet: 675935d1588573294-roster-pay-with-4-different-wages-based-on-time-period-roster-pay-1-
Sheet: Roster

Weekdays |  | Am Premium |  | Normal Trading |  | Evening Premium |  | Pm Premium
MON - FRI | % | 1.75 |  | 1 |  | 1.25 |  | 1.75
 | RATE |  |  | 23.69
 | Time Intervals | 00:00:00 | 06:59:00 | 07:00:00 | 17:59:00 | 18:00:00 | 22:59:00 | 23:00:00 | 23:59:00
Saturdays |  | Am Premium |  | Normal Trading |  | Pm Premium
 | % | 1.75 |  | 1.25 |  | 1.75
 | RATE |  |  | 29.61
 | Time Intervals | 00:00:00 | 06:59:00 | 07:00:00 | 22:59:00 | 23:00:00 | 23:59:59
Sundays |  | Sunday One Day Rate |  |  | Public Holiday |  | Public Holiday Rate
 | % | 1.75 |  |  |  | % | 1.75
 | RATE |  |  |  |  | RATE
 | Time Intervals | 00:00:00 | 23:59:59 |  |  | Time Intervals | 00:00:00 | 23:59:59
 |  |  | Start | Finish | Break | AM PREM | NORMAL | EVE PREM | PM PREM | Total
 |  | 2020-04-27 00:00:00 | 13:30:00 | 20:00:00
 |  | 2020-04-28 00:00:00 | 11:00:00 | 19:30:00
 |  | 2020-04-29 00:00:00
 |  | 2020-04-30 00:00:00 | 10:00:00 | 18:30:00
May |  | 2020-05-01 00:00:00 | 12:00:00 | 20:30:00
 |  | 2020-05-02 00:00:00
 |  | 2020-05-03 00:00:00 | 11:30:00 | 20:00:00
 |  |  | Start | Finish | Break | AM PREM | NORMAL | EVE PREM | PM PREM | Total
 |  | 2020-05-04 00:00:00
 |  | 2020-05-05 00:00:00
 |  | 2020-05-06 00:00:00
 |  | 2020-05-07 00:00:00
 |  | 2020-05-08 00:00:00
 |  | 2020-05-09 00:00:00
 |  | 2020-05-10 00:00:00
 |  |  | Start | Finish | Break | AM PREM | NORMAL | EVE PREM | PM PREM | Total
 |  | 2020-05-11 00:00:00
 |  | 2020-05-12 00:00:00
 |  | 2020-05-13 00:00:00
 |  | 2020-05-14 00:00:00
 |  | 2020-05-15 00:00:00
 |  | 2020-05-16 00:00:00
 |  | 2020-05-17 00:00:00
 |  |  | Start | Finish | Break | AM PREM | NORMAL | EVE PREM | PM PREM | Total
 |  | 2020-05-18 00:00:00
 |  | 2020-05-19 00:00:00
 |  | 2020-05-20 00:00:00
 |  | 2020-05-21 00:00:00
 |  | 2020-05-22 00:00:00
 |  | 2020-05-23 00:00:00
 |  | 2020-05-24 00:00:00
 |  |  | Start | Finish | Break | AM PREM | NORMAL | EVE PREM | PM PREM | Total
 |  | 2020-05-25 00:00:00
 |  | 2020-05-26 00:00:00
 |  | 2020-05-27 00:00:00
 |  | 2020-05-28 00:00:00
 |  | 2020-05-29 00:00:00
 |  | 2020-05-30 00:00:00
 |  | 2020-05-31 00:00:00
 |  |  | Start | Finish | Break | AM PREM | NORMAL | EVE PREM | PM PREM | Total
[NAME] |  | 2020-06-01 00:00:00
 |  | 2020-06-02 00:00:00
 |  | 2020-06-03 00:00:00
 |  | 2020-06-04 00:00:00
 |  | 2020-06-05 00:00:00
 |  | 2020-06-06 00:00:00
 |  | 2020-06-07 00:00:00
 |  |  | Start | Finish | Break | AM PREM | NORMAL | EVE PREM | PM PREM | Total
 |  | 2020-06-08 00:00:00
 |  | 2020-06-09 00:00:00
 |  | 2020-06-10 00:00:00
 |  | 2020-06-11 00:00:00
 |  | 2020-06-12 00:00:00
 |  | 2020-06-13 00:00:00
 |  | 2020-06-14 00:00:00
 |  |  | Start | Finish | Break | AM PREM | NORMAL | EVE PREM | PM PREM | Total
 |  | 2020-06-15 00:00:00
 |  | 2020-06-16 00:00:00
 |  | 2020-06-17 00:00:00
 |  | 2020-06-18 00:00:00
 |  | 2020-06-19 00:00:00
 |  | 2020-06-20 00:00:00
 |  | 2020-06-21 00:00:00
 |  |  | Start | Finish | Break | AM PREM | NORMAL | EVE PREM | PM PREM | Total
 |  | 2020-06-22 00:00:00
 |  | 2020-06-23 00:00:00
 |  | 2020-06-24 00:00:00
 |  | 2020-06-25 00:00:00
 |  | 2020-06-26 00:00:00
 |  | 2020-06-27 00:00:00
 |  | 2020-06-28 00:00:00
 |  |  | Start | Finish | Break | AM PREM | NORMAL | EVE PREM | PM PREM | Total
 |  | 2020-06-29 00:00:00
 |  | 2020-06-30 00:00:00
 |  | 2020-07-01 00:00:00
 |  | 2020-07-02 00:00:00
 |  | 2020-07-03 00:00:00
 |  | 2020-07-04 00:00:00
 |  | 2020-07-05 00:00:00