Spreadsheet: 69453d1269974705-vlookup-not-giving-correct-number-cov-hours-test
Sheet: Team Hours

Panel Name | Panel Code | Leave Time | Travel Time | Setup Time(45 mins) + 15 mins [NAME] | Break | Training / Meeting Time | 1st Session Start Time | 1st Session Finish Time | Break | [NAME] & Break | 2nd Session Start Time | 2nd Session Finish Time | Last Donor + Pack Up | Return to Base | Bleed Time | Working Hours | Normal Number of Beds | AfB Hours
ALLESLEY-SAT | HA10B | 08:15:00 | 00:15:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 09:30:00 | 12:00:00 | 01:00:00 | 00:30:00 | 13:30:00 | 15:30:00 | 01:00:00 | 16:45:00 | 04:30:00 | 07:30:00 | 9 | Early
ALLESLEY-WD | HA10E | 11:15:00 | 00:30:00 | 01:00:00 | 00:45:00 | 00:30:00 | 14:00:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 21:00:00 | 04:30:00 | 08:30:00 | 9 | 09:45:00
BEDWORTH | HB02 | 11:00:00 | 00:15:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:00:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:00:00 | 01:00:00 | 20:15:00 | 05:00:00 | 08:00:00 | 9 | 09:15:00
BILTON | HC35 | 11:00:00 | 00:45:00 | 01:00:00 | 00:45:00 | 00:30:00 | 14:00:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 21:15:00 | 04:30:00 | 09:00:00 | 9 | 10:15:00
BRANDON | HB28 | 08:00:00 | 00:30:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 09:30:00 | 12:00:00 | 01:00:00 | 00:30:00 | 13:30:00 | 15:30:00 | 01:00:00 | 17:00:00 | 04:30:00 | 08:00:00 | 9 | Early
COVENTRY | HC03 | 08:45:00 | 00:15:00 | 01:00:00 | 1900-01-01 00:00:00 | 00:30:00 | 10:30:00 | 13:30:00 | 01:00:00 | 00:30:00 | 15:00:00 | 17:30:00 | 01:00:00 | 18:45:00 | 05:30:00 | 09:00:00 | 9 | Early
DUNCHURCH | HD18 | 11:00:00 | 00:30:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 21:00:00 | 05:15:00 | 08:45:00 | 6 | 10:00:00
MEGGITT | HD46 | 08:15:00 | 00:15:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 09:30:00 | 12:00:00 | 01:00:00 | 00:30:00 | 13:30:00 | 16:00:00 | 01:00:00 | 17:15:00 | 05:00:00 | 08:00:00 | 9 | Early
FORD DAVENTRY | TN13 | 08:00:00 | 01:00:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 10:00:00 | 12:00:00 | 01:00:00 | 00:30:00 | 13:30:00 | 16:00:00 | 01:00:00 | 18:00:00 | 04:30:00 | 09:00:00 | 9 | Early
HILLMORTON | HH28 | 10:45:00 | 00:45:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 21:15:00 | 05:15:00 | 09:15:00 | 6 | 10:30:00
HOLBROOKS-SAT | [NAME] | 08:15:00 | 00:15:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 09:30:00 | 12:00:00 | 01:00:00 | 00:30:00 | 13:30:00 | 15:30:00 | 01:00:00 | 16:45:00 | 04:30:00 | 07:30:00 | 9 | Early
HOLBROOKS-WD | HH18W | 11:15:00 | 00:15:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 20:45:00 | 05:15:00 | 08:15:00 | 6 | 09:30:00
JAGUAR | HJ45 | 08:00:00 | 00:30:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 09:30:00 | 12:15:00 | 01:00:00 | 00:30:00 | 13:45:00 | 16:00:00 | 01:00:00 | 17:30:00 | 05:00:00 | 08:30:00 | 9 | Early
KENILWORTH | HK01 | 11:00:00 | 00:30:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 21:00:00 | 05:15:00 | 08:45:00 | 9 | 10:00:00
KING EDWARDS COL | HN41 | 08:00:00 | 00:30:00 | 01:00:00 | 1900-01-01 00:00:00 | 00:15:00 | 09:45:00 | 12:00:00 | 01:00:00 | 00:30:00 | 13:30:00 | 16:00:00 | 01:00:00 | 17:30:00 | 04:45:00 | 08:30:00 | 6 | Early
NUNEATON | HN05 | 11:00:00 | 00:30:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 21:00:00 | 05:15:00 | 08:45:00 | 9 | 10:00:00
RUGBY | HR04 | 11:00:00 | 00:30:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 21:00:00 | 05:15:00 | 08:45:00 | 9 | 10:00:00
SOUTHAM | HS11 | 10:45:00 | 00:45:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 21:15:00 | 05:15:00 | 09:15:00 | 9 | 10:30:00
STOCKINGFORD | HS99 | 11:00:00 | 00:30:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 21:00:00 | 05:15:00 | 08:45:00 | 6 | 10:00:00
STYVECHALE | HS28 | 08:00:00 | 00:30:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 09:30:00 | 12:00:00 | 01:00:00 | 00:30:00 | 13:30:00 | 15:30:00 | 01:00:00 | 17:00:00 | 04:30:00 | 08:00:00 | 9 | Early
TILE HILL | HT12 | 08:00:00 | 00:30:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 09:30:00 | 12:00:00 | 01:00:00 | 00:30:00 | 13:30:00 | 15:30:00 | 01:00:00 | 17:00:00 | 04:30:00 | 08:00:00 | 9 | Early
UNIVERSITY | HU44 | 08:00:00 | 00:30:00 | 01:00:00 | 1900-01-01 00:00:00 | 00:15:00 | 09:45:00 | 12:00:00 | 01:00:00 | 00:30:00 | 13:30:00 | 16:00:00 | 01:00:00 | 17:30:00 | 04:45:00 | 08:30:00 | 9 | Early
WALSGRAVE-SAT | HW30C | 08:15:00 | 00:15:00 | 01:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 09:30:00 | 12:00:00 | 01:00:00 | 00:30:00 | 13:30:00 | 15:30:00 | 01:00:00 | 16:45:00 | 04:30:00 | 07:30:00 | 9 | Early
WALSGRAVE-WD | HW30D | 11:15:00 | 00:15:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 20:45:00 | 05:15:00 | 08:15:00 | 6 | 09:30:00
WARWICK | HW03 | 11:00:00 | 00:30:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:30:00 | 01:00:00 | 21:00:00 | 05:15:00 | 08:45:00 | 9 | 10:00:00
WEDDINGTON | HN17 | 11:00:00 | 00:30:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00 | 13:15:00 | 15:30:00 | 00:30:00 | 00:30:00 | 16:30:00 | 19:45:00 | 01:00:00 | 21:15:00 | 05:30:00 | 09:00:00 | 6 | 10:15:00