Spreadsheet: 810209d1671610246-how-to-add-criteria-in-a-formula-trial-timesheet-22
Sheet: 26 Dec 22 Jan 23

Rosslare Port |  |  |  |  |  |  |  |  |  |  |  |  | Team 2 |  |  |  |  | Name
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  |  | SHIFT |  |  |  |  |  |  |  | OOH |  | Debit | Debit | Debit | Debit | Credit |  | Credit | Compensation hrs | 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 | Daily time | 0:00:00 | TOIL earned
2022-12-26 00:00:00 | Day | Monday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  |  |  |  |  |  | PH Accrued |  |  |  | 07:00:00 | 10:00:00
2022-12-27 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 |  |  |  |  |  |  |  | PH Accrued |  |  |  | 07:00:00 | 10:00:00
2022-12-28 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 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2022-12-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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2022-12-30 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 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2022-12-31 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 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-01 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 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-02 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 |  |  |  | 07:00:00 | 10:00:00
2023-01-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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-05 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 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-06 00:00:00 | Day | Friday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-07 00:00:00 | Day | Saturday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-08 00:00:00 | Day | Sunday | 7:00:00 | 10:00:00 | 10:20:00 | 12:00:00 | 12:28:00 | 16:00:00 | 16:12:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-10 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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-11 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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-12 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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-13 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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-16 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 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-17 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 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-18 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 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-19 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 |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-20 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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-21 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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
2023-01-22 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 |  |  |  |  |  |  |  |  |  | 07:00:00 | 10:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COMP Balance
 |  |  |  |  |  |  |  |  |  |  |  | Dated |  |  |  |  |  | Net Hours Worked
Signed
Approved
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other leaves
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday c/f
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Publc Holiday accrued
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday/Toil used
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Toil this month (toil accrued)
 |  |  |  |  |  |  |  |  |  |  | ANNUAL LEAVE |  |  |  |  |  |  | Toil from previous month
 |  |  |  |  |  |  |  |  |  |  | Hours owed |  |  |  |  |  |  | Toil used
 |  |  |  |  |  |  |  |  |  |  | Hours taken |  |  |  |  |  |  | Compensatory hrs used
 |  |  |  |  |  |  |  |  |  |  | Balance |  |  |  |  |  |  | Total toil (toll left)