Spreadsheet: 807878d1670125522-apply-different-penalty-rates-over-a-24-hr-period-pay-calculator_rev-08c
Sheet: Work Calculator

Employee Name : |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Penalty #1: Start < 7:00am and Finish > 7:00am, pro-rata on hourly basis for Start Time
Employee Staff # : |  | 894378 | Classification : | Bus Operator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Penalty #2: Start < 5:00pm and Finish > 8:00pm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Penalty #2: Start > 8:30pm and Finish < 7:00am
DATE | DAY | SHIFT [NAME] | SHIFT PENALTY/EXTRA ADD-ONS |  |  | SHIFT # |  | PRE-START OVERTIME |  |  |  |  | 1st. HALF |  |  | UNPAID BREAK | 2nd. HALF |  |  |  | TOTAL HOURS WORKED |  | BALANCE OF TIME DUE FOR PAYMENT | TOTAL SPREAD |  | [NAME] (VOT) PLUS ALL ROSTERED WORK THAT EXCEEDS 8.25hrs                                                                                                                                           That is any work that is rostered or voluntarily accepted in a shift that exceeds 8.25 hrs |  |  |  |  |  |  |  |  |  |  | EARLY-LATE PENALTY RATE HOURS |  | BROKEN SHIFT PENALTY |  |  |  |  | PUBLIC HOLIDAY |  |  |  | ROSTERED DAY OFF CANCELLED                (RDOC) |  |  | ADO | ALLOCATED DAY OFF CANCELLED                            (ADOC) |  |  |  | 1st. HALF
 |  |  | ADD-ON #1 | ADD-ON #2 | ADD-ON #3 |  |  | START | END | [NAME]:mins | [NAME] |  | START | END | HOURS WORKED |  | START | END | HOURS WORKED |  | Hrs:mins | [NAME] |  |  |  | START | END | [NAME]:mins | [NAME] |  | TOTAL HOURS WORKED | DEFAULT HOURS PAID |  | 0.5 | 1 |  | 1st. HALF | 2nd. HALF | TOTAL HOURS | DEFAULT HOURS PAID | 9.5-10.5 hours | After 10.5 hours |  | HOURS WORKED | +DEFAULT HOURS | NO WORK |  | HOURS WORKED | 1½ | DOUBLE |  | ADO DEFAULT | 1½ | DOUBLE |  | Penalty #1 Hours | Penalty #2 Hours | Penalty #2 Hours | Total Penalty Hours
WEEK 1
2022-09-18 00:00:00 | Sunday | Normal/Straight | Nil | Nil | No Build-Up Time | D831 |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 10:40:00 | 14:44:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 0 | N/A | 0 |  |  |  |  | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-09-19 00:00:00 | Monday | [NAME] | ADOC | High Capacity Allowance | Nil | A106 |  | 00:00:00 | 00:00:00 |  |  |  | 04:30:00 | 08:30:00 |  |  | 09:30:00 | 13:30:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0
2022-09-20 00:00:00 | Tuesday | [NAME] | Nil | High Capacity Allowance | Nil | A144 |  | 00:00:00 | 00:00:00 |  |  |  | 12:30:00 | 16:30:00 |  |  | 17:30:00 | 21:30:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0
2022-09-21 00:00:00 | Wednesday | [NAME] | Nil | High Capacity Allowance | Nil | 9A122 |  | 00:00:00 | 00:00:00 |  |  |  | 20:30:00 | 00:30:00 |  |  | 01:30:00 | 05:30:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0
2022-09-22 00:00:00 | Thursday | Normal/Straight | Nil | Nil | Nil | D774 |  | 00:00:00 | 00:00:00 |  |  |  | 16:59:00 | 20:01:00 |  |  | 21:00:00 | 00:00:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0
2022-09-23 00:00:00 | Friday | [NAME] | Nil | High Capacity Allowance | Nil | 8A180 |  | 00:00:00 | 00:00:00 |  |  |  | 20:31:00 | 06:59:00 |  |  | 08:00:00 | 00:00:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0
2022-09-24 00:00:00 | Saturday | Day Off - No Pay | Nil | Nil | No Build-Up Time | D789 |  | 00:00:00 | 00:00:00 |  |  |  | 07:00:00 | 12:30:00 |  |  | 13:30:00 | 00:00:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | z |  |  |  | Week 1 Totals :
WEEK 2
2022-09-25 00:00:00 | Sunday | Day Off - No Pay | Nil | Nil | No Build-Up Time | D869 |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 0 | N/A | 0 |  |  |  |  | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
2022-09-26 00:00:00 | Monday | [NAME] | Nil | High Capacity Allowance | Nil | A144 |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0
2022-09-27 00:00:00 | Tuesday | [NAME] | Nil | High Capacity Allowance | Nil | A154 |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0
2022-09-28 00:00:00 | Wednesday | Day Off - No Pay | Nil | Nil | No Build-Up Time |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0
2022-09-29 00:00:00 | Thursday | [NAME] | Nil | Nil | Nil | A110 |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0
2022-09-30 00:00:00 | Friday | [NAME] | Nil | Nil | Nil | A112 |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0
2022-10-01 00:00:00 | Saturday | Normal/Straight | Nil | Nil | Nil | D736 |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | Week 2 Totals :
 |  |  |  |  |  | COMBINED TOTAL :