Spreadsheet: 840953d1693226421-index-formula-merging-result-sample-sheet-1-1-1-
Sheet: Sheet1

 |  |  | PLATFARM NUMBER | TRAIN NUMBER | TRAIN ARRAIVAL TIME | CUSTOMER BOOKING TIME |  | ORDER BOOKED TIME | HOTEL NAME | HOTEL ORDER RECEIVING TIME | ORDER READY TIME | CHECK POSSIBILITY | ORDER PICKUP TIME | CHECK POSSIBILITY | PLATFARM TIME | DELIVERY TIME | DELIVERY PERSON |  |  | TRAIN NUMBER | PLATFARM NUMBER | TRAIN ARRAIVAL TIME | PLATFARM TIME | ORDER PICKUP TIME | ORDER READY Time |  | PLATFARM NUMBER | TRAIN ARRAIVAL TIME | PLATFARM TIME | ORDER PICKUP TIME | ORDERS READY TIME
 |  |  |  |  |  | FROM | TO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 08:32:00 | 08:22:00 | 07:52:00 | 06:20:00
 |  |  | 1 | 89898 | 07:22:00 |  |  | 05:30:00 | XX | 06:00:00 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | 2 | 08:32:00 | 08:22:00 | 07:52:00 | 06:25:00
 |  |  | 1 | 12121 | 07:37:00 |  |  | 05:34:00 | YY | 06:00:00 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | 5 | 10:02:00 | 09:52:00 | 09:22:00 | 08:08:00
 |  |  | 1 | 12121 | 07:37:00 |  |  | 05:34:00 | YY | 06:00:00 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | 5 | 10:02:00 | 09:52:00 | 09:22:00 | 08:13:00
 |  |  | 2 | 15151 | 08:32:00 |  |  | 05:40:00 | XX | 06:00:00 |  |  |  |  |  |  | E |  |  |  |  |  |  |  |  |  | 5 | 10:02:00 | 09:52:00 | 09:22:00 | 08:18:00
 |  |  | 2 | 15151 | 08:32:00 |  |  | 05:42:00 | XX | 06:00:00 |  |  |  |  |  |  | E |  |  |  |  |  |  |  |  |  | 5 | 10:02:00 | 09:52:00 | 09:22:00 | 08:23:00
 |  |  | 2 | 16161 | 08:07:00 |  |  | 06:00:00 | ZZ | 06:00:00 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | 5 | 10:02:00 | 09:52:00 | 09:22:00 | 08:28:00
 |  |  | 2 | 16161 | 08:07:00 |  |  | 06:02:00 | ZZ | 06:00:00 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | 5 | 10:12:00 | 10:02:00 | 09:32:00 | 08:06:00
 |  |  | 2 | 16161 | 08:07:00 |  |  | 06:06:00 | ZZ | 06:00:00 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | 5 | 10:12:00 | 10:02:00 | 09:32:00 | 08:11:00
 |  |  | 2 | 16161 | 08:07:00 |  |  | 06:10:00 | ZZ | 06:00:00 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | 5 | 10:12:00 | 10:02:00 | 09:32:00 | 08:20:00
 |  |  | 2 | 16161 | 08:07:00 |  |  | 06:12:00 | ZZ | 06:00:00 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | 5 | 10:12:00 | 10:02:00 | 09:32:00 | 08:25:00
 |  |  | 4 | 17675 | 08:22:00 |  |  | 06:12:00 | CC | 06:00:00 |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  |  | EXPECTED RESULT
 |  |  | 3 | 13145 | 08:07:00 |  |  | 06:13:00 | BB | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 2 | 16161 | 08:07:00 |  |  | 06:14:00 | ZZ | 06:00:00 |  |  |  |  |  |  | A
 |  |  | 2 | 16161 | 08:07:00 |  |  | 06:14:00 | ZZ | 06:00:00 |  |  |  |  |  |  | A
 |  |  | 4 | 17675 | 08:22:00 |  |  | 06:15:00 | CC | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 3 | 13145 | 08:07:00 |  |  | 06:15:00 | BB | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 3 | 13145 | 08:07:00 |  |  | 06:16:00 | BB | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 2 | 16161 | 08:07:00 |  |  | 06:16:00 | ZZ | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 2 | 16161 | 08:07:00 |  |  | 06:17:00 | ZZ | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 2 | 16161 | 08:07:00 |  |  | 06:17:00 | ZZ | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 4 | 17675 | 08:22:00 |  |  | 06:20:00 | CC | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 4 | 17675 | 08:22:00 |  |  | 06:23:00 | CC | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 4 | 18685 | 08:27:00 |  |  | 06:25:00 | YY | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 4 | 64645 | 08:32:00 |  |  | 06:28:00 | AA | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 4 | 64645 | 08:32:00 |  |  | 06:30:00 | AA | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 4 | 64645 | 08:32:00 |  |  | 06:34:00 | AA | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 4 | 64645 | 08:32:00 |  |  | 06:36:00 | AA | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 4 | 89898 | 08:47:00 |  |  | 06:36:00 | XX | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 4 | 64645 | 08:32:00 |  |  | 06:37:00 | AA | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 4 | 64645 | 08:32:00 |  |  | 06:38:00 | AA | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 4 | 64645 | 08:32:00 |  |  | 06:38:00 | AA | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 4 | 64645 | 08:32:00 |  |  | 06:39:00 | AA | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 4 | 64645 | 08:32:00 |  |  | 06:40:00 | AA | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 4 | 64645 | 08:32:00 |  |  | 06:40:00 | AA | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 4 | 89898 | 08:47:00 |  |  | 06:42:00 | XX | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 1 | 14141 | 09:02:00 |  |  | 06:46:00 | BB | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 4 | 89898 | 08:47:00 |  |  | 06:48:00 | XX | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 1 | 14141 | 09:02:00 |  |  | 06:48:00 | BB | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 1 | 14141 | 09:02:00 |  |  | 06:49:00 | BB | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 1 | 14141 | 09:02:00 |  |  | 06:50:00 | BB | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 4 | 89898 | 08:47:00 |  |  | 06:52:00 | XX | 06:00:00 |  |  |  |  |  |  | A
 |  |  | 4 | 89898 | 08:47:00 |  |  | 06:54:00 | XX | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 4 | 89898 | 08:47:00 |  |  | 06:54:00 | XX | 06:00:00 |  |  |  |  |  |  | A
 |  |  | 4 | 89898 | 08:47:00 |  |  | 06:55:00 | XX | 06:00:00 |  |  |  |  |  |  | A
 |  |  | 4 | 89898 | 08:47:00 |  |  | 06:55:00 | XX | 06:00:00 |  |  |  |  |  |  | A
 |  |  | 1 | 14141 | 09:02:00 |  |  | 06:56:00 | BB | 06:00:00 |  |  |  |  |  |  | C
 |  |  | 1 | 14141 | 09:02:00 |  |  | 06:56:00 | BB | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 4 | 89898 | 08:47:00 |  |  | 06:57:00 | XX | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 4 | 89898 | 08:47:00 |  |  | 06:57:00 | XX | 06:00:00 |  |  |  |  |  |  | A
 |  |  | 1 | 14141 | 09:02:00 |  |  | 07:00:00 | BB | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 1 | 14141 | 09:02:00 |  |  | 07:01:00 | BB | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 1 | 65853 | 09:42:00 |  |  | 07:24:00 | YY | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 1 | 65853 | 09:42:00 |  |  | 07:25:00 | YY | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 1 | 65853 | 09:42:00 |  |  | 07:25:00 | YY | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 1 | 65853 | 09:42:00 |  |  | 07:28:00 | YY | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 1 | 65853 | 09:42:00 |  |  | 07:30:00 | YY | 06:00:00 |  |  |  |  |  |  | D
 |  |  | 1 | 65853 | 09:42:00 |  |  | 07:35:00 | YY | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 5 | 15151 | 10:02:00 |  |  | 07:45:00 | ZZ | 06:00:00 |  |  |  |  |  |  | A
 |  |  | 5 | 15151 | 10:02:00 |  |  | 07:48:00 | ZZ | 06:00:00 |  |  |  |  |  |  | A
 |  |  | 1 | 65853 | 09:42:00 |  |  | 07:50:00 | YY | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 1 | 65853 | 09:42:00 |  |  | 07:52:00 | YY | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 1 | 65853 | 09:42:00 |  |  | 07:54:00 | YY | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 5 | 15151 | 10:02:00 |  |  | 07:58:00 | ZZ | 06:00:00 |  |  |  |  |  |  | A
 |  |  | 1 | 65853 | 09:42:00 |  |  | 08:00:00 | YY | 06:00:00 |  |  |  |  |  |  | B
 |  |  | 5 | 95851 | 10:12:00 |  |  | 08:01:00 | BB | 06:00:00 |  |  |  |  |  |  | E
 |  |  | 5 | 95851 | 10:12:00 |  |  | 08:02:00 | BB | 06:00:00 |  |  |  |  |  |  | E
 |  |  | 5 | 15151 | 10:02:00 |  |  | 08:02:00 | ZZ | 06:00:00 |  |  |  |  |  |  | E
 |  |  | 5 | 15151 | 10:02:00 |  |  | 08:03:00 | ZZ | 06:00:00 |  |  |  |  |  |  | E
 |  |  | 5 | 15151 | 10:02:00 |  |  | 08:03:00 | ZZ | 06:00:00 |  |  |  |  |  |  | E
 |  |  | 5 | 15151 | 10:02:00 |  |  | 08:04:00 | ZZ | 06:00:00 |  |  |  |  |  |  | E
 |  |  | 5 | 15151 | 10:02:00 |  |  | 08:05:00 | ZZ | 06:00:00 |  |  |  |  |  |  | E
 |  |  | 5 | 95851 | 10:12:00 |  |  | 08:15:00 | BB | 06:00:00 |  |  |  |  |  |  | E
 |  |  | 5 | 95851 | 10:12:00 |  |  | 08:18:00 | BB | 06:00:00 |  |  |  |  |  |  | E