Spreadsheet: 712702d1610382193-multiple-if-with-and-or-criteria-what-am-i-doing-wrong-untitled-spreadsheet
Sheet: Sheet2

Timestamp | Shift Date | Site Name | 6am - 7am | 7am - 8am | 8am - 9am | 9am - 10am | 10am - 11am | 11am - 12pm | 12pm - 1pm | 1pm - 2pm | 3pm - 4pm | 4pm - 5pm | 5pm - 6pm | 6pm - 7pm | 7pm - 8pm | 8pm - 9pm | 9pm - 10pm | 2pm - 3pm
2021-01-08 11:22:00.236000 | 2021-01-08 00:00:00 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2021-01-09 14:01:58.524000 | 2021-01-09 00:00:00 | LTS005 - Hilda Road | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-09 15:23:46.837000 | 2021-01-09 00:00:00 | LTS241 - Streatham Common Car Park | 0 | 0 | 0 | 0 | 00 | 0 | 0 | 0 | 0 | 0 | 00 | 0 | 0 | 0 | 0
2021-01-10 10:51:32.828000 | 2021-01-10 00:00:00 | LTS358 - Ditton Youth Centre Car Park, [NAME], Aylesford | 0 | 0 | 9 | 5 | 17 | 15 | 18 | 14 | 5 | 4 | 3 | 0 | 0 | 0 | 0
2021-01-10 21:19:50.745000 | 2021-01-10 00:00:00 | LTS104 - Lord Street Car Park, Gravesend | 0 | 16 | 3 | 10 | 9 | 24 | 17 | 26 | 12 | 14 | 16 | 13 | 15 | 7 | 3
2021-01-10 21:46:27.988000 | 2021-01-10 00:00:00 | LTS358 - Ditton Youth Centre Car Park, [NAME], Aylesford | 0 | 0 | 1 | 9 | 9 | 4 | 17 | 5 | 21 | 1 | 4 | 0 | 3 | 0 | 0
2021-01-11 08:06:12.786000 | 2021-01-11 00:00:00 | LTS228 - Crystal Palace Park Car Park - Canada Gates | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 08:32:21.598000 | 2021-01-11 00:00:00 | LTS604 - Westgate Car Park | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 15:01:58.522000 | 2021-01-11 00:00:00 | LTS219 - Metro Centre, Redvales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 09:32:04.874000 | 2021-01-11 00:00:00 | LTS228 - Crystal Palace Park Car Park - Canada Gates | 0 | 0 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 09:57:50.056000 | 2021-01-11 00:00:00 | LTS670 - Car Park 8, [NAME] of Cambridge (DfE) | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 10:27:58.636000 | 2021-01-11 00:00:00 | EE004 - East Of England Showground | 50 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 10:33:49.080000 | 2021-01-11 00:00:00 | LTS228 - Crystal Palace Park Car Park - Canada Gates | 0 | 0 | 0 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 11:11:41.593000 | 2021-01-11 00:00:00 | [NAME] | 0 | 0 | 0 | 6 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 11:13:29.632000 | 2021-01-11 00:00:00 | SE016 - Curtis Way Coach Park | 0 | 15 | 26 | 54 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 12:00:50.081000 | 2021-01-11 00:00:00 | MTUSR190 - EE004 | 0 | 0 | 0 | 1 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 12:16:45.545000 | 2021-01-11 00:00:00 | MTU53 - EE004 | 0 | 0 | 0 | 30 | 34 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 12:32:40.115000 | 2021-01-11 00:00:00 | MTU142 - EE007 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 12:43:41.149000 | 2021-01-11 00:00:00 | LTS228 - Crystal Palace Park Car Park - Canada Gates | 0 | 0 | 0 | 31 | 32 | 38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 13:01:04.643000 | 2021-01-11 00:00:00 | MTU87 - EE004 | 0 | 0 | 0 | 40 | 36 | 69 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 13:02:41.963000 | 2021-01-11 00:00:00 | LTS228 - Crystal Palace Park Car Park - Canada Gates | 0 | 0 | 0 | 31 | 32 | 38 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 14:09:16.304000 | 2021-01-11 00:00:00 | MTU76 - SW002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 14:09:55.018000 | 2021-01-11 00:00:00 | MTU120 - SW002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 14:24:04.181000 | 2021-01-11 00:00:00 | LTS228 - Crystal Palace Park Car Park - Canada Gates | 0 | 0 | 0 | 31 | 32 | 38 | 31 | 49 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 14:27:19.432000 | 2021-01-11 00:00:00 | MTU133 - NE004 | 0 | 0 | 0 | 13 | 3 | 6 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 14:36:03.344000 | 2021-02-11 00:00:00 | MTU133 - NE004 | 0 | 0 | 0 | 13 | 3 | 6 | 6 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
2021-01-11 14:52:18.683000 | 2021-01-11 00:00:00 | MTUSR208 - SW002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 14:59:37.466000 | 2021-01-11 00:00:00 | [NAME] | 0 | 0 | 0 | 6 | 10 | 11 | 12 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13
2021-01-11 15:02:51.583000 | 2021-01-11 00:00:00 | MTUSR190 - EE004 | 0 | 0 | 0 | 1 | 0 | 4 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2021-01-11 15:06:07.584000 | 2021-01-11 00:00:00 | MTU28 - NE004 | 0 | 0 | 0 | 18 | 19 | 18 | 8 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22
2021-01-11 15:07:39.648000 | 2021-01-11 00:00:00 | MTU54 - EE003 | 0 | 0 | 0 | 37 | 38 | 39 | 37 | 37 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18
2021-01-11 15:08:28.284000 | 2021-01-11 00:00:00 | MTUSR214 - ML009 | 0 | 0 | 0 | 0 | 3 | 0 | 6 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5
2021-01-11 15:08:43.492000 | 2021-01-11 00:00:00 | MTU82 - EE004 | 0 | 0 | 0 | 15 | 10 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 108
2021-01-11 15:10:41.453000 | 2021-01-11 00:00:00 | MTU171 - SW006 | 0 | 0 | 0 | 30 | 35 | 35 | 50 | 45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18
2021-01-11 15:11:48.910000 | 2021-01-11 00:00:00 | MTU100 - NE004 | 0 | 0 | 0 | 34 | 15 | 22 | 9 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
2021-01-11 15:13:09.028000 | 2021-01-11 00:00:00 | MTU1 - NW009 | 0 | 0 | 0 | 0 | 20 | 8 | 14 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9
2021-01-11 15:13:33.271000 | 2021-01-11 00:00:00 | MTU141 - EE003 | 0 | 0 | 0 | 85 | 50 | 80 | 55 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 55
2021-01-11 15:13:39.248000 | 2021-01-11 00:00:00 | MTU92 - NW009 | 0 | 0 | 0 | 0 | 36 | 26 | 48 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 64
2021-01-11 15:14:25.808000 | 2021-01-11 00:00:00 | LTS604 - Westgate Car Park | 0 | 0 | 10 | 10 | 16 | 13 | 11 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12
2021-01-11 15:16:28.800000 | 2021-01-11 00:00:00 | LTS517 - Dewsbury Railway Station Car Park | 0 | 0 | 4 | 5 | 4 | 10 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 15:19:07.519000 | 2021-01-11 00:00:00 | MTU107 - NW005 | 0 | 0 | 0 | 0 | 28 | 14 | 7 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15
2021-01-11 15:19:28.843000 | 2021-01-11 00:00:00 | MTU108 - NW009 | 0 | 0 | 0 | 10 | 60 | 46 | 12 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25
2021-01-11 15:19:56.286000 | 2021-01-11 00:00:00 | MTU224 - ML009 | 0 | 0 | 0 | 64 | 66 | 46 | 56 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68
2021-01-11 15:21:14.503000 | 2021-01-11 00:00:00 | LTS041 - ASDA Overflow Car Park | 0 | 0 | 16 | 12 | 9 | 13 | 9 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13
2021-01-11 15:24:19.770000 | 2021-01-12 00:00:00 | LTS388 - Edge Hill University- Edge Hill Sports Tennis Courts | 0 | 0 | 7 | 21 | 30 | 25 | 14 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-01-11 15:25:58.902000 | 2021-01-11 00:00:00 | MTU123 - EE007 | 0 | 0 | 0 | 59 | 43 | 45 | 21 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 57
2021-01-11 15:26:04.303000 | 2021-01-11 00:00:00 | MTU1 - NW009 | 0 | 0 | 0 | 14 | 31 | 10 | 15 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30
2021-01-11 15:30:26.179000 | 2021-01-11 00:00:00 | MTU172 - ML009 | 0 | 0 | 0 | 20 | 21 | 19 | 28 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 30
2021-01-11 15:34:23.671000 | 2021-01-11 00:00:00 | MTU239 - ML009 | 0 | 0 | 0 | 0 | 0 | 78 | 85 | 95 | 127 | 0 | 0 | 0 | 0 | 0 | 0 | 127
2021-01-11 15:35:31.011000 | 2021-01-11 00:00:00 | MTU87 - EE004 | 0 | 0 | 0 | 40 | 36 | 69 | 55 | 36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 42
2021-01-11 15:36:51.852000 | 2021-01-11 00:00:00 | MTUSR191 - EE007 | 0 | 0 | 0 | 41 | 30 | 50 | 21 | 61 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60
2021-01-11 15:40:01.006000 | 2021-01-11 00:00:00 | SW006 - Wroughton Park & Ride | 0 | 0 | 0 | 40 | 40 | 40 | 20 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27
2021-01-11 15:40:04.540000 | 2021-01-11 00:00:00 | MTU128 - LN003 | 0 | 0 | 0 | 70 | 40 | 91 | 52 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 97
2021-01-11 15:41:35.421000 | 2021-01-11 00:00:00 | MTUSR192 - NE004 | 0 | 0 | 0 | 26 | 19 | 16 | 13 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 42
2021-01-11 15:41:58.628000 | 2021-01-11 00:00:00 | SE016 - Curtis Way Coach Park | 0 | 0 | 0 | 49 | 37 | 53 | 29 | 44 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36