Spreadsheet: 691083d1597440318-shade-cells-in-staff-rota-if-staff-are-at-work-edit2-copy-freddyfred-
Sheet: Rota

 |  |  |  |  |  |  | WEEK | A
 |  |  |  |  |  |  | WEEK A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task A |  |  |  |  |  |  |  | Task B |  |  |  |  |  |  |  | Task C |  |  |  |  |  |  |  | MANAGEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | Week | Task | Day | Start | End
 |  |  |  |  |  |  | Wednesday | 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
 |  |  |  |  |  |  | Staff 01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 02
 |  |  |  |  |  |  | Staff 02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 03
 |  |  |  |  |  |  | Staff 03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 04
 |  |  |  |  |  |  | Staff 04 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 05
 |  |  |  |  |  |  | Staff 05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 06
 |  |  |  |  |  |  | Staff 06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 07
 |  |  |  |  |  |  | Staff 07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 08
 |  |  |  |  |  |  | Staff 08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 09
 |  |  |  |  |  |  | Staff 09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 10
 |  |  |  |  |  |  | Staff 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff 11
 |  |  |  |  |  |  | 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