Spreadsheet: 802791d1667043624-accumulating-time-based-on-time-values-in-another-cell-timesheet
Sheet: 4 Apr 15 May (2)

 |  |  |  |  |  |  | TEAM 1 |  |  |  |  |  |  |  |  | Name
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 03.04-14.05 |  | 2022
 |  |  |  | SHIFT |  |  |  |  |  | OOH |  | Debit | Debit | Debit | Credit |  | Credit |  | Credit
# | Shift | Weekday | Date | Start day | Lunch | 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 | [NAME] needed | TOIL earned
1 | Day | Monday | 2022-04-04 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00 | 10:00:00 |  |  |  | Annual leave
2 | Day | Tuesday | 2022-04-05 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00 | 5:00:00 |  |  |  | Half day leave
3 | Rest | Wednesday | 2022-04-06 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
4 | Rest | Thursday | 2022-04-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
5 | Rest | Friday | 2022-04-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
6 | Rest | Saturday | 2022-04-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
7 | Rest | Sunday | 2022-04-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
8 | Rest | Monday | 2022-04-11 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00 |  | 10:00:00 |  |  | SWY
9 | Rest | Tuesday | 2022-04-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
10 | Night | Wednesday | 2022-04-13 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00
11 | Night | Thursday | 2022-04-14 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00 |  |  | 10:00:00 |  | PH day taken
12 | Night | Friday | 2022-04-15 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00
13 | Night | Saturday | 2022-04-16 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00 |  |  | 5:00:00 |  | Half PH day taken
14 | Rest | Sunday | 2022-04-17 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
15 | Rest | Monday | 2022-04-18 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] is needed in Col S, not col R apologies that is my error
16 | Rest | Tuesday | 2022-04-19 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00
17 | Day | Wednesday | 2022-04-20 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00
18 | Day | Thursday | 2022-04-21 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00
19 | Day | Friday | 2022-04-22 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00
20 | Rest | Saturday | 2022-04-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
21 | Night | Sunday | 2022-04-24 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00
22 | Night | Monday | 2022-04-25 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00
23 | Night | Tuesday | 2022-04-26 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00
24 | Rest | Wednesday | 2022-04-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
25 | Rest | Thursday | 2022-04-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
26 | Rest | Friday | 2022-04-29 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
27 | Day | Saturday | 2022-04-30 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00
28 | Day | Sunday | 2022-05-01 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00
29 | Day | Monday | 2022-05-02 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00
30 | Day | Tuesday | 2022-05-03 00:00:00 | 7:00:00 | 12:00:00 | 12:40:00 | 16:00:00 | 16:20:00 | 19:00:00 | 0:00:00 | 0:00:00
31 | Rest | Wednesday | 2022-05-04 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
32 | Rest | Thursday | 2022-05-05 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
33 | Rest | Friday | 2022-05-06 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
34 | Rest | Saturday | 2022-05-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
35 | Rest | Sunday | 2022-05-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
36 | Rest | Monday | 2022-05-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
37 | Rest | Tuesday | 2022-05-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
38 | Night | Wednesday | 2022-05-11 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00
39 | Night | Thursday | 2022-05-12 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00
40 | Night | Friday | 2022-05-13 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00
41 | Night | Saturday | 2022-05-14 00:00:00 | 19:00:00 | 0:00:00 | 0:40:00 | 5:00:00 | 5:20:00 | 7:00:00 | 0:00:00 | 0:00:00
42 | Rest | Sunday | 2022-05-15 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net hours worked
 |  |  |  |  |  |  |  |  |  |  | Dated |  |  |  |  | Target |  |  |  | 11:05:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target Met
 |  |  | Signed
 |  |  | Approved |  |  |  |  |  |  |  |  |  |  |  |  | Other Leaves
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday accrued
 |  |  |  |  |  | ANNUAL LEAVE |  |  |  |  |  |  |  |  |  | TOIL this month (TOIL accrued)
 |  |  |  |  |  | Hours owed |  |  |  |  |  |  |  |  |  | TOIL from previous month |  |  |  |  | 5:32:00
 |  |  |  |  |  | Hours taken |  |  |  |  |  |  |  |  |  | Public Holiday/TOIL taken |  |  |  |  | 11:05:00 |  | 21:00:00 | 0:00:00
 |  |  |  |  |  | Balance |  |  |  |  |  |  |  |  |  | Total TOIL (TOIL left)