Spreadsheet: 835944d1688994052-if-formula-to-calculate-work-hours-in-span-hours-template
Sheet: PH's

2015-01-01 00:00:00 | New Year's Day | Public Holiday
2015-01-26 00:00:00 | Australia Day | Public Holiday
2015-04-03 00:00:00 | Good Friday | Public Holiday
2015-04-04 00:00:00 | Easter Saturday | Public Holiday
2015-04-06 00:00:00 | Easter Monday | Public Holiday
2015-04-25 00:00:00 | Anzac Day | Public Holiday
2015-05-04 00:00:00 | May Day | Public Holiday
2015-06-08 00:00:00 | Queen's Birthday | Public Holiday
2015-06-26 00:00:00 | Borroloola Show Day | Regional Public Holiday
2015-07-03 00:00:00 | [NAME] | Regional Public Holiday
2015-07-10 00:00:00 | Tennant Creek Show Day | Regional Public Holiday
2015-07-17 00:00:00 | [NAME] | Regional Public Holiday
2015-07-24 00:00:00 | [NAME] | Regional Public Holiday
2015-08-03 00:00:00 | Picnic Day | Public Holiday
2015-12-25 00:00:00 | Christmas Day | Public Holiday
2015-12-28 00:00:00 | Boxing Day | Public Holiday
2016-01-01 00:00:00 | New Year's Day | Public Holiday
2016-01-26 00:00:00 | Australia Day | Public Holiday
2016-03-25 00:00:00 | Good Friday | Public Holiday
2016-03-26 00:00:00 | Easter Saturday | Public Holiday
2016-03-28 00:00:00 | Easter Monday | Public Holiday
2016-04-25 00:00:00 | Anzac Day | Public Holiday
2016-05-02 00:00:00 | May Day | Public Holiday
2016-06-13 00:00:00 | Queen's Birthday | Public Holiday
2016-06-24 00:00:00 | Borroloola Show Day | Regional Public Holiday
2016-07-01 00:00:00 | [NAME] | Regional Public Holiday
2016-07-08 00:00:00 | Tennant Creek Show Day | Regional Public Holiday
2016-07-15 00:00:00 | [NAME] | Regional Public Holiday
2016-07-22 00:00:00 | [NAME] | Regional Public Holiday
2016-08-01 00:00:00 | Picnic Day | Public Holiday
2016-12-24 00:00:00 | Christmas Eve 7pm to midnight | Part Day Public Holiday (7pm)
2016-12-25 00:00:00 | Christmas Day | Public Holiday
2016-12-26 00:00:00 | Boxing Day | Public Holiday
2016-12-27 00:00:00 | Christmas Day (Tuesday PH) | Public Holiday
2016-12-31 00:00:00 | New years eve 7pm to midnight | Part Day Public Holiday (7pm)
2017-01-01 00:00:00 | New Year's Day | Public Holiday
2017-01-02 00:00:00 | New Year's Day (Monday PH) | Public Holiday
2017-01-26 00:00:00 | Australia Day | Public Holiday
2017-04-14 00:00:00 | Good Friday | Public Holiday
2017-04-15 00:00:00 | Easter Saturday | Public Holiday
2017-04-17 00:00:00 | Easter Monday | Public Holiday
2017-04-25 00:00:00 | Anzac Day | Public Holiday
2017-05-01 00:00:00 | May Day | Public Holiday
2017-06-12 00:00:00 | Queen's Birthday | Public Holiday
2017-06-30 00:00:00 | Borroloola Show Day | Regional Public Holiday
2017-07-07 00:00:00 | [NAME] | Regional Public Holiday
2017-07-14 00:00:00 | Tennant Creek Show Day | Regional Public Holiday
2017-07-21 00:00:00 | [NAME] | Regional Public Holiday
2017-07-28 00:00:00 | [NAME] | Regional Public Holiday
2017-08-07 00:00:00 | Picnic Day | Public Holiday
2017-12-24 00:00:00 | Christmas Eve PDPH | Part Day Public Holiday (7pm)
2017-12-25 00:00:00 | Christmas Day | Public Holiday
2017-12-26 00:00:00 | Boxing Day | Public Holiday
2017-12-31 00:00:00 | New Year's Eve PDPH | Part Day Public Holiday (7pm)
2018-01-01 00:00:00 | New Year's Day | Public Holiday
2018-01-26 00:00:00 | Australia Day | Public Holiday
2018-03-30 00:00:00 | Good Friday | Public Holiday
2018-03-31 00:00:00 | Easter Saturday | Public Holiday
2018-04-02 00:00:00 | Easter Monday | Public Holiday
2018-04-25 00:00:00 | Anzac Day | Public Holiday
2018-05-07 00:00:00 | May Day | Public Holiday
2018-06-11 00:00:00 | Queen's Birthday | Public Holiday
2018-06-29 00:00:00 | Borroloola Show Day | Regional Public Holiday
2018-07-06 00:00:00 | [NAME] | Regional Public Holiday
2018-07-13 00:00:00 | Tennant Creek Show Day | Regional Public Holiday
2018-07-20 00:00:00 | [NAME] | Regional Public Holiday
2018-07-27 00:00:00 | [NAME] | Regional Public Holiday
2018-08-06 00:00:00 | Picnic Day | Public Holiday
2018-12-24 00:00:00 | Christmas Eve PDPH | Part Day Public Holiday (7pm)
2018-12-25 00:00:00 | Christmas Day | Public Holiday
2018-12-26 00:00:00 | Boxing Day | Public Holiday
2018-12-31 00:00:00 | New Year's Eve PDPH | Part Day Public Holiday (7pm)
2019-01-01 00:00:00 | New Year's Day | Public Holiday
2019-01-28 00:00:00 | Australia Day | Public Holiday
2019-04-19 00:00:00 | Good Friday | Public Holiday
2019-04-20 00:00:00 | Easter Saturday | Public Holiday
2019-04-22 00:00:00 | Easter Monday | Public Holiday
2019-04-25 00:00:00 | Anzac Day | Public Holiday
2019-05-06 00:00:00 | May Day | Public Holiday
2019-06-10 00:00:00 | Queen's Birthday | Public Holiday
2019-06-28 00:00:00 | Borroloola Show Day | Regional Public Holiday
2019-07-05 00:00:00 | [NAME] | Regional Public Holiday
2019-07-12 00:00:00 | Tennant Creek Show Day | Regional Public Holiday
2019-07-19 00:00:00 | [NAME] | Regional Public Holiday
2019-07-26 00:00:00 | [NAME] | Regional Public Holiday
2019-08-05 00:00:00 | Picnic Day | Public Holiday
2019-12-24 00:00:00 | Christmas Eve PDPH | Part Day Public Holiday (7pm)
2019-12-25 00:00:00 | Christmas Day | Public Holiday
2019-12-26 00:00:00 | Boxing Day | Public Holiday
2019-12-31 00:00:00 | New Year's Eve PDPH | Part Day Public Holiday (7pm)
2020-01-01 00:00:00 | New Year's Day | Public Holiday
2020-01-27 00:00:00 | Australia Day | Public Holiday
2020-04-10 00:00:00 | Good Friday | Public Holiday
2020-04-11 00:00:00 | Easter Saturday | Public Holiday
2020-04-13 00:00:00 | Easter Monday | Public Holiday
2020-04-25 00:00:00 | Anzac Day | Public Holiday
2020-05-04 00:00:00 | May Day | Public Holiday
2020-06-08 00:00:00 | Queen's Birthday | Public Holiday
2020-07-03 00:00:00 | [NAME] | Regional Public Holiday
2020-07-10 00:00:00 | Tennant Creek Show Day | Regional Public Holiday
2020-07-17 00:00:00 | [NAME] | Regional Public Holiday
2020-07-24 00:00:00 | [NAME] | Regional Public Holiday
2020-08-03 00:00:00 | Picnic Day | Public Holiday
2020-08-14 00:00:00 | Borroloola Show Day | Regional Public Holiday
2020-12-24 00:00:00 | Christmas Eve PDPH | Part Day Public Holiday (7pm)
2020-12-25 00:00:00 | Christmas Day | Public Holiday
2020-12-26 00:00:00 | Boxing Day | Public Holiday
2020-12-28 00:00:00 | Boxing Day (PH) | Public Holiday
2020-12-31 00:00:00 | New Year's Eve PDPH | Part Day Public Holiday (7pm)
2021-01-01 00:00:00 | New Year's Day | Public Holiday
2021-01-26 00:00:00 | Australia Day | Public Holiday
2021-04-02 00:00:00 | Good Friday | Public Holiday
2021-04-03 00:00:00 | Easter Saturday | Public Holiday
2021-04-05 00:00:00 | Easter Monday | Public Holiday
2021-04-26 00:00:00 | Anzac Day | Public Holiday
2021-05-03 00:00:00 | May Day | Public Holiday
2021-06-14 00:00:00 | Queen's Birthday | Public Holiday
2021-07-02 00:00:00 | [NAME] | Regional Public Holiday
2021-07-09 00:00:00 | Tennant Creek Show Day | Regional Public Holiday
2021-07-16 00:00:00 | [NAME] | Regional Public Holiday
2021-07-23 00:00:00 | [NAME] | Regional Public Holiday
2021-08-02 00:00:00 | Picnic Day | Public Holiday
2021-08-20 00:00:00 | Borroloola Show Day | Regional Public Holiday
2021-12-24 00:00:00 | Christmas Eve PDPH | Part Day Public Holiday (7pm)
2021-12-25 00:00:00 | Christmas Day | Public Holiday
2021-12-26 00:00:00 | Boxing Day | Public Holiday
2021-12-27 00:00:00 | Christmas Day (PH) | Public Holiday
2021-12-28 00:00:00 | Boxing Day (PH) | Public Holiday
2021-12-31 00:00:00 | New Year's Eve PDPH | Part Day Public Holiday (7pm)
2022-01-01 00:00:00 | New Year's Day | Public Holiday
2022-01-03 00:00:00 | New Year's Day (PH) | Public Holiday
2022-01-26 00:00:00 | Australia Day | Public Holiday
2022-04-15 00:00:00 | Good Friday | Public Holiday
2022-04-16 00:00:00 | Easter Saturday | Public Holiday
2022-04-17 00:00:00 | Easter Sunday | Public Holiday
2022-04-18 00:00:00 | Easter Monday | Public Holiday
2022-04-25 00:00:00 | Anzac Day | Public Holiday
2022-05-02 00:00:00 | May Day | Public Holiday
2022-06-13 00:00:00 | Queen's Birthday | Public Holiday
2022-07-01 00:00:00 | [NAME] | Regional Public Holiday
2022-07-08 00:00:00 | Tennant Creek Show Day | Regional Public Holiday
2022-07-15 00:00:00 | [NAME] | Regional Public Holiday
2022-07-22 00:00:00 | [NAME] | Regional Public Holiday
2022-08-01 00:00:00 | Picnic Day | Public Holiday
2022-08-19 00:00:00 | Borroloola Show Day | Regional Public Holiday
2022-09-22 00:00:00 | National Day of Mourning | Public Holiday
2022-12-24 00:00:00 | Christmas Eve PDPH | Part Day Public Holiday (7pm)
2022-12-25 00:00:00 | Christmas Day | Public Holiday
2022-12-26 00:00:00 | Christmas Day (PH) | Public Holiday
2022-12-27 00:00:00 | Boxing Day (PH) | Public Holiday
2022-12-31 00:00:00 | New Year's Eve PDPH | Part Day Public Holiday (7pm)
2023-01-01 00:00:00 | New Year's Day | Public Holiday
2023-01-02 00:00:00 | New Year's Day (PH) | Public Holiday
2023-01-26 00:00:00 | Australia Day | Public Holiday
2023-04-07 00:00:00 | Good Friday | Public Holiday
2023-04-08 00:00:00 | Easter Saturday | Public Holiday
2023-04-09 00:00:00 | Easter Sunday | Public Holiday
2023-04-10 00:00:00 | Easter Monday | Public Holiday
2023-04-25 00:00:00 | Anzac Day | Public Holiday
2023-05-01 00:00:00 | May Day | Public Holiday
2023-07-07 00:00:00 | [NAME] | Regional Public Holiday
2023-07-14 00:00:00 | Tennant Creek Show Day | Regional Public Holiday
2023-07-21 00:00:00 | [NAME] | Regional Public Holiday
2023-07-28 00:00:00 | [NAME] | Regional Public Holiday
2023-08-18 00:00:00 | Borroloola Show Day | Regional Public Holiday