Spreadsheet: 747087d1631210133-difference-between-2-times-works-sometimes-but-not-others-demo-file
Sheet: Departures Worksheet

 |  |  |  |  |  |  |  |  |  | Desired Table Order
Scheduled | Flight | To | Gate | Airline | Date Checked | Terminal | Relevant Flight |  |  | Start Time | End Time | Flight Count |  | Start Time | End Time | Flight Count
00:05:00 | WS652 | Toronto | D72 | WestJet | 2021-09-09 00:00:00 | D | Yes
00:15:00 | AC156 | Toronto | D78 | Air Canada | 2021-09-09 00:00:00 | D | Yes
06:20:00 | AC316 | Montreal | D74 | Air Canada | 2021-09-09 00:00:00 | D | No
08:00:00 | AC132 | Toronto | D86 | Air Canada | 2021-09-09 00:00:00 | D | No
08:00:00 | WS105 | Vancouver | [NAME] | WestJet | 2021-09-09 00:00:00 | D | No
09:00:00 | AC134 | Toronto | D79 | Air Canada | 2021-09-09 00:00:00 | D | No
09:05:00 | AC8336 | Winnipeg | D95 | Air Canada | 2021-09-09 00:00:00 | D | No
09:10:00 | AC8434 | Regina | D88 | Air Canada | 2021-09-09 00:00:00 | D | No
09:25:00 | [NAME] | [NAME] | D78 | WestJet | 2021-09-09 00:00:00 | D | No
09:25:00 | WS268 | Winnipeg | D85 | WestJet | 2021-09-09 00:00:00 | D | No
09:30:00 | WS3242 | [NAME] | D90 | WestJet | 2021-09-09 00:00:00 | D | No
09:30:00 | WS656 | Toronto | [NAME] | WestJet | 2021-09-09 00:00:00 | D | No
09:45:00 | WS3296 | Regina | D89 | WestJet | 2021-09-09 00:00:00 | D | No
09:50:00 | WS195 | Victoria | D81 | WestJet | 2021-09-09 00:00:00 | D | No
09:50:00 | WS2310 | [NAME] | D87 | WestJet | 2021-09-09 00:00:00 | D | No
09:55:00 | AC674 | Halifax | [NAME] | Air Canada | 2021-09-09 00:00:00 | D | No
10:00:00 | WS187 | Kelowna | D94 | WestJet | 2021-09-09 00:00:00 | D | No
10:00:00 | WS3281 | Penticton | D91 | WestJet | 2021-09-09 00:00:00 | D | No
10:30:00 | WS658 | Toronto | D86 | WestJet | 2021-09-09 00:00:00 | D | No
10:50:00 | AC8425 | Kamloops | D88 | Air Canada | 2021-09-09 00:00:00 | D | No
11:30:00 | [NAME] | Toronto | D80 | WestJet | 2021-09-09 00:00:00 | D | No
11:55:00 | AC140 | Toronto | D78 | Air Canada | 2021-09-09 00:00:00 | D | No
11:55:00 | AC318 | Montreal | [NAME] | Air Canada | 2021-09-09 00:00:00 | D | No |  |  | 00:00:00
13:30:00 | WS664 | Toronto | D72 | WestJet | 2021-09-09 00:00:00 | D | No
14:35:00 | AC144 | Toronto | [NAME] | Air Canada | 2021-09-09 00:00:00 | D | No
14:45:00 | AC8436 | Regina | [NAME] | Air Canada | 2021-09-09 00:00:00 | D | No
14:45:00 | AC8586 | Saskatoon | D89 | Air Canada | 2021-09-09 00:00:00 | D | No
14:50:00 | AC8403 | Kelowna | D88 | Air Canada | 2021-09-09 00:00:00 | D | No |  |  |  |  | This should say '2', not '0'
15:15:00 | KL678 | Amsterdam | [NAME] | KLM Royal Dutch Airlines | 2021-09-09 00:00:00 | D | No
15:15:00 | WS298 | Regina | D79 | WestJet | 2021-09-09 00:00:00 | D | No
15:15:00 | WS358 | Saskatoon | D70 | WestJet | 2021-09-09 00:00:00 | D | No
15:15:00 | WS479 | Kelowna | D72 | WestJet | 2021-09-09 00:00:00 | D | No
15:30:00 | WS119 | Vancouver | D78 | WestJet | 2021-09-09 00:00:00 | D | No
17:00:00 | WS3442 | Saskatoon | D71 | WestJet | 2021-09-09 00:00:00 | D | No
17:10:00 | AC848 | Frankfurt | D74 | Air Canada | 2021-09-09 00:00:00 | D | No
17:30:00 | WS123 | Vancouver | D73 | WestJet | 2021-09-09 00:00:00 | D | No
18:30:00 | AC223 | Vancouver | D70 | Air Canada | 2021-09-09 00:00:00 | D | Yes
18:30:00 | WS001 | London-LGW | D78 | WestJet | 2021-09-09 00:00:00 | D | Yes
18:45:00 | WS3370 | Saskatoon | D94 | WestJet | 2021-09-09 00:00:00 | D | Yes
19:10:00 | AC8144 | Edmonton | D89 | Air Canada | 2021-09-09 00:00:00 | D | Yes
19:10:00 | AC8277 | Nanaimo | D95 | Air Canada | 2021-09-09 00:00:00 | D | Yes
19:10:00 | AC8340 | Winnipeg | D90 | Air Canada | 2021-09-09 00:00:00 | D | Yes
19:10:00 | AC8377 | [NAME] | D88 | Air Canada | 2021-09-09 00:00:00 | D | Yes
19:15:00 | WS127 | Vancouver | [NAME] | WestJet | 2021-09-09 00:00:00 | D | Yes
19:30:00 | AC225 | Vancouver | D73 | Air Canada | 2021-09-09 00:00:00 | D | Yes
19:30:00 | [NAME] | Paris | [NAME] | WestJet | 2021-09-09 00:00:00 | D | Yes
20:10:00 | AC8223 | Yellowknife | D91 | Air Canada | 2021-09-09 00:00:00 | D | Yes
21:00:00 | [NAME] | Winnipeg | D81 | WestJet | 2021-09-09 00:00:00 | D | Yes
21:15:00 | [NAME] | Vancouver | D78 | WestJet | 2021-09-09 00:00:00 | D | Yes
23:15:00 | WS228 | Halifax | D70 | WestJet | 2021-09-09 00:00:00 | D | Yes
23:15:00 | WS237 | Edmonton | D72 | WestJet | 2021-09-09 00:00:00 | D | Yes
23:15:00 | WS296 | Regina | D73 | WestJet | 2021-09-09 00:00:00 | D | Yes
23:15:00 | WS600 | Saskatoon | D71 | WestJet | 2021-09-09 00:00:00 | D | Yes