Spreadsheet: 864598d1711703807-using-if-or-for-three-outcomes-three-outcomes-updated
Sheet: 25 Mar 21 Apr

 |  |  |  |  |  |  |  |  |  |  |  |  |  | TEAM 2A |  |  | Name |  |  | Gabriele Kuehnel
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month |  |  |  | 2025
 |  |  | SHIFT |  |  |  |  |  |  |  | Out of Hours |  | Debit | Debit | Debit | Credit |  | A/L, TOIL |  | Credit | Credit
Date | Shift | Weekday | Start day | Lunch | Break | Back from break | Back from lunch | Break | Back from break | Finish day | Start meeting | End meeting | Annual Leave | Other Leaves | PH/TOIL taken | Public Holiday | Comments | Approved by | Date Approved | Daily time | TOIL earned
2021-03-24 00:00:00 | Rest | Tuesday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-03-25 00:00:00 | Rest | Wednesday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-03-26 00:00:00 | Rest | Thursday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-03-27 00:00:00 | Rest | Friday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-03-28 00:00:00 | Rest | Saturday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-03-29 00:00:00 | Rest | Sunday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-03-30 00:00:00 | Rest | Monday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-03-31 00:00:00 | Night | Tuesday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-01 00:00:00 | Night | Wednesday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-02 00:00:00 | Night | Thursday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-03 00:00:00 | Night | Friday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-04 00:00:00 | Rest | Saturday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-05 00:00:00 | Rest | Sunday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-06 00:00:00 | Rest | Monday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-07 00:00:00 | Day | Tuesday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-08 00:00:00 | Day | Wednesday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-09 00:00:00 | Day | Thursday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-10 00:00:00 | Rest | Friday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-11 00:00:00 | Night | Saturday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-12 00:00:00 | Night | Sunday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-13 00:00:00 | Night | Monday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-14 00:00:00 | Rest | Tuesday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-15 00:00:00 | Rest | Wednesday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-16 00:00:00 | Rest | Thursday | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-17 00:00:00 | Day | Friday | 6:55:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:38:00 | 16:00:00 | 16:12:00 | 19:05:00 |  |  |  |  |  |  | PH Accrued |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-18 00:00:00 | Day | Saturday | 6:55:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:38:00 | 16:00:00 | 16:12:00 | 19:05:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-19 00:00:00 | Day | Sunday | 6:55:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:38:00 | 16:00:00 | 16:12:00 | 19:05:00 |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
2021-04-20 00:00:00 | Day | Monday | 6:55:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:38:00 | 16:00:00 | 16:12:00 | 19:05:00 |  |  |  |  |  |  | PH Accrued |  |  |  |  | 7:00:00 | 11:00:00 | 03:30:00
 |  |  |  |  |  |  |  |  |  |  |  | Dated
Signed
Approved
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other leaves
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday from previous month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday accrued
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday Toil used
 |  |  |  |  |  |  |  |  |  |  | ANNUAL LEAVE |  |  |  |  |  | PH Toil left
 |  |  |  |  |  |  |  |  |  |  | ANNUAL LEAVE |  |  |  |  |  | Toil this month (toil accrued)
 |  |  |  |  |  |  |  |  |  |  | Hours owed |  |  |  |  |  | Toil from previous month
 |  |  |  |  |  |  |  |  |  |  | Hours taken |  |  |  |  |  | TOIL Used
 |  |  |  |  |  |  |  |  |  |  | Balance |  |  |  |  |  | Total TOIL (toll left)