Spreadsheet: 850155d1700537537-identify-weekday-and-public-holiday-clocking
Sheet: Sheet1

DATE | IN | OUT | TOTAL HOURS | Day | Type |  | Holiday Name | Date | Type
2023-01-09 00:00:00 | 03:56:00 | 08:04:00 | 04:08:00 |  |  |  | New Year's Day | 2023-01-01 00:00:00 | PH(non-working)
2023-01-10 00:00:00 | 04:00:00 | 08:04:00 | 04:04:00 |  |  |  | New Year's Day | 2023-01-02 00:00:00 | PH(non-working)
2023-01-11 00:00:00 | 03:59:00 | 08:08:00 | 04:09:00 |  |  |  | Australia Day | 2023-01-26 00:00:00 | PH(non-working)
2023-01-12 00:00:00 | 03:57:00 | 08:04:00 | 04:07:00 |  |  |  | Labour Day | 2023-03-13 00:00:00 | PH(working)
2023-01-13 00:00:00 | 03:59:00 | 08:00:00 | 04:01:00 |  |  |  | Good Friday | 2023-04-07 00:00:00 | PH(non-working)
2023-01-16 00:00:00 | 03:58:00 | 08:04:00 | 04:06:00 |  |  |  | Easter Saturday | 2023-04-08 00:00:00 | PH(non-working)
2023-01-17 00:00:00 | 03:58:00 | 08:02:00 | 04:04:00 |  |  |  | Easter Sunday | 2023-04-09 00:00:00 | PH(non-working)
2023-01-18 00:00:00 | 03:59:00 | 08:00:00 | 04:01:00 |  |  |  | Easter Monday | 2023-04-10 00:00:00 | PH(non-working)
2023-01-19 00:00:00 | 04:00:00 | 08:07:00 | 04:07:00 |  |  |  | Easter Tuesday | 2024-04-11 00:00:00 | PH(non-working)
2023-01-20 00:00:00 | 04:00:00 | 08:02:00 | 04:02:00 |  |  |  | Anzac Day | 2023-04-25 00:00:00 | PH(non-working)
2023-01-23 00:00:00 | 03:58:00 | 08:03:00 | 04:05:00 |  |  |  | King's Birthday | 2023-06-12 00:00:00 | PH(working)
2023-01-25 00:00:00 | 04:02:00 | 08:06:00 | 04:04:00 |  |  |  | AFL Grand Final Friday | 2023-09-29 00:00:00 | PH(non-working)
2023-01-27 00:00:00 | 04:00:00 | 08:00:00 | 04:00:00 |  |  |  | Melbourne Cup Day | 2023-11-07 00:00:00 | PH(working)
2023-01-30 00:00:00 | 04:01:00 | 08:04:00 | 04:03:00 |  |  |  | Christmas Day | 2023-12-25 00:00:00 | PH(non-working)
2023-01-31 00:00:00 | 04:01:00 | 08:16:00 | 04:15:00 |  |  |  | Boxing Day | 2023-12-26 00:00:00 | PH(non-working)
2023-02-01 00:00:00 | 04:01:00 | 08:06:00 | 04:05:00
2023-02-02 00:00:00 | 04:03:00 | 08:05:00 | 04:02:00
2023-02-03 00:00:00 | 04:04:00 | 08:01:00 | 03:57:00
2023-02-06 00:00:00 | 04:02:00 | 08:04:00 | 04:02:00
2023-02-07 00:00:00 | 03:59:00 | 08:04:00 | 04:05:00
2023-02-08 00:00:00 | 04:02:00 | 08:05:00 | 04:03:00
2023-02-09 00:00:00 | 03:59:00 | 07:58:00 | 03:59:00
2023-02-10 00:00:00 | 03:58:00 | 08:11:00 | 04:13:00
2023-02-13 00:00:00 | 03:59:00 | 08:01:00 | 04:02:00
2023-02-14 00:00:00 | 04:02:00 | 08:09:00 | 04:07:00
2023-02-15 00:00:00 | 04:04:00 | 08:09:00 | 04:05:00
2023-02-16 00:00:00 | 04:01:00 | 07:51:00 | 03:50:00
2023-02-17 00:00:00 | 04:01:00 | 08:07:00 | 04:06:00
2023-02-20 00:00:00 | 04:35:00 | 08:30:00 | 03:55:00
2023-02-21 00:00:00 | 03:58:00 | 08:03:00 | 04:05:00
2023-02-22 00:00:00 | 03:59:00 | 08:06:00 | 04:07:00
2023-02-23 00:00:00 | 03:59:00 | 08:06:00 | 04:07:00
2023-02-24 00:00:00 | 04:00:00 | 08:05:00 | 04:05:00
2023-02-27 00:00:00 | 03:59:00 | 08:00:00 | 04:01:00
2023-02-28 00:00:00 | 03:59:00 | 08:07:00 | 04:08:00
2023-03-01 00:00:00 | 04:01:00 | 08:23:00 | 04:22:00
2023-03-03 00:00:00 | 04:01:00 | 07:59:00 | 03:58:00
2023-03-06 00:00:00 | 04:01:00 | 08:01:00 | 04:00:00
2023-03-07 00:00:00 | 03:56:00 | 08:03:00 | 04:07:00
2023-03-08 00:00:00 | 04:04:00 | 08:08:00 | 04:04:00
2023-03-09 00:00:00 | 04:12:00 | 08:08:00 | 03:56:00
2023-03-10 00:00:00 | 04:02:00 | 08:00:00 | 03:58:00
2023-03-13 00:00:00 | 04:02:00 | 08:08:00 | 04:06:00
2023-03-14 00:00:00 | 04:02:00 | 08:02:00 | 04:00:00
2023-03-15 00:00:00 | 04:02:00 | 08:07:00 | 04:05:00
2023-03-16 00:00:00 | 03:58:00 | 08:19:00 | 04:21:00
2023-03-17 00:00:00 | 04:01:00 | 08:11:00 | 04:10:00
2023-03-20 00:00:00 | 04:03:00 | 08:11:00 | 04:08:00
2023-03-21 00:00:00 | 04:01:00 | 08:02:00 | 04:01:00
2023-03-22 00:00:00 | 04:01:00 | 08:02:00 | 04:01:00
2023-03-23 00:00:00 | 03:57:00 | 08:05:00 | 04:08:00
2023-03-24 00:00:00 | 04:05:00 | 08:15:00 | 04:10:00
2023-03-27 00:00:00 | 04:01:00 | 08:15:00 | 04:14:00
2023-03-28 00:00:00 | 04:01:00 | 08:12:00 | 04:11:00
2023-03-29 00:00:00 | 04:00:00 | 08:06:00 | 04:06:00
2023-03-30 00:00:00 | 04:01:00 | 07:59:00 | 03:58:00
2023-03-31 00:00:00 | 04:00:00 | 08:13:00 | 04:13:00
2023-04-04 00:00:00 | 03:59:00 | 08:01:00 | 04:02:00
2023-04-05 00:00:00 | 04:06:00 | 08:04:00 | 03:58:00
2023-04-06 00:00:00 | 05:13:00 | 09:16:00 | 04:03:00
2023-04-17 00:00:00 | 04:02:00 | 08:02:00 | 04:00:00
2023-04-18 00:00:00 | 04:02:00 | 08:02:00 | 04:00:00
2023-04-19 00:00:00 | 03:59:00 | 08:08:00 | 04:09:00
2023-04-20 00:00:00 | 04:01:00 | 08:07:00 | 04:06:00
2023-04-21 00:00:00 | 04:01:00 | 08:11:00 | 04:10:00
2023-04-24 00:00:00 | 03:59:00 | 08:09:00 | 04:10:00
2023-04-26 00:00:00 | 03:57:00 | 08:12:00 | 04:15:00
2023-04-27 00:00:00 | 03:52:00 | 08:14:00 | 04:22:00
2023-04-28 00:00:00 | 03:58:00 | 08:05:00 | 04:07:00
2023-05-01 00:00:00 | 04:00:00 | 08:08:00 | 04:08:00
2023-05-02 00:00:00 | 03:58:00 | 08:10:00 | 04:12:00
2023-05-03 00:00:00 | 03:58:00 | 08:10:00 | 04:12:00
2023-05-04 00:00:00 | 03:55:00 | 08:03:00 | 04:08:00
2023-05-05 00:00:00 | 04:03:00 | 08:02:00 | 03:59:00