Spreadsheet: 876209d1722888407-calculating-a-time-start-and-finish-time-within-the-same-cell-on-a-rosta-staff-rosta-aug-2024
Sheet: PCs

Name | Possition |  | PCs PCWs PCAs
 |  |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY |  |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY
Name | PC | East
 |  | West |  | 0600  1200 |  | 0600  1200 |  | 0600  1200 |  |  |  | 0600  1200 |  | 0600  1200 |  | 0600  1200 |  |  | 0600  1200 |  | 0600  1200 |  |  |  | 0600  1200 |  | 0600  1200
Name | PC | East |  |  |  |  |  | 1500  2100 |  |  |  | 1500  2100 |  | 0700  1300 |  | 0700  1300 |  |  | 1500  2100 |  |  |  | 1500  2100 |  |  |  |  |  | 0700  1300 |  | 0700  1300
 |  | West
Name | PC | East
 |  | West
 |  | ND |  |  |  |  |  |  | ND | 2100  0700 |  |  |  |  |  |  |  |  |  |  |  |  |  | ND | 2100  0700 | ND | 2100  0700 | ND | 2100  0700
Name | PC | East
 |  | West |  |  |  |  |  |  |  | 1500  2100 |  |  |  | 1500  2100 |  |  |  |  |  |  |  |  |  |  | 1500  2100 |  | 1500  2100 |  | 1500  2100
 |  | Oak |  |  |  |  |  |  |  |  |  | 1500  2100
Name | PC | East
 |  | West |  | 1500  2100 |  |  |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  |  |  |  |  |  |  |  |  |  |  |  | 1500  2100 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300
Name | PC | East |  |  |  |  |  |  |  | 1600  2100
 |  | West |  |  |  |  |  |  |  |  |  |  |  | 1500  2100 |  | 1500  2100
Name | PC | East |  | 1500  2100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500  2100 |  | 1500  2100
 |  | West
 |  | Oak |  |  |  | 1500  2100 |  | 1500  2100 |  | 1500  2100 |  |  |  | 1500  2100 |  | 1500  2100 |  |  |  |  |  |  |  |  |  |  |  |  | 1500  2100
Name | PC | East
 |  | West
 |  | ND | ND | 2100  0700 | ND | 2100  0700 |  |  |  |  |  |  |  |  |  |  |  | ND | 2100  0700 | ND | 2100  0700
Name | PC | East
 |  | West
 |  | Oak |  | 0700  1500 |  | 0700  1500 |  | 0700  1500 |  |  |  |  |  |  |  |  |  |  | 0700  1500 |  | 0700  1500 |  | 0700  1500 |  | 0700  1500 |  |  |  | 0700  1500 |  | 0700  1500
Name | PC | East |  |  |  |  |  | 0700  1500 |  |  |  |  |  |  |  | 0700  1500 |  |  | 0700  1500 |  |  |  | 0700  1500 |  |  |  | 0700  1500
 |  | West |  |  |  |  |  |  |  | 0700  1300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0700  1500 |  |  |  |  |  | 0700  1500
 |  | Oak
Name | PC | East
 |  | West
 |  | ND |  |  |  |  | ND | 2100  0700 | ND | 2100  0700 | ND | 2100  0700 |  |  |  |  |  |  |  |  |  | ND | 2100  0700 | ND | 2100  0700 | ND | 2100  0700
 |  | East
 |  | West
 |  | East
 |  | West
 |  | East
 |  | West
 |  | East
 |  | West
 |  | East
 |  | West
 |  | East
 |  | West
 |  | East
 |  | West
 |  | East
 |  | West
 |  | East
 |  | West
 |  | East
 |  | West
 |  |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY |  |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY
Vacant shifts
 |  | Time |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1500 |  | 0700  1300 |  | 0700  1300
 |  | Area
 |  | Time |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  |  | 0700  1300 |  |  |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  | 0700  1300
 |  | Area
 |  | Time |  | 0700  1300 |  | 0700  1300 |  | 0700  1300 |  |  |  | 0700  1300 |  |  |  | 0700  1300 |  |  |  |  |  |  | 0700  1300 |  |  |  | 0700  1300 |  |  |  | 0700  1300
 |  | Area
 |  | Time |  | 0700  1300 |  |  |  |  |  |  |  |  |  |  |  | 0700  1300 |  |  |  |  |  |  | 0700  1300 |  |  |  | 0700  1300 |  |  |  | 0700  1300
 |  | Area
 |  | Time |  | 1500  2100 |  |  |  | 1500  2100 |  | 1500  2100 |  | 1500  2100 |  |  |  | 1500  2100 |  |  | 1500  2100 |  | 1500  2100 |  | 1500  2100 |  | 1500  2100 |  | 0700  1300 |  | 1500  2100 |  | 1500  2100
 |  | Area
 |  | Time |  |  |  |  |  |  |  | 1500  2100 |  | 1500  2100 |  |  |  | 1500  2100 |  |  | 1500  2100 |  | 1500  2100 |  |  |  | 1500  2100 |  | 1500  2100 |  |  |  | 1500  2100
 |  | Area
 |  | Time |  |  |  |  |  |  |  |  |  | 1500  2100 |  |  |  |  |  |  |  |  |  |  |  |  | 1500  2100 |  | 1500  2100 |  |  |  | 1500  2100
 |  | Area
 |  | Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500  2100 |  | 1500  2100
 |  | Area
 |  | Time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500  2100
 |  | Area
Total shifts per day to be covered |  |  | 30 |  | 30 |  | 30 |  | 30 |  | 30 |  | 30 |  | 30 |  |  | 30 |  | 30 |  | 30 |  | 30 |  | 30 |  | 30 |  | 30
Variance in staff
Total shifts actually covered
 | TOTAL PCs
Only counts | Total day
0600 - 2000 Starts | AM
 | PM
 | Night Duty
 | PC staff count
 | Hour start
 | AM
 | 06:00
 | 07:00
 | 08:00
 | 09:00
 | 10:00
 | 11:00
 | PM
 | 12:00
 | 13:00
 | 14:00
 | 15:00
 | 16:00
 | 17:00
 | 18:00
 | 19:00
 | 20:00
 | 21.00 | ND |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ND
 | 22.00