Spreadsheet: 726702d1617379667-holiday-sheet-rota-work-in-progresslastonev3broken
Sheet: Sheet1

HOLIDAY 1 |  |  |  |  |  |  | TOTAL HOURS | BREAKS REMOVED | HOLIDAY 2 |  |  |  |  |  |  | TOTAL HOURS | BREAKS REMOVED
START: | 2021-04-07 00:00:00 |  | END: | 2021-04-09 00:00:00 |  |  |  |  | START: | 2021-04-07 00:00:00 |  | END: | 2021-04-09 00:00:00
DAY | START | FINISH | BREAK | BREAK | BREAK | DINNER |  |  | DAY | START | FINISH | BREAK | BREAK | BREAK | DINNER
MON | 07:00:00 | 16:30:00 | 0.5 |  |  | 1 |  |  | MON | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
TUE | 07:00:00 | 16:00:00 | 0 |  |  | 1 |  |  | TUE | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
WED | 07:00:00 | 15:30:00 | 0.5 |  |  | 1 |  |  | WED | 07:00:00 | 15:00:00 | 0.5 |  |  | 1
THUR | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | THUR | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
FRI | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | FRI | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
SAT |  |  |  |  |  |  |  |  | SAT
SUN |  |  |  |  |  |  |  |  | SUN
 |  |  |  |  |  |  | WEEKLY HOURS |  |  |  |  |  |  |  |  | WEEKLY HOURS
 |  |  |  |  |  |  | BREAKS REMOVED |  |  |  |  |  |  |  |  | BREAKS REMOVED
HOLIDAY 3 |  |  |  |  |  |  | TOTAL HOURS | BREAKS REMOVED | HOLIDAY 4 |  |  |  |  |  |  | TOTAL HOURS | BREAKS REMOVED
START: | 2021-04-07 00:00:00 |  | END: | 2021-04-09 00:00:00 |  |  |  |  | START: | 2021-04-07 00:00:00 |  | END: | 2021-04-09 00:00:00
DAY | START | FINISH | BREAK | BREAK | BREAK | DINNER |  |  | DAY | START | FINISH | BREAK | BREAK | BREAK | DINNER
MON | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | MON | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
TUE | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | TUE | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
WED | 07:00:00 | 15:00:00 | 0.5 |  |  | 1 |  |  | WED | 07:00:00 | 15:00:00 | 0.5 |  |  | 1
THUR | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | THUR | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
FRI | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | FRI | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
SAT |  |  |  |  |  |  |  |  | SAT
SUN |  |  |  |  |  |  |  |  | SUN
 |  |  |  |  |  |  | WEEKLY HOURS |  |  |  |  |  |  |  |  | WEEKLY HOURS
 |  |  |  |  |  |  | BREAKS REMOVED |  |  |  |  |  |  |  |  | BREAKS REMOVED
HOLIDAY 5 |  |  |  |  |  |  | TOTAL HOURS | BREAKS REMOVED | HOLIDAY 6 |  |  |  |  |  |  | TOTAL HOURS | BREAKS REMOVED
START: | 2021-04-07 00:00:00 |  | END: | 2021-04-09 00:00:00 |  |  |  |  | START: | 2021-04-07 00:00:00 |  | END: | 2021-04-09 00:00:00
DAY | START | FINISH | BREAK | BREAK | BREAK | DINNER |  |  | DAY | START | FINISH | BREAK | BREAK | BREAK | DINNER
MON | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | MON | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
TUE | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | TUE | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
WED | 07:00:00 | 15:00:00 | 0.5 |  |  | 1 |  |  | WED | 07:00:00 | 15:00:00 | 0.5 |  |  | 1
THUR | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | THUR | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
FRI | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | FRI | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
SAT |  |  |  |  |  |  |  |  | SAT
SUN |  |  |  |  |  |  |  |  | SUN
 |  |  |  |  |  |  | WEEKLY HOURS |  |  |  |  |  |  |  |  | WEEKLY HOURS
 |  |  |  |  |  |  | BREAKS REMOVED |  |  |  |  |  |  |  |  | BREAKS REMOVED
HOLIDAY 7 |  |  |  |  |  |  | TOTAL HOURS | BREAKS REMOVED | HOLIDAY 8 |  |  |  |  |  |  | TOTAL HOURS | BREAKS REMOVED
START: | 2021-04-07 00:00:00 |  | END: | 2021-04-09 00:00:00 |  |  |  |  | START: | 2021-04-07 00:00:00 |  | END: | 2021-04-09 00:00:00
DAY | START | FINISH | BREAK | BREAK | BREAK | DINNER |  |  | DAY | START | FINISH | BREAK | BREAK | BREAK | DINNER
MON | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | MON | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
TUE | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | TUE | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
WED | 07:00:00 | 15:00:00 | 0.5 |  |  | 1 |  |  | WED | 07:00:00 | 15:00:00 | 0.5 |  |  | 1
THUR | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | THUR | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
FRI | 07:00:00 | 16:00:00 | 0.5 |  |  | 1 |  |  | FRI | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
SAT |  |  |  |  |  |  |  |  | SAT
SUN |  |  |  |  |  |  |  |  | SUN
 |  |  |  |  |  |  | WEEKLY HOURS |  |  |  |  |  |  |  |  | WEEKLY HOURS
 |  |  |  |  |  |  | BREAKS REMOVED |  |  |  |  |  |  |  |  | BREAKS REMOVED
BANK HOLIDAYS BOOKED |  |  |  | DATES |  |  | START: |  | END: |  |  | BREAK | BREAK | BREAK | DINNER | TOTAL HOURS | BREAKS REMOVED
GOOD FRIDAY |  |  |  | 2021-04-02 00:00:00 |  |  | 07:00:00 |  | 16:00:00
EASTER MONDAY |  |  |  | 2021-04-05 00:00:00 |  |  | 07:00:00 |  | 16:00:00
EARLY MAY |  |  |  | 2021-05-03 00:00:00 |  |  | 07:00:00 |  | 16:00:00
SPRING |  |  |  | 2021-05-31 00:00:00 |  |  | 07:00:00 |  | 16:00:00
SUMMER |  |  |  | 2021-08-30 00:00:00 |  |  | 07:00:00 |  | 16:00:00
CHRISTMAS DAY |  |  |  | 2021-12-25 00:00:00
BOXING DAY |  |  |  | 2021-12-27 00:00:00 |  |  | 07:00:00 |  | 16:00:00
NEW YEARS DAY |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL HOURS | BREAKS REMOVED
ANNUAL HOURS ALLOWANCE TOTAL