Spreadsheet: 118836d1314038293-conditional-formula-for-time-window-to-include-a-buffer-zone-books3
Sheet: Sheet1

Route | Route Position | [NAME] | Order # | Name | Phone | Quantity | Time Window | Time Window 2 | Status | Time Difference | Store # | Delivery Type | Product Description/Special Notes | Invoice Description | Address
 |  | 15:13:00 |  |  |  |  | 15:15:00 | 18:15:00
 |  | 19:32:00 |  |  |  |  | 18:00:00 | 21:00:00
 |  | 18:20:00 |  |  |  |  | 16:30:00 | 19:30:00
 |  | 15:45:00 |  |  |  |  | 15:30:00 | 18:30:00
 |  | 11:09:00 |  |  |  |  | 9:00:00 | 12:00:00
 |  | 10:15:00 |  |  |  |  | 10:00:00 | 13:00:00
 |  | 13:30:00 |  |  |  |  | 13:00:00 | 16:00:00
 |  | 13:43:00 |  |  |  |  | 13:30:00 | 16:30:00
 |  | 08:33:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 12:14:00 |  |  |  |  | 12:30:00 | 15:30:00
 |  | 19:20:00 |  |  |  |  | 16:30:00 | 19:30:00
 |  | 12:20:00 |  |  |  |  | 11:15:00 | 14:15:00
 |  | 11:16:00 |  |  |  |  | 10:45:00 | 13:45:00
 |  | 08:09:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 08:24:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 16:46:00 |  |  |  |  | 13:45:00 | 16:45:00
 |  | 16:26:00 |  |  |  |  | 13:15:00 | 16:15:00
 |  | 08:01:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 07:23:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 11:57:00 |  |  |  |  | 12:00:00 | 15:00:00
 |  | 11:11:00 |  |  |  |  | 11:45:00 | 14:45:00
 |  | 17:52:00 |  |  |  |  | 18:00:00 | 21:00:00
 |  | 17:52:00 |  |  |  |  | 18:00:00 | 21:00:00
 |  | 18:33:00 |  |  |  |  | 16:15:00 | 19:15:00
 |  | 14:46:00 |  |  |  |  | 12:15:00 | 15:15:00
 |  | 14:02:00 |  |  |  |  | 14:30:00 | 17:30:00
 |  | 17:49:00 |  |  |  |  | 18:00:00 | 21:00:00
 |  | 10:31:00 |  |  |  |  | 9:45:00 | 12:45:00
 |  | 10:02:00 |  |  |  |  | 10:00:00 | 13:00:00
 |  | 10:05:00 |  |  |  |  | 9:30:00 | 12:30:00
 |  | 12:28:00 |  |  |  |  | 11:30:00 | 14:30:00
 |  | 08:30:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 08:20:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 09:02:00 |  |  |  |  | 8:30:00 | 11:30:00
 |  | 08:40:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 08:02:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 09:22:00 |  |  |  |  | 8:45:00 | 11:45:00
 |  | 08:38:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 08:21:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 12:13:00 |  |  |  |  | 11:00:00 | 14:00:00
 |  | 09:47:00 |  |  |  |  | 10:00:00 | 13:00:00
 |  | 09:47:00 |  |  |  |  | 9:30:00 | 12:30:00
 |  | 13:19:00 |  |  |  |  | 12:30:00 | 15:30:00
 |  | 10:56:00 |  |  |  |  | 11:00:00 | 14:00:00
 |  | 10:57:00 |  |  |  |  | 11:15:00 | 14:15:00
 |  | 10:01:00 |  |  |  |  | 10:15:00 | 13:15:00
 |  | 18:00:00 |  |  |  |  | 18:00:00 | 21:00:00
 |  | 09:15:00 |  |  |  |  | 8:30:00 | 11:30:00
 |  | 09:25:00 |  |  |  |  | 8:45:00 | 11:45:00
 |  | 08:43:00 |  |  |  |  | 8:15:00 | 11:15:00
 |  | 12:17:00 |  |  |  |  | 11:15:00 | 14:15:00
 |  | 11:14:00 |  |  |  |  | 11:45:00 | 14:45:00
 |  | 11:41:00 |  |  |  |  | 12:00:00 | 15:00:00
 |  | 11:25:00 |  |  |  |  | 10:45:00 | 13:45:00
 |  | 12:57:00 |  |  |  |  | 12:00:00 | 15:00:00
 |  | 07:33:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 17:37:00 |  |  |  |  | 14:30:00 | 17:30:00
 |  | 12:37:00 |  |  |  |  | 11:45:00 | 14:45:00
 |  | 09:23:00 |  |  |  |  | 9:15:00 | 12:15:00
 |  | 09:35:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 09:10:00 |  |  |  |  | 9:15:00 | 12:15:00
 |  | 17:43:00 |  |  |  |  | 15:00:00 | 18:00:00
 |  | 08:40:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 08:12:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 09:02:00 |  |  |  |  | 8:15:00 | 11:15:00
 |  | 09:03:00 |  |  |  |  | 8:30:00 | 11:30:00
 |  | 14:55:00 |  |  |  |  | 15:15:00 | 18:15:00
 |  | 09:01:00 |  |  |  |  | 8:45:00 | 11:45:00
 |  | 07:15:00 |  |  |  |  | 9:00:00 | 12:00:00
 |  | 10:22:00 |  |  |  |  | 9:45:00 | 12:45:00
 |  | 09:59:00 |  |  |  |  | 9:15:00 | 12:15:00
 |  | 17:05:00 |  |  |  |  | 14:45:00 | 17:45:00
 |  | 16:25:00 |  |  |  |  | 16:00:00 | 19:00:00
 |  | 14:58:00 |  |  |  |  | 11:45:00 | 14:45:00
 |  | 11:50:00 |  |  |  |  | 9:15:00 | 12:15:00
 |  | 11:59:00 |  |  |  |  | 9:45:00 | 12:45:00
 |  | 10:15:00 |  |  |  |  | 10:30:00 | 13:30:00
 |  | 17:46:00 |  |  |  |  | 15:30:00 | 18:30:00
 |  | 12:31:00 |  |  |  |  | 10:00:00 | 13:00:00
 |  | 16:02:00 |  |  |  |  | 16:00:00 | 19:00:00
 |  | 14:13:00 |  |  |  |  | 14:00:00 | 17:00:00
 |  | 13:53:00 |  |  |  |  | 13:45:00 | 16:45:00
 |  | 19:21:00 |  |  |  |  | 17:30:00 | 20:30:00
 |  | 18:03:00 |  |  |  |  | 17:45:00 | 20:45:00
 |  | 16:30:00 |  |  |  |  | 16:00:00 | 19:00:00
 |  | 16:10:00 |  |  |  |  | 18:00:00 | 21:00:00
 |  | 13:08:00 |  |  |  |  | 13:30:00 | 16:30:00
 |  | 14:59:00 |  |  |  |  | 13:00:00 | 16:00:00
 |  | 07:56:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 11:34:00 |  |  |  |  | 11:00:00 | 14:00:00
 |  | 09:32:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 13:05:00 |  |  |  |  | 13:00:00 | 16:00:00
 |  | 15:19:00 |  |  |  |  | 13:15:00 | 16:15:00
 |  | 15:23:00 |  |  |  |  | 15:00:00 | 18:00:00
 |  | 17:04:00 |  |  |  |  | 16:30:00 | 19:30:00
 |  | 15:22:00 |  |  |  |  | 14:45:00 | 17:45:00
 |  | 13:28:00 |  |  |  |  | 13:15:00 | 16:15:00
 |  | 17:34:00 |  |  |  |  | 17:00:00 | 20:00:00
 |  | 14:19:00 |  |  |  |  | 14:30:00 | 17:30:00
 |  | 09:29:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 15:42:00 |  |  |  |  | 15:30:00 | 18:30:00
 |  | 16:37:00 |  |  |  |  | 13:15:00 | 16:15:00
 |  | 16:37:00 |  |  |  |  | 13:15:00 | 16:15:00
 |  | 13:28:00 |  |  |  |  | 12:15:00 | 15:15:00
 |  | 14:57:00 |  |  |  |  | 13:30:00 | 16:30:00
 |  | 11:40:00 |  |  |  |  | 9:30:00 | 12:30:00
 |  | 10:22:00 |  |  |  |  | 10:00:00 | 13:00:00
 |  | 10:14:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 18:09:00 |  |  |  |  | 16:30:00 | 19:30:00
 |  | 10:41:00 |  |  |  |  | 10:00:00 | 13:00:00
 |  | 15:31:00 |  |  |  |  | 15:30:00 | 18:30:00
 |  | 09:55:00 |  |  |  |  | 9:45:00 | 12:45:00
 |  | 15:16:00 |  |  |  |  | 12:00:00 | 15:00:00
 |  | 16:54:00 |  |  |  |  | 16:30:00 | 19:30:00
 |  | 16:44:00 |  |  |  |  | 14:15:00 | 17:15:00
 |  | 15:31:00 |  |  |  |  | 12:30:00 | 15:30:00
 |  | 15:04:00 |  |  |  |  | 15:00:00 | 18:00:00
 |  | 14:44:00 |  |  |  |  | 14:30:00 | 17:30:00
 |  | 11:36:00 |  |  |  |  | 9:00:00 | 12:00:00
 |  | 11:22:00 |  |  |  |  | 8:30:00 | 11:30:00
 |  | 13:28:00 |  |  |  |  | 13:45:00 | 16:45:00
 |  | 10:37:00 |  |  |  |  | 8:15:00 | 11:15:00
 |  | 09:48:00 |  |  |  |  | 8:45:00 | 11:45:00
 |  | 13:15:00 |  |  |  |  | 11:00:00 | 14:00:00
 |  | 14:01:00 |  |  |  |  | 13:45:00 | 16:45:00
 |  | 18:32:00 |  |  |  |  | 16:30:00 | 19:30:00
 |  | 11:28:00 |  |  |  |  | 9:15:00 | 12:15:00
 |  | 06:46:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 07:58:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 09:30:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 09:37:00 |  |  |  |  | 8:15:00 | 11:15:00
 |  | 15:42:00 |  |  |  |  | 14:30:00 | 17:30:00
 |  | 15:43:00 |  |  |  |  | 13:00:00 | 16:00:00
 |  | 19:00:00 |  |  |  |  | 17:15:00 | 20:15:00
 |  | 10:02:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 08:26:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 13:14:00 |  |  |  |  | 11:15:00 | 14:15:00
 |  | 12:40:00 |  |  |  |  | 12:45:00 | 15:45:00
 |  | 13:50:00 |  |  |  |  | 14:00:00 | 17:00:00
 |  | 16:10:00 |  |  |  |  | 16:45:00 | 19:45:00
 |  | 15:05:00 |  |  |  |  | 16:00:00 | 19:00:00
 |  | 16:42:00 |  |  |  |  | 17:15:00 | 20:15:00
 |  | 17:46:00 |  |  |  |  | 17:45:00 | 20:45:00
 |  | 13:36:00 |  |  |  |  | 12:45:00 | 15:45:00
 |  | 13:06:00 |  |  |  |  | 12:15:00 | 15:15:00
 |  | 13:53:00 |  |  |  |  | 13:00:00 | 16:00:00
 |  | 15:52:00 |  |  |  |  | 14:30:00 | 17:30:00
 |  | 15:40:00 |  |  |  |  | 14:15:00 | 17:15:00
 |  | 17:11:00 |  |  |  |  | 14:00:00 | 17:00:00
 |  | 16:47:00 |  |  |  |  | 15:00:00 | 18:00:00
 |  | 13:45:00 |  |  |  |  | 12:45:00 | 15:45:00
 |  | 10:55:00 |  |  |  |  | 10:15:00 | 13:15:00
 |  | 06:51:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 14:30:00 |  |  |  |  | 14:45:00 | 17:45:00
 |  | 12:55:00 |  |  |  |  | 13:30:00 | 16:30:00
 |  | 12:53:00 |  |  |  |  | 12:45:00 | 15:45:00
 |  | 15:54:00 |  |  |  |  | 15:00:00 | 18:00:00
 |  | 15:06:00 |  |  |  |  | 15:30:00 | 18:30:00
 |  | 15:34:00 |  |  |  |  | 14:45:00 | 17:45:00
 |  | 18:01:00 |  |  |  |  | 15:00:00 | 18:00:00
 |  | 08:20:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 14:07:00 |  |  |  |  | 13:15:00 | 16:15:00
 |  | 15:09:00 |  |  |  |  | 14:15:00 | 17:15:00
 |  | 14:49:00 |  |  |  |  | 14:00:00 | 17:00:00
 |  | 08:44:00 |  |  |  |  | 8:15:00 | 11:15:00
 |  | 12:54:00 |  |  |  |  | 13:00:00 | 16:00:00
 |  | 10:30:00 |  |  |  |  | 9:45:00 | 12:45:00
 |  | 09:57:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  |  |  |  |  |  | 8:00:00 | 11:00:00
 |  |  |  |  |  |  | 8:00:00 | 11:00:00
 |  | 09:41:00 |  |  |  |  | 9:15:00 | 12:15:00
 |  | 08:56:00 |  |  |  |  | 8:30:00 | 11:30:00
 |  | 14:28:00 |  |  |  |  | 13:30:00 | 16:30:00
 |  | 09:17:00 |  |  |  |  | 9:00:00 | 12:00:00
 |  | 11:16:00 |  |  |  |  | 10:30:00 | 13:30:00
 |  | 16:00:00 |  |  |  |  | 13:00:00 | 16:00:00
 |  | 14:52:00 |  |  |  |  | 12:30:00 | 15:30:00
 |  | 08:52:00 |  |  |  |  | 8:30:00 | 11:30:00
 |  | 10:43:00 |  |  |  |  | 10:30:00 | 13:30:00
 |  | 09:23:00 |  |  |  |  | 9:00:00 | 12:00:00
 |  | 16:02:00 |  |  |  |  | 12:45:00 | 15:45:00
 |  | 16:38:00 |  |  |  |  | 14:00:00 | 17:00:00
 |  | 14:07:00 |  |  |  |  | 11:15:00 | 14:15:00
 |  | 13:14:00 |  |  |  |  | 10:30:00 | 13:30:00
 |  | 08:59:00 |  |  |  |  | 8:15:00 | 11:15:00
 |  | 11:55:00 |  |  |  |  | 11:00:00 | 14:00:00
 |  | 10:57:00 |  |  |  |  | 10:30:00 | 13:30:00
 |  | 17:05:00 |  |  |  |  | 14:45:00 | 17:45:00
 |  | 14:18:00 |  |  |  |  | 12:00:00 | 15:00:00
 |  | 13:55:00 |  |  |  |  | 11:45:00 | 14:45:00
 |  | 15:53:00 |  |  |  |  | 13:45:00 | 16:45:00
 |  | 15:53:00 |  |  |  |  | 13:30:00 | 16:30:00
 |  | 13:39:00 |  |  |  |  | 11:30:00 | 14:30:00
 |  | 13:13:00 |  |  |  |  | 11:00:00 | 14:00:00
 |  | 12:38:00 |  |  |  |  | 10:45:00 | 13:45:00
 |  | 15:21:00 |  |  |  |  | 14:15:00 | 17:15:00
 |  | 08:21:00 |  |  |  |  | 8:15:00 | 11:15:00
 |  | 11:48:00 |  |  |  |  | 10:45:00 | 13:45:00
 |  | 14:37:00 |  |  |  |  | 12:30:00 | 15:30:00
 |  | 13:44:00 |  |  |  |  | 11:45:00 | 14:45:00
 |  | 10:57:00 |  |  |  |  | 9:15:00 | 12:15:00
 |  | 09:37:00 |  |  |  |  | 9:15:00 | 12:15:00
 |  | 14:16:00 |  |  |  |  | 12:15:00 | 15:15:00
 |  | 08:47:00 |  |  |  |  | 8:45:00 | 11:45:00
 |  | 12:10:00 |  |  |  |  | 11:45:00 | 14:45:00
 |  | 17:57:00 |  |  |  |  | 15:45:00 | 18:45:00
 |  | 18:10:00 |  |  |  |  | 16:15:00 | 19:15:00
 |  | 12:51:00 |  |  |  |  | 12:30:00 | 15:30:00
 |  | 16:51:00 |  |  |  |  | 15:00:00 | 18:00:00
 |  | 13:36:00 |  |  |  |  | 10:45:00 | 13:45:00
 |  | 09:30:00 |  |  |  |  | 9:30:00 | 12:30:00
 |  | 08:30:00 |  |  |  |  | 8:15:00 | 11:15:00
 |  | 14:59:00 |  |  |  |  | 15:00:00 | 18:00:00
 |  | 07:55:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 19:12:00 |  |  |  |  | 16:30:00 | 19:30:00
 |  | 19:32:00 |  |  |  |  | 17:00:00 | 20:00:00
 |  | 19:11:00 |  |  |  |  | 16:00:00 | 19:00:00
 |  | 17:11:00 |  |  |  |  | 15:45:00 | 18:45:00
 |  | 18:33:00 |  |  |  |  | 15:30:00 | 18:30:00
 |  | 09:24:00 |  |  |  |  | 9:15:00 | 12:15:00
 |  | 08:35:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 10:34:00 |  |  |  |  | 10:30:00 | 13:30:00
 |  | 10:29:00 |  |  |  |  | 10:15:00 | 13:15:00
 |  | 11:00:00 |  |  |  |  | 9:45:00 | 12:45:00
 |  | 09:00:00 |  |  |  |  | 8:15:00 | 11:15:00
 |  | 08:36:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 09:01:00 |  |  |  |  | 8:45:00 | 11:45:00
 |  | 15:17:00 |  |  |  |  | 12:45:00 | 15:45:00
 |  | 12:19:00 |  |  |  |  | 11:30:00 | 14:30:00
 |  | 07:13:00 |  |  |  |  | 8:00:00 | 11:00:00
 |  | 13:14:00 |  |  |  |  | 11:45:00 | 14:45:00
 |  | 09:26:00 |  |  |  |  | 9:00:00 | 12:00:00
 |  | 13:29:00 |  |  |  |  | 14:15:00 | 17:15:00
 |  | 10:32:00 |  |  |  |  | 10:15:00 | 13:15:00
 |  | 10:03:00 |  |  |  |  | 9:15:00 | 12:15:00
 |  | 15:20:00 |  |  |  |  | 14:00:00 | 17:00:00
 |  | 12:10:00 |  |  |  |  | 10:00:00 | 13:00:00
 |  | 12:20:00 |  |  |  |  | 10:15:00 | 13:15:00
 |  | 12:41:00 |  |  |  |  | 11:45:00 | 14:45:00