Spreadsheet: 550556d1512422538-trouble-getting-times-to-format-as-hh-mm-24-hour-format-s666-trouble-getting-times-to-format-as-hhmm-24-hour-format-
Sheet: Sheet2

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16
DRV0151415 | 2017-11-01 13:06:53 | DN40027113 | 8361 | 2017-11-01 12:09:31 | 2017-11-01 12:09:53 | 7645 | 2017-11-01 12:20:07 | 2017-11-01 12:21:39 | 7645 | 2017-11-01 12:10:14 | 2017-11-01 12:25:09 | 8430 | 2017-11-01 12:38:08 | 8430 | 2017-11-01 12:44:07
DRV0151415 | 2017-11-01 13:06:53 | DN40027113 | 8361 | 2017-11-01 12:09:31 | 2017-11-01 12:09:53 | 7645 | 2017-11-01 12:20:07 | 2017-11-01 12:21:39 | 7645 | 2017-11-01 12:10:14 | 2017-11-01 12:25:09 | 6198 | 2017-11-01 13:03:16 | 6198 | 2017-11-01 13:03:29
DRV0152299 | 2017-11-01 13:08:00 | DN40263560 | 7081 | 2017-11-01 12:22:47 | 2017-11-01 12:22:53 | 5555 | 2017-11-01 12:45:08 | 2017-11-01 12:45:36 | 7081 | 2017-11-01 12:24:05 | 2017-11-01 12:28:59 | 5555 | 2017-11-01 12:52:07 | 5905 | 2017-11-01 13:02:21
DRV0150911 | 2017-11-01 13:08:13 | DN40396164 | 7260 | 2017-11-01 12:22:03 | 2017-11-01 12:22:10 | 7260 | 2017-11-01 12:42:05 | 2017-11-01 12:42:12 | 7260 | 2017-11-01 12:22:16 | 2017-11-01 12:41:54 | 7688 | 2017-11-01 12:57:22 | 7688 | 2017-11-01 13:04:32
DRV0152299 | 2017-11-01 13:09:03 | DN40237416 | 6528 | 2017-11-01 12:23:57 | 2017-11-01 12:24:04 | 7096 | 2017-11-01 12:40:21 | 2017-11-01 12:43:52 | 6528 | 2017-11-01 12:24:24 | 2017-11-01 12:29:55 | 6683 | 2017-11-01 12:55:16 | 6683 | 2017-11-01 13:05:41
DRV0152299 | 2017-11-01 13:09:03 | DN40237416 | 6528 | 2017-11-01 12:23:57 | 2017-11-01 12:24:04 | 7096 | 2017-11-01 12:40:21 | 2017-11-01 12:43:52 | 6528 | 2017-11-01 12:24:24 | 2017-11-01 12:29:55 | 6683 | 2017-11-01 12:55:10 | 6683 | 2017-11-01 13:05:41
DRV0152299 | 2017-11-01 13:10:40 | DN21504129 | 7096 | 2017-11-01 12:50:38 | 2017-11-01 12:50:45 | 7096 | 2017-11-01 13:03:58 | 2017-11-01 13:09:49 | 7096 | 2017-11-01 12:51:55 | 2017-11-01 12:58:56
DRV0148414 | 2017-11-01 13:11:05 | NEW | 6088 | 2017-11-01 12:00:54 | 2017-11-01 12:01:00 | 6088 | 2017-11-01 12:08:56 | 2017-11-01 12:09:01 | 6088 | 2017-11-01 12:02:55 | 2017-11-01 12:21:06 | 8269 | 2017-11-01 12:48:29 | 8269 | 2017-11-01 13:07:59
DRV0152611 | 2017-11-01 13:11:20 | DN22027185 | 7829 | 2017-11-01 12:57:21 | 2017-11-01 12:57:31 | 7829 |  |  | 7829 | 2017-11-01 12:58:14
DRV0150482 | 2017-11-01 13:13:19 | DN40388006 | 7826 | 2017-11-01 12:37:14 | 2017-11-01 12:37:23 | 7826 | 2017-11-01 12:49:06 | 2017-11-01 12:49:08 | 7826 | 2017-11-01 12:37:50 | 2017-11-01 12:44:55 | 8425 | 2017-11-01 12:55:53 | 8425 | 2017-11-01 13:10:36
DRV0151342 | 2017-11-01 13:13:27 | DN40381922 | 6505 | 2017-11-01 12:47:27 | 2017-11-01 12:47:48 | 6505 | 2017-11-01 12:56:54 | 2017-11-01 12:56:55 | 6505 | 2017-11-01 12:48:02 | 2017-11-01 12:51:46 | 7225 | 2017-11-01 13:02:20 | 7225 | 2017-11-01 13:11:21
DRV0150482 | 2017-11-01 13:13:37 | DN40403106 | 8196 | 2017-11-01 12:35:58 | 2017-11-01 12:36:07 | 8196 | 2017-11-01 12:49:45 | 2017-11-01 12:49:47 | 8196 | 2017-11-01 12:36:43 | 2017-11-01 12:44:33 | 7038 | 2017-11-01 12:58:15 | 8417 | 2017-11-01 13:08:54
DRV0150911 | 2017-11-01 13:13:57 | DN40396171 | 5806 | 2017-11-01 12:19:42 | 2017-11-01 12:19:51 | 5806 | 2017-11-01 12:40:49 | 2017-11-01 12:40:51 | 5806 | 2017-11-01 12:20:28 | 2017-11-01 12:25:24 | 7688 | 2017-11-01 13:00:00 | 7688 | 2017-11-01 13:11:24
DRV0148414 | 2017-11-01 13:14:10 | DN40407844 | 7722 | 2017-11-01 12:30:42 | 2017-11-01 12:30:50 | 7722 | 2017-11-01 12:40:10 | 2017-11-01 12:40:12 | 7722 | 2017-11-01 12:31:00 | 2017-11-01 12:36:15 | 8392 | 2017-11-01 12:48:00 | 8392 | 2017-11-01 13:10:04
DRV0150982 | 2017-11-01 13:14:41 | DN31729513 | 6916 | 2017-11-01 12:46:24 | 2017-11-01 12:46:29 | 6916 | 2017-11-01 12:53:15 | 2017-11-01 12:53:18 | 6916 | 2017-11-01 12:46:44 | 2017-11-01 12:53:14 | 6687 | 2017-11-01 13:05:03 | 6687 | 2017-11-01 13:12:04
DRV0150482 | 2017-11-01 13:16:03 | NEW | 7287 | 2017-11-01 11:59:19 | 2017-11-01 11:59:24 | 8362 | 2017-11-01 12:37:04 | 2017-11-01 12:39:50 | 8362 | 2017-11-01 12:02:23 | 2017-11-01 12:37:02 | 8413 | 2017-11-01 12:48:45 | 8413 | 2017-11-01 13:02:03
DRV0148414 | 2017-11-01 13:16:05 | NEW | 8215 | 2017-11-01 12:34:54 | 2017-11-01 12:34:59 | 8215 | 2017-11-01 12:44:49 | 2017-11-01 12:44:52 | 8215 | 2017-11-01 12:36:02 | 2017-11-01 12:44:47 | 8427 | 2017-11-01 12:54:26 | 8427 | 2017-11-01 13:11:55
drv0148795 | 2017-11-01 13:17:10 | DN40267834 | 5370 | 2017-11-01 12:49:27 | 2017-11-01 12:49:34 | 5370 | 2017-11-01 12:59:00 | 2017-11-01 12:59:03 | 5370 | 2017-11-01 12:49:48 | 2017-11-01 12:54:55 | 6615 | 2017-11-01 13:07:31 | 6615 | 2017-11-01 13:14:13
DRV0151166 | 2017-11-01 13:18:18 | DN20695469 | 5017 | 2017-11-01 12:50:23 | 2017-11-01 12:50:29 | 5017 | 2017-11-01 12:57:08 | 2017-11-01 12:57:13 | 5017 | 2017-11-01 12:50:42 | 2017-11-01 12:53:52 | 6900 | 2017-11-01 13:01:58 | 6900 | 2017-11-01 13:14:24
DRV0150619 | 2017-11-01 13:19:25 | NEW | 8211 | 2017-11-01 12:45:27 | 2017-11-01 12:45:33 | 7803 | 2017-11-01 12:54:56 | 2017-11-01 12:55:10 | 7803 | 2017-11-01 12:46:26 | 2017-11-01 13:00:19 | 8280 | 2017-11-01 13:06:57 | 8280 | 2017-11-01 13:16:18
DRV0150619 | 2017-11-01 13:19:57 | DN40260528 | 6876 | 2017-11-01 12:41:39 | 2017-11-01 12:41:45 | 6876 | 2017-11-01 12:48:24 | 2017-11-01 12:48:26 | 6876 | 2017-11-01 12:42:21 | 2017-11-01 12:45:59 | 4985 | 2017-11-01 12:55:43 | 4985 | 2017-11-01 13:06:27