Spreadsheet: 865585d1712650673-adding-merging-a-formula-with-an-existing-formula-to-capture-2-conditions-pay-calculator_2024_rev-04_forum-version
Sheet: Work Calculator

 |  |  |  |  | Bus Operator
DATE | DAY | SHIFT [NAME] | PAY CLASSIFICATION | SHIFT PENALTY/EXTRA ADD-ONS |  |  | SHIFT # |  | PRE-START VOLUNTARY OVERTIME |  |  |  | 1st. HALF |  |  |  | 1st. HALF LATE RUN TIME |  |  | VOLUNTARY OVERTIME DURING BREAK |  |  |  | 1st. HALF PAID CRIB / PAID MEAL BREAK |  |  |  | UNPAID BREAK |  | MIDDLE SESSION |  |  |  | 2nd. HALF |  |  |  | 2nd. HALF LATE RUN TIME |  |  | 2nd. HALF PAID CRIB / PAID MEAL BREAK |  |  |  | [NAME] (VOT) |  |  |  | TOTAL HOURS WORKED |  | ADO BUILD-UP TIME DEDUCTED (Mins) |  | BALANCE OF TIME DUE FOR PAYMENT | DEFAULT HOURS PAID AT NORMAL RATE | HOURS PAID AT 150% | HOURS PAID AT 200% |  | TIME WORKED SPREAD HOURS | BROKEN SHIFT PENALTY |  |  |  |  | PUBLIC HOLIDAY |  |  |  | ROSTERED DAY OFF CANCELLED (RDOC)                                             STRAIGHT SHIFT |  |  | ROSTERED DAY OFF CANCELLED  (RDOC)                                                    BROKEN SHIFT |  |  |  | RDOC BOTH SHIFTS |  | ALLOCATED DAY OFF CANCELLED (ADOC)                                             STRAIGHT SHIFT |  |  |  | ALLOCATED DAY OFF CANCELLED  (ADOC)                                                    BROKEN SHIFT |  |  |  |  | ADOC BOTH SHIFTS |  |  |  | ADO |  | ANNUAL LEAVE | SICK DAY
 |  |  |  | ADD-ON #1 | ADD-ON #2 | ADD-ON #3 |  |  | START | END | [NAME]:mins |  | START | END | HOURS WORKED |  | END | TIME WORKED                  Hrs:mins |  | START | END | [NAME]:mins |  | START | END | [NAME]:mins |  |  |  | START | END | HOURS WORKED |  | START | END | HOURS WORKED |  | TIME | TIME WORKED                  Hrs:mins |  | START | END | [NAME]:mins |  | START | END | [NAME]:mins |  | Hrs:mins | [NAME] | Hrs:mins | [NAME] |  |  |  |  |  |  | TOTAL SPREAD HOURS | DEFAULT HOURS PAID | 9.5-10.5 hours | After 10.5 hours |  | HOURS WORKED | + PUBLIC HOLIDAY | NO WORK |  | HOURS WORKED | 1½ | DOUBLE | HOURS WORKED | HOURS WORKED | 1½ | DOUBLE | 1½ | DOUBLE | ADO DEFAULT | HOURS WORKED | 1½ | DOUBLE | ADO DEFAULT | HOURS WORKED | HOURS WORKED | 1½ | DOUBLE | ADO DEFAULT | 1½ | DOUBLE
WEEK 1
2024-01-07 00:00:00 | Sunday | Normal/Straight | Bus Operator | Nil | Nil | No Build-Up Time | d123 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 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 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | N/A |  | N/A | N/A
2024-01-08 00:00:00 | Monday | Normal/Straight | Bus Operator | Nil | Nil | Nil | D020 |  | 00:00:00 | 00:00:00 |  |  | 07:00:00 | 11:55:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 12:45:00 | 17:25:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
2024-01-09 00:00:00 | Tuesday | Normal/Straight | Bus Operator | Public Holiday+Work | Nil | Nil | A158 |  | 00:00:00 | 00:00:00 |  |  | 07:00:00 | 11:55:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 12:45:00 | 17:25:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
2024-01-10 00:00:00 | Wednesday | Normal/Straight | Bus Operator | RDOC | Nil | Nil | A154 |  | 00:00:00 | 00:00:00 |  |  | 07:00:00 | 11:55:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 12:45:00 | 17:25:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
2024-01-11 00:00:00 | Thursday | Normal/Straight | Bus Operator | Public Holiday+Work | Nil | No Build-Up Time | A152 |  | 00:00:00 | 00:00:00 |  |  | 07:00:00 | 11:55:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 12:45:00 | 17:25:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
2024-01-12 00:00:00 | Friday | Normal/Straight | Bus Operator | Public Holiday+Work | Nil | No Build-Up Time | A156 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 09:35:00 |  |  |  |  | 0 | 0 | 0
2024-01-13 00:00:00 | Saturday | Normal/Straight | Bus Operator | Nil | Nil | Nil | 7D581 |  | 00:00:00 | 00:00:00 |  |  | 07:00:00 | 11:55:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 12:45:00 | 17:25:00 |  |  | 00:10:00 |  |  | 00:23:00 | 00:53:00 |  |  | 1900-01-01 00:53:00 | 1900-01-01 02:14:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  | N/A | N/A
 |  |  |  |  |  |  | Week 1 Totals :
WEEK 2
2024-01-14 00:00:00 | Sunday | Day Off - No Pay | Bus Operator | Nil | Nil | No Build-Up Time | Nil |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 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 |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | N/A |  | N/A | N/A
2024-01-15 00:00:00 | Monday | [NAME] | Bus Operator | Nil | High Capacity Allowance | Nil | A144 |  | 00:00:00 | 00:00:00 |  |  | 07:15:00 | 11:59:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 16:09:00 | 19:14:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
2024-01-16 00:00:00 | Tuesday | [NAME] | Bus Operator | Nil | High Capacity Allowance | Nil | A138 |  | 00:00:00 | 00:00:00 |  |  | 07:10:00 | 09:24:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 14:12:00 | 19:08:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
2024-01-17 00:00:00 | Wednesday | [NAME] | Bus Operator | RDOC | High Capacity Allowance | No Build-Up Time | A134 |  | 00:00:00 | 00:00:00 |  |  | 07:05:00 | 09:23:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 14:08:00 | 18:58:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
2024-01-18 00:00:00 | Thursday | [NAME] | Bus Operator | Nil | High Capacity Allowance | Nil | A162 |  | 00:00:00 | 00:00:00 |  |  | 07:54:00 | 12:47:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 15:48:00 | 19:50:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
2024-01-19 00:00:00 | Friday | [NAME] | Bus Operator | Nil | High Capacity Allowance | Nil | A160 |  | 00:00:00 | 00:00:00 |  |  | 07:45:00 | 12:27:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 15:28:00 | 19:39:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00
2024-01-20 00:00:00 | Saturday | Normal/Straight | Bus Operator | Nil | Nil | Nil | D756 |  | 00:00:00 | 00:00:00 |  |  | 05:52:00 | 09:37:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 00:00:00 | 00:00:00 |  |  | 10:27:00 | 14:10:00 |  |  | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  | N/A | N/A
 |  |  |  |  |  |  | Week 2 Totals :
 |  |  |  |  |  |  | COMBINED TOTAL :