Spreadsheet: 803572d1667557033-accumulating-time-based-on-time-values-in-another-cell-trial-flexi
Sheet: 23 Jan 5 Mar

 |  |  |  |  |  |  |  |  | TEAM 1 |  |  |  |  |  |  |  |  | Name
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 23.01 - 05.03 |  |  | 2023
 |  |  |  | SHIFT |  |  |  |  |  |  |  | OOH |  | Debit | Debit | Debit | Credit |  | Credit |  | Compensation hrs | Credit
# | Shift | Weekday | Date | 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 | Daily time |  |  | TOIL earned
1 | Rest | Monday | 2023-01-23 00: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 | 0:00:00 |  |  |  |  |  |  |  |  |  |  | 0:00:00
2 | Day | Tuesday | 2023-01-24 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  | 10:00:00 |  |  |  | Annual Leave |  |  |  |  |  | 1:00:00
3 | Day | Wednesday | 2023-01-25 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00
4 | Day | Thursday | 2023-01-26 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  | 10:00:00 |  |  |  | Annual Leave
5 | Rest | Friday | 2023-01-27 00: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 | 0:00:00
6 | Night | Saturday | 2023-01-28 00:00:00 | 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 | Night | Sunday | 2023-01-29 00:00:00 | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00
8 | Night | Monday | 2023-01-30 00:00:00 | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00
9 | Rest | Tuesday | 2023-01-31 00: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 | 0:00:00
10 | Rest | Wednesday | 2023-02-01 00: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 | 0:00:00 |  |  |  | 7:00:00 | Public Holiday
11 | Rest | Thursday | 2023-02-02 00: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 | 0:00:00
12 | Day | Friday | 2023-02-03 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  |  |  |  |  | Flexi taken
13 | Day | Saturday | 2023-02-04 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00
14 | Day | Sunday | 2023-02-05 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00
15 | Day | Monday | 2023-02-06 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00
16 | Rest | Tuesday | 2023-02-07 00: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 | 0:00:00
17 | Rest | Wednesday | 2023-02-08 00: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 | 0:00:00
18 | Rest | Thursday | 2023-02-09 00: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 | 0:00:00
19 | Rest | Friday | 2023-02-10 00: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 | 0:00:00
20 | Rest | Saturday | 2023-02-11 00: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 | 0:00:00
21 | Rest | Sunday | 2023-02-12 00: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 | 0:00:00
22 | Rest | Monday | 2023-02-13 00: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 | 0:00:00
23 | Night | Tuesday | 2023-02-14 00:00:00 | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00
24 | Night | Wednesday | 2023-02-15 00:00:00 | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00 |  |  |  |  |  |  | Half Flexi
25 | Night | Thursday | 2023-02-16 00:00:00 | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00 |  |  | 10:00:00
26 | Night | Friday | 2023-02-17 00:00:00 | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00 |  |  |  | 10:00:00
27 | Rest | Saturday | 2023-02-18 00: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 | 0:00:00
28 | Rest | Sunday | 2023-02-19 00: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 | 0:00:00
29 | Rest | Monday | 2023-02-20 00: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 | 0:00:00
30 | Day | Tuesday | 2023-02-21 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  |  |  | 5:00:00
31 | Day | Wednesday | 2023-02-22 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00
32 | Day | Thursday | 2023-02-23 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00
33 | Rest | Friday | 2023-02-24 00: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 | 0:00:00
34 | Night | Saturday | 2023-02-25 00:00:00 | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00
35 | Night | Sunday | 2023-02-26 00:00:00 | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00
36 | Night | Monday | 2023-02-27 00:00:00 | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:12:00 | 7:00:00
37 | Rest | Tuesday | 2023-02-28 00: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 | 0:00:00
38 | Rest | Wednesday | 2023-03-01 00: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 | 0:00:00
39 | Rest | Thursday | 2023-03-02 00: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 | 0:00:00
40 | Day | Friday | 2023-03-03 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00
41 | Day | Saturday | 2023-03-04 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00
42 | Day | Sunday | 2023-03-05 00:00:00 | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLEXI Balance
 |  |  |  |  |  |  |  |  |  |  |  |  | Dated |  |  |  |  | Net Hours Worked
 |  |  | Signed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target Met
 |  |  | Approved
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other leaves
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compensatory taken
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Publc Holiday accrued
 |  |  |  |  |  |  |  | ANNUAL LEAVE |  |  |  |  |  |  |  |  |  | Toil this month (toll accrued)
 |  |  |  |  |  |  |  | Hours owed | 9 days, 6:00:00 |  |  |  |  |  |  |  |  | Toil from previous month
 |  |  |  |  |  |  |  | Hours taken |  |  |  |  |  |  |  |  |  | Public Holiday/Toil taken |  |  |  |  |  | 5:30:00
 |  |  |  |  |  |  |  | Balance |  |  |  |  |  |  |  |  |  | Total toil (toll left) |  |  |  |  |  | 11:00:00 |  | 21:00:00