Spreadsheet: 771289d1646589413-help-filling-a-table-from-another-table-call-taker-mealbreak-sheet-centralised-blank-1-a
Sheet: Call Taker Night Breaks

999 required | 999 available | 999 variance | 999 % variance | 999 [NAME] off | HCP req | HCP available | HCP Variance | HCP % variance | HCP Max off | Total req | Total avail | Total var | Total % variance | Total [NAME] off | 999 NUMBER OFF | HCP NUMBER OFF | Total off | Start Time | EAST |  |  |  |  | WEST |  |  |  |  | NORTH |  |  | HCP/SEND | HCP/SEND | HCP/SEND | HCP/SEND |  |  | West |  | East |  | North |  | requirements from intra day report |  |  |  |  |  | W 999 | W HCP | E 999 | E HCP | N 999 | N HCP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 999 | HCP | 999 | HCP | 999 | HCP | 999 | HCP | 999 total | HCP total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:00:00 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Break times |  |  |  | Hours worked
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CH name | start time hh:[NAME] | duration mins |  | CH name | start time | end time | hours worked | break allowed | break taken | Site E/W/N | 999/  HCP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Hooks | 23:45:00 | 30 |  | M Hooks | 19:00:00 | 07:00:00 |  |  |  | W | 999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M Hooks | 02:15:00 | 0 |  | J Bloggs | 19:00:00 | 03:00:00 |  |  |  | W | 999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J Bloggs | 00:00:00 | 31 |  | S.Smith | 09:00:00 | 15:00:00 |  |  |  | W | 999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:45:00 |  |  |  |  |  | M Hooks | 30 |  |  |  |  |  |  |  |  |  |  |  | S.Smith | 14:00:00 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | M Hooks |  | J Bloggs | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:15:00 |  |  |  |  |  |  |  | J Bloggs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:45:00