Spreadsheet: 828730d1683715309-accumulating-time-based-on-time-values-in-another-cell-timesheet
Sheet: 7 Mar 17 Apr

 |  |  |  |  |  |  |  | TEAM 1 |  |  |  |  |  | TEAM 1 |  |  |  | Name
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  |  | SHIFT |  |  |  |  |  |  |  | Out of Hours |  | Debit | Debit | Debit | Debit | Credit |  | A/L, TOIL, Comp |  | Credit | Compensation hours | 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 | Comp hours | Public Holiday | Comments | Approved by | Date Approved | Daily time |  | TOIL earned
2019-03-06 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 | 10:00:00
2019-03-07 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 | 10:00:00
2019-03-08 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 | 10:00:00
2019-03-09 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 | 10:00:00
2019-03-10 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 | 10:00:00
2019-03-11 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 | 10:00:00
2019-03-12 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 | 10:00:00
2019-03-13 00:00:00 | Night | Tuesday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-14 00:00:00 | Night | Wednesday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-15 00:00:00 | Night | Thursday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-16 00:00:00 | Night | Friday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  | PH Accrued |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-17 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 | 10:00:00
2019-03-18 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 | 10:00:00
2019-03-19 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 | 10:00:00
2019-03-20 00:00:00 | Day | Tuesday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:07:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-21 00:00:00 | Day | Wednesday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:07:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-22 00:00:00 | Day | Thursday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:07:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-23 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 | 10:00:00
2019-03-24 00:00:00 | Night | Saturday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-25 00:00:00 | Night | Sunday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-26 00:00:00 | Night | Monday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-27 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 | 10:00:00
2019-03-28 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 | 10:00:00
2019-03-29 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 | 10:00:00
2019-03-30 00:00:00 | Day | Friday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:07:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-03-31 00:00:00 | Day | Saturday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:07:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-04-01 00:00:00 | Day | Sunday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:07:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-04-02 00:00:00 | Day | Monday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:07:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-04-03 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 | 10:00:00
2019-04-04 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 | 10:00:00
2019-04-05 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 | 10:00:00
2019-04-06 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 | Good Friday |  |  |  |  |  | 7:00:00 | 10:00:00
2019-04-07 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 | 10:00:00
2019-04-08 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 | 10:00:00
2019-04-09 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 | PH Accrued |  |  |  |  |  | 7:00:00 | 10:00:00
2019-04-10 00:00:00 | Night | Tuesday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-04-11 00:00:00 | Night | Wednesday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-04-12 00:00:00 | Night | Thursday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-04-13 00:00:00 | Night | Friday | 19:00:00 | 21:00:00 | 21:20:00 | 0:00:00 | 0:28:00 | 5:00:00 | 5:07:00 | 7:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7:00:00 | 10:00:00 | 00:05:00
2019-04-14 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 | 10:00:00
2019-04-15 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 | 10:00:00
2019-04-16 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 | 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comp TOIL earned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comp TOIL Used
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMP Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMP c/f |  |  |  |  |  | 05:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Dated
Signed
Approved
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other leaves
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday from previous month |  |  |  |  | 0:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday accrued
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday Toil used
 |  |  |  |  |  |  |  |  |  |  | ANNUAL LEAVE |  |  |  |  |  |  | PH Toil left
 |  |  |  |  |  |  |  |  |  |  | New Leave |  |  |  |  |  |  | Toil this month (toil accrued)
 |  |  |  |  |  |  |  |  |  |  | Hours owed | 0:00:00 |  |  |  |  |  | Toil from previous month |  |  |  |  | 0:00:00
 |  |  |  |  |  |  |  |  |  |  | Hours taken |  |  |  |  |  |  | TOIL Used
 |  |  |  |  |  |  |  |  |  |  | Balance |  |  |  |  |  |  | Total Toil (Toil left)