Spreadsheet: 690643d1597218808-shade-cells-in-staff-rota-if-staff-are-at-work-edit2-copy
Sheet: Rota

 |  |  |  |  |  |  | WEEK | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunday |  |  |  |  |  |  | Monday |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  | Thursday |  |  |  |  |  |  | Friday |  |  |  |  |  |  | Saturday
 |  |  |  |  |  |  | WEEK A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task A |  |  |  |  |  |  |  | Task B |  |  |  |  |  |  |  | Task C |  |  |  |  |  |  |  | MANAGEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | Week | Task | Day | Start | End |  | Name | Week | Task | Day | Start | End |  | Name | Week | Task | Day | Start | End |  | Name | Week | Task | Day | Start | End |  | Name | Week | Task | Day | Start | End |  | Name | Week | Task | Day | Start | End |  | Name | Week | Task | Day | Start | End
 |  |  |  |  |  |  | Sunday | 00:00:00
 |  |  |  |  |  |  |  | 00:00:00 |  |  |  | 01:00:00 |  |  |  | 02:00:00 |  |  |  | 03:00:00 |  |  |  | 04:00:00 |  |  |  | 05:00:00 |  |  |  | 06:00:00 |  |  |  | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00                                                19:00 |  |  |  |  |  | Staff 01 | A | M | Sunday | 09:00:00 | 17:00:00 |  | Staff 01 | A | M | Monday | 09:00:00 | 17:00:00 |  | Staff 01 | A | M | Tuesday | 09:00:00 | 17:00:00 |  | Staff 01 | A | M | Wednesday | 09:00:00 | 17:00:00 |  | Staff 01 | A | M | Thursday | 09:00:00 | 17:00:00 |  | Staff 01 | A | M | Friday | 09:00:00 | 17:00:00 |  | Staff 01 | A | M | Saturday | 09:00:00 | 17:00:00
 |  |  |  |  |  |  | Staff 01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 02 | A | A | Sunday | 10:15:00 | 16:00:00 |  | Staff 02 | A | A | Monday | 10:15:00 | 16:00:00 |  | Staff 02 | A | A | Tuesday | 10:15:00 | 16:00:00 |  | Staff 02 | A | A | Wednesday | 10:15:00 | 16:00:00 |  | Staff 02 | A | A | Thursday | 10:15:00 | 16:00:00 |  | Staff 02 | A | A | Friday | 10:15:00 | 16:00:00 |  | Staff 02 | A | A | Saturday | 10:15:00 | 16:00:00
 |  |  |  |  |  |  | Staff 02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 03 | A | B | Sunday | 13:00:00 | 16:30:00 |  | Staff 03 | A | B | Monday | 13:00:00 | 16:30:00 |  | Staff 03 | A | B | Tuesday | 13:00:00 | 16:30:00 |  | Staff 03 | A | B | Wednesday | 13:00:00 | 16:30:00 |  | Staff 03 | A | B | Thursday | 13:00:00 | 16:30:00 |  | Staff 03 | A | B | Friday | 13:00:00 | 16:30:00 |  | Staff 03 | A | B | Saturday | 13:00:00 | 16:30:00
 |  |  |  |  |  |  | Staff 03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 04 | A | B | Sunday | 08:00:00 | 15:00:00 |  | Staff 04 | A | B | Monday | 08:00:00 | 15:00:00 |  | Staff 04 | A | B | Tuesday | 08:00:00 | 15:00:00 |  | Staff 04 | A | B | Wednesday | 08:00:00 | 15:00:00 |  | Staff 04 | A | B | Thursday | 08:00:00 | 15:00:00 |  | Staff 04 | A | B | Friday | 08:00:00 | 15:00:00 |  | Staff 04 | A | B | Saturday | 08:00:00 | 15:00:00
 |  |  |  |  |  |  | Staff 04 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 05 | A | M | Sunday | 07:15:00 | 13:30:00 |  | Staff 05 | A | M | Monday | 07:15:00 | 13:30:00 |  | Staff 05 | A | M | Tuesday | 07:15:00 | 13:30:00 |  | Staff 05 | A | M | Wednesday | 07:15:00 | 13:30:00 |  | Staff 05 | A | M | Thursday | 07:15:00 | 13:30:00 |  | Staff 05 | A | M | Friday | 07:15:00 | 13:30:00 |  | Staff 05 | A | M | Saturday | 07:15:00 | 13:30:00
 |  |  |  |  |  |  | Staff 05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 06 | A | C | Sunday | 13:30:00 | 19:00:00 |  | Staff 06 | A | C | Monday | 13:30:00 | 19:00:00 |  | Staff 06 | A | C | Tuesday | 13:30:00 | 19:00:00 |  | Staff 06 | A | C | Wednesday | 13:30:00 | 19:00:00 |  | Staff 06 | A | C | Thursday | 13:30:00 | 19:00:00 |  | Staff 06 | A | C | Friday | 13:30:00 | 19:00:00 |  | Staff 06 | A | C | Saturday | 13:30:00 | 19:00:00
 |  |  |  |  |  |  | Staff 06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 07 | A | A | Sunday | 09:00:00 | 15:15:00 |  | Staff 07 | A | A | Monday | 09:00:00 | 15:15:00 |  | Staff 07 | A | A | Tuesday | 09:00:00 | 15:15:00 |  | Staff 07 | A | A | Wednesday | 09:00:00 | 15:15:00 |  | Staff 07 | A | A | Thursday | 09:00:00 | 15:15:00 |  | Staff 07 | A | A | Friday | 09:00:00 | 15:15:00 |  | Staff 07 | A | A | Saturday | 09:00:00 | 15:15:00
 |  |  |  |  |  |  | Staff 07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 08 | A | A | Sunday | 13:00:00 | 18:00:00 |  | Staff 08 | A | A | Monday | 13:00:00 | 18:00:00 |  | Staff 08 | A | A | Tuesday | 13:00:00 | 18:00:00 |  | Staff 08 | A | A | Wednesday | 13:00:00 | 18:00:00 |  | Staff 08 | A | A | Thursday | 13:00:00 | 18:00:00 |  | Staff 08 | A | A | Friday | 13:00:00 | 18:00:00 |  | Staff 08 | A | A | Saturday | 13:00:00 | 18:00:00
 |  |  |  |  |  |  | Staff 08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 09 | A | B | Sunday | 14:15:00 | 17:00:00 |  | Staff 09 | A | B | Monday | 14:15:00 | 17:00:00 |  | Staff 09 | A | B | Tuesday | 14:15:00 | 17:00:00 |  | Staff 09 | A | B | Wednesday | 14:15:00 | 17:00:00 |  | Staff 09 | A | B | Thursday | 14:15:00 | 17:00:00 |  | Staff 09 | A | B | Friday | 14:15:00 | 17:00:00 |  | Staff 09 | A | B | Saturday | 14:15:00 | 17:00:00
 |  |  |  |  |  |  | Staff 09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 10 | A | B | Sunday | 07:00:00 | 14:45:00 |  | Staff 10 | A | B | Monday | 07:00:00 | 14:45:00 |  | Staff 10 | A | B | Tuesday | 07:00:00 | 14:45:00 |  | Staff 10 | A | B | Wednesday | 07:00:00 | 14:45:00 |  | Staff 10 | A | B | Thursday | 07:00:00 | 14:45:00 |  | Staff 10 | A | B | Friday | 07:00:00 | 14:45:00 |  | Staff 10 | A | B | Saturday | 07:00:00 | 14:45:00
 |  |  |  |  |  |  | Staff 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 11 | A | M | Sunday | 09:00:00 | 17:00:00 |  | Staff 11 | A | M | Monday | 09:00:00 | 17:00:00 |  | Staff 11 | A | M | Tuesday | 09:00:00 | 17:00:00 |  | Staff 11 | A | M | Wednesday | 09:00:00 | 17:00:00 |  | Staff 11 | A | M | Thursday | 09:00:00 | 17:00:00 |  | Staff 11 | A | M | Friday | 09:00:00 | 17:00:00 |  | Staff 11 | A | M | Saturday | 09:00:00 | 17:00:00
 |  |  |  |  |  |  | Staff 11
 |  |  |  |  |  |  |  | 00:00:00 |  |  |  | 01:00:00 |  |  |  | 02:00:00 |  |  |  | 03:00:00 |  |  |  | 04:00:00 |  |  |  | 05:00:00 |  |  |  | 06:00:00 |  |  |  | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00:00