Spreadsheet: 766931d1644172522-finding-multiple-criteria-in-nth-rows-draft-rota-example
Sheet: JAN

 | JANUARY |  | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Day Staff | Staff 1 | 07:30:00 | 13:00:00 | 06:00:00 |  | 06:00:00 | 06:15:00 | 06:15:00 |  |  |  |  |  | 10:00:00 | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  | 14:30:00 | 19:00:00 | 17:00:00 |  | 18:00:00 | 16:30:00 | 07:30:00 |  |  |  |  |  | 17:00:00 | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  | SICK | COVID positive | COVID social distancing |  | SICK | OVERTIME | SICK |  |  |  |  |  | MATERNITY | [NAME] shielding |  |  | AGENCY |  | LEAVE |  |  | OVERTIME
 |  | 30 hrs |  |  |  |  |  | East Wing |  |  |  |  |  |  |  | Dysphagia
 |  | Staff 2 | 07:30:00 | 13:00:00 | 06:00:00 |  | 06:00:00 | 06:15:00 | 06:15:00 |  |  |  |  |  | 10:00:00 | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  | 20:30:00 | 19:00:00 | 17:00:00 |  | 18:00:00 | 16:30:00 | 07:30:00 |  |  |  |  |  | 17:00:00 | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  | LEAVE |  | TRAINING |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 33 hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | Dysphagia
 |  | Staff 3 | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  | 14:30:00 |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  | EMERGENCY LEAVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 30.75hrs | water leak |  |  |  |  |  |  |  |  |  |  |  |  | Dysphagia
 |  | Staff 4 | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  | 14:30:00 |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 31 hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | Dysphagia
 |  | Staff 5 | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  | 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 34 hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | Dysphagia
 |  | Staff 6 | 07:45:00 |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  | 13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 30.75hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | Dysphagia
 |  | Staff 7 | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  | 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 32 hrs | all day |  |  |  |  |  |  |  |  |  |  |  |  | Dysphagia
 |  | Staff 8 | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 35 hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | Dysphagia
 |  | Staff 9 | 14:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 30.75hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | Dysphagia
 |  | Staff 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 33 hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | Dysphagia
 |  | Staff 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 36 hrs
 |  | Staff 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 30.75hrs
 |  | Staff 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 34 hrs
 |  | Staff 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 37 hrs
 |  | Staff 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 30.75hrs
 |  | Staff 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 35 hrs
 |  | Staff 17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 38 hrs
 |  | Staff 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 18hrs
 |  | Staff 19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 38.5hrs
 |  | Staff 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 16.5hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGENCY |  |  |  |  | OVERTIME
 |  | 28.5hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME
 |  | 28hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME
 |  | 24hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PATERNITY |  |  | OVERTIME
 |  | 24hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME
 |  | 27hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME
 |  | 27hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 | 16:30:00 |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 | 21:30:00 |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OVERTIME
 |  | 30.5hrs
 | CASUALS and AGENCY | start time ----> |  |  | 14:00:00 | 07:30:00 | 07:30:00 | 06:45:00 |  |  |  |  |  | 07:30:00 | 13:30:00 | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 |  |  |  | 14:00:00
 |  | finish time ----> |  |  | 22:00:00 | 15:30:00 | 15:30:00 | 07:45:00 |  |  |  |  |  | 15:30:00 | 21:30:00 | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 |  |  |  | 22:00:00
 |  | reason cover needed ----> |  |  |  |  | SICK | SICK
 |  | casual or agency name ---->
 |  | (use drop down) staff name --->
 |  | (type in) Agency person's name --->
 |  | start time ----> |  |  |  |  | 06:45:00 |  |  |  |  |  | 07:30:00 | 07:30:00 | 13:30:00 | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 |  |  |  | 14:00:00
 |  | finish time ----> |  |  |  |  | 10:15:00 |  |  |  |  |  | 15:30:00 | 15:30:00 | 21:30:00 | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 |  |  |  | 22:00:00
 |  | reason cover needed ----> |  |  |  |  |  |  |  |  |  |  | LEAVE | OVERTIME | SICK | SICK
 |  | casual or agency name ----> |  |  |  |  |  |  |  |  |  |  | CASUAL |  | Nurse 3 | Nurse 4
 |  | (use drop down) staff name --->
 |  | (type in) Agency person's name --->
 |  | start time ----> |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 07:30:00 | 13:30:00 | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 |  |  |  | 14:00:00
 |  | finish time ----> |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 15:30:00 | 21:30:00 | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 |  |  |  | 22:00:00
 |  | reason cover needed ---->
 |  | casual or agency name ---->
 |  | (use drop down) staff name --->
 |  | (type in) Agency person's name --->
 |  | start time ----> | 07:00:00 |  |  |  |  |  |  |  |  |  |  | 07:30:00 | 13:30:00 | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 |  |  |  | 06:00:00
 |  | finish time ----> | 23:45:00 |  |  |  |  |  |  |  |  |  |  | 15:30:00 | 21:30:00 | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 |  |  |  | 22:00:00
 |  | reason cover needed ----> | EMERGENCY LEAVE
 |  | casual or agency name ----> | Nurse 4
 |  | (use drop down) staff name ---> | Staff 2
 |  | (type in) Agency person's name --->
 |  | start time ----> |  | 13:00:00 |  |  |  |  |  |  |  |  |  | 07:30:00 | 13:30:00 | 10:00:00 |  |  | 14:00:00 | 07:30:00 | 07:30:00 |  |  | 07:30:00 | 13:30:00 |  | 07:30:00 | 07:30:00 | 13:30:00 |  |  |  | 14:00:00
 |  | finish time ----> |  | 19:00:00 |  |  |  |  |  |  |  |  |  | 15:30:00 | 21:30:00 | 12:00:00 |  |  | 22:00:00 | 15:30:00 | 15:30:00 |  |  | 15:30:00 | 21:30:00 |  | 15:30:00 | 15:30:00 | 21:30:00 |  |  |  | 22:00:00
 |  | reason cover needed ----> |  | COVID positive
 |  | casual or agency name ---->
 |  | (use drop down) staff name --->
 |  | (type in) Agency person's name --->
 |  | Positions covered - earlies
 |  | Positions covered - lates
 |  |  | Sick
 |  |  | Annual Leave
 |  |  | Allocated duties
 |  |  | TOIL
 |  |  | Training
 |  |  | Amendments
 |  |  | Maternity Leave