Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 03252018-03312018

Date | Crew | Truck | Job | Time in | Time left office | Time before departure | Time of arrival to job | Time left job | Time on the job | Time returned to office | Time punched out | Time after | Returned to fix | Time alloted | Called out
2018-03-26 00:00:00 | [NAME] |  | Kids R Kids | 05:40:00 | 07:23:00 |  | 08:48:00 | 14:45:00 |  | 15:16:00 | 15:19:00 |  |  | 4
2018-03-28 00:00:00 | [NAME] |  | Shop | 05:36:00 |  | 00:00:00 |  |  |  |  | 14:10:00 | 00:00:00
2018-03-29 00:00:00 | [NAME] |  | Star [NAME] | 05:37:00 | 06:44:00 |  | 07:37:00 | 10:51:00 |  |  |  |  |  | 4
2018-03-29 00:00:00 | [NAME] |  | [NAME] |  |  |  | 11:20:00 | 12:29:00 |  | 13:03:00 | 13:31:00 |  |  | 2.5
2018-03-30 00:00:00 | [NAME] |  | Shop | 05:47:00 |  |  |  |  |  |  |  | 00:00:00 |  | 1.5
2018-03-31 00:00:00 | [NAME] |  | [NAME] | 08:23:00 | 09:00:00 |  | 09:59:00 | 11:37:00 |  | 13:10:00 | 13:51:00 | 00:00:00 |  | 5
 | Allen Total
2018-03-26 00:00:00 | [NAME] |  | Sadler | 19:25:00 | 19:59:00 |  | 20:08:00 | 21:57:00 |  | 22:12:00 | 22:51:00 |  |  | 20
2018-03-27 00:00:00 | [NAME] |  | Sadler | 12:26:00 | 12:31:00 |  | 12:48:00 | 14:40:00 |  | 14:53:00 | 17:54:00
2018-03-27 00:00:00 | [NAME] |  | Sadler | 19:32:00 | 19:55:00 |  | 20:19:00 | 02:56:00 |  | 03:13:00 | 03:22:00 |  |  | 4
2018-03-28 00:00:00 | [NAME] |  | Sadler | 19:39:00 | 20:09:00 |  | 20:15:00 | 01:19:00 |  | 01:37:00 | 03:29:00
2018-03-29 00:00:00 | [NAME] |  | Liberty Center | 12:47:00 | 12:54:00 |  | 13:09:00 | 13:30:00 |  | 13:40:00 | 14:07:00
2018-03-29 00:00:00 | [NAME] |  | Liberty Center | 19:03:00 | 19:59:00 |  | 20:20:00 | 01:44:00 |  | 02:03:00 | 02:42:00 |  |  | 25
 | [NAME]
2018-03-26 00:00:00 | [NAME] |  | Kids R Kids | 05:53:00 | 07:21:00 |  | 08:48:00 | 13:51:00 |  | 15:02:00 | 16:54:00 |  |  | 4
2018-03-27 00:00:00 | [NAME] |  | Lucaya Ph 2 | 05:57:00 | 06:28:00 |  | 09:09:00 | 11:02:00 |  | 13:22:00 | 16:32:00 |  |  | 8
2018-03-28 00:00:00 | [NAME] |  | Gem Products | 06:00:00 | 06:43:00 |  | 09:22:00 | 15:12:00 |  | 17:16:00 | 17:35:00 |  |  | 3
2018-03-29 00:00:00 | [NAME] |  | P-304 | 05:58:00 | 07:15:00 |  | 08:40:00 | 14:47:00 |  | 15:56:00 | 17:40:00 | 00:00:00 |  | 8
2018-03-30 00:00:00 | [NAME] |  | P-304 | 05:57:00 | 07:40:00 |  | 08:56:00 | 13:46:00 |  | 14:52:00 | 15:11:00 |  |  | 8
 | [NAME]
2018-03-26 00:00:00 | [NAME] |  | [NAME] | 05:55:00 | 06:49:00 |  | 07:57:00 | 14:02:00 |  | 14:30:00 | 14:39:00 |  |  | 8 | 3
2018-03-28 00:00:00 | [NAME] |  | Fish Memorial | 05:54:00 | 07:49:00 |  | 09:10:00 | 16:17:00 |  | 16:44:00 | 16:53:00 |  |  | 6
 | Anthony Total
2018-03-26 00:00:00 | [NAME] |  | Kids R Kids | 07:18:00 | 07:23:00 |  | 08:48:00 | 14:45:00 |  | 15:16:00 | 16:55:00 |  |  | 4
2018-03-27 00:00:00 | [NAME] |  | Shop | 05:59:00 |  | 00:00:00 |  |  |  |  | 17:39:00 | 00:00:00
2018-03-28 00:00:00 | [NAME] |  | Shop | 05:58:00 |  | 00:00:00 |  |  |  |  | 16:07:00 | 00:00:00
2018-03-29 00:00:00 | [NAME] |  | Star [NAME] | 06:00:00 | 06:44:00 |  | 07:37:00 | 10:51:00 |  |  |  |  |  | 4
2018-03-29 00:00:00 | [NAME] |  | [NAME] |  |  |  | 11:20:00 | 12:29:00 |  | 13:03:00 | 15:30:00 | 00:00:00 |  | 2.5
2018-03-30 00:00:00 | [NAME] |  | Shop | 06:04:00 |  |  |  |  |  |  |  |  |  | 1.5
2018-03-31 00:00:00 | [NAME] |  | [NAME] | 08:15:00 | 09:00:00 |  | 09:59:00 | 11:37:00 |  | 13:10:00 | 14:30:00 | 00:00:00 |  | 5
 | [NAME]
2018-03-25 00:00:00 | [NAME] |  | Walmart | 17:06:00 | 17:34:00 |  | 22:02:00 | 08:07:00 |  | 11:57:00 | 12:10:00 |  |  | 27.5
2018-03-27 00:00:00 | [NAME] |  | Walmart | 18:13:00 | 18:47:00 |  | 21:04:00 | 03:30:00 |  | 05:18:00 | 05:22:00
2018-03-28 00:00:00 | [NAME] |  | Walmart | 18:57:00 | 19:35:00 |  | 21:58:00 | 07:09:00 |  | 07:54:00 | 08:16:00
2018-03-29 00:00:00 | [NAME] |  | Walmart | 18:57:00 | 19:20:00 |  | 20:34:00 | 05:49:00 |  | 07:41:00 | 07:52:00
 | Brandon Total
2018-03-26 00:00:00 | Dwayne |  | [NAME] | 05:46:00 | 06:23:00 |  | 09:25:00 | 12:11:00 |  | 12:45:00 | 13:14:00 |  |  | 0.45 | 2
2018-03-28 00:00:00 | Dwayne |  | France BOH | 06:38:00 | 07:05:00 |  | 09:54:00 | 14:47:00 |  | 15:47:00 | 15:58:00 |  |  | 4
2018-03-29 00:00:00 | Dwayne |  | 21 Jersey |  |  |  | 12:23:00 | 14:13:00 |  | 14:56:00 | 15:01:00 |  |  | 2
2018-03-29 00:00:00 | Dwayne |  | [NAME] | 05:42:00 | 06:13:00 |  | 07:10:00 | 12:07:00 |  |  |  |  |  | 5
 | [NAME]
2018-03-26 00:00:00 | Edgar |  | [NAME] | 06:01:00 | 06:23:00 |  | 09:25:00 | 12:11:00 |  | 12:45:00 | 13:16:00 |  |  | 0.45
2018-03-27 00:00:00 | Edgar |  | [NAME] | 05:59:00 | 06:22:00 |  | 07:35:00 | 13:45:00 |  | 14:40:00 | 16:32:00 | 00:00:00 |  | 8
2018-03-28 00:00:00 | Edgar |  | Gem Products | 05:59:00 | 06:43:00 |  | 09:22:00 | 15:12:00 |  | 17:16:00 | 17:31:00 |  |  | 3
2018-03-29 00:00:00 | Edgar |  | P-304 | 06:08:00 | 06:37:00 |  | 08:40:00 | 16:44:00 |  | 18:22:00 | 18:27:00 |  |  | 4
2018-03-30 00:00:00 | Edgar |  | P-304 | 06:00:00 | 07:40:00 |  | 08:56:00 | 13:46:00 |  | 14:52:00 | 15:02:00 |  |  | 8
 | [NAME]
2018-03-25 00:00:00 | Efrain |  | Walmart | 18:15:00 | 20:13:00 |  | 00:41:00 | 08:28:00 |  | 08:43:00 | 10:13:00 |  |  | 44
2018-03-26 00:00:00 | Efrain |  | Walmart | 17:41:00 | 17:40:00 | 00:00:00 | 18:45:00 | 09:19:00 |  | 09:25:00 | 09:36:00
2018-03-27 00:00:00 | Efrain |  | Walmart | 18:03:00 | 18:26:00 |  | 19:09:00 | 11:16:00 |  | 11:20:00 | 07:41:00 | 00:00:00
2018-03-28 00:00:00 | Efrain |  | Walmart | 17:55:00 | 18:18:00 |  | 18:44:00 | 08:06:00 |  | 08:45:00 | 09:03:00
2018-03-29 00:00:00 | Efrain |  | Walmart | 17:42:00 | 17:43:00 |  | 19:27:00 | 06:54:00 |  | 11:08:00 | 11:20:00
 | Efrain Total
2018-03-27 00:00:00 | [NAME] |  | Shop | 05:56:00 |  | 00:00:00 |  |  |  |  | 20:16:00 | 00:00:00 |  | 8
2018-03-28 00:00:00 | [NAME] |  |  | 06:21:00 |  | 00:00:00 |  |  |  |  | 18:12:00 | 00:00:00
2018-03-29 00:00:00 | [NAME] |  | [NAME] | 06:00:00 | 06:58:00 |  | 07:48:00 | 13:36:00 |  | 14:50:00 | 14:10:00 | 00:00:00
2018-03-30 00:00:00 | [NAME] |  | Extreme Toy | 05:36:00 | 07:00:00 |  | 07:47:00 | 08:51:00 |  | 14:47:00 | 14:54:00 |  |  | 2
 | [NAME]
2018-03-27 00:00:00 | Lindsey |  | Lucaya Ph 2 | 05:50:00 | 06:56:00 |  | 09:09:00 | 11:02:00 |  | 13:06:00 | 16:30:00 |  |  | 8
2018-03-28 00:00:00 | Lindsey |  | France BOH | 05:52:00 | 07:05:00 |  | 09:54:00 | 14:47:00 |  | 15:47:00 | 16:02:00 |  |  | 4 | 1
2018-03-29 00:00:00 | Lindsey |  | 21 Jersey |  |  |  | 12:23:00 | 14:13:00 |  | 14:56:00 | 15:05:00 |  |  | 2
2018-03-29 00:00:00 | Lindsey |  | [NAME] | 05:50:00 | 06:13:00 |  | 07:10:00 | 12:07:00 |  |  |  |  |  | 5
2018-03-30 00:00:00 | Lindsey |  | [NAME] | 05:50:00 | 06:58:00 |  | 07:48:00 | 13:36:00 |  | 14:50:00 | 15:02:00 |  |  | 1.5
 | Lindsey Total
2018-03-25 00:00:00 | Logan |  | Walmart | 20:05:00 | 20:43:00 |  | 20:59:00 | 04:55:00 |  | 05:17:00 | 05:21:00 |  |  | 48
2018-03-26 00:00:00 | Logan |  | Walmart | 21:02:00 | 21:16:00 |  | 21:40:00 | 03:24:00 |  | 03:29:00 | 03:33:00
2018-03-27 00:00:00 | Logan |  | Walmart | 19:10:00 | 19:54:00 |  | 10:53:00 | 03:24:00 |  | 05:07:00 | 05:13:00
2018-03-28 00:00:00 | Logan |  | Walmart | 19:19:00 | 20:13:00 |  | 21:02:00 | 10:00:00 |  | 10:05:00 | 11:20:00
2018-03-29 00:00:00 | Logan |  | Walmart | 19:15:00 | 19:34:00 |  | 21:59:00 | 07:06:00 |  | 10:16:00 | 10:35:00
 | Logan Total
2018-03-27 00:00:00 | Nick |  | [NAME] | 05:59:00 | 06:22:00 |  | 07:35:00 | 13:45:00 |  | 14:40:00 | 15:55:00 | 00:00:00 |  | 8
2018-03-28 00:00:00 | Nick |  | Gem Products | 06:04:00 | 06:43:00 |  | 09:22:00 | 15:12:00 |  | 17:16:00 | 17:24:00 |  |  | 3
2018-03-29 00:00:00 | Nick |  | P-304 | 06:02:00 | 06:37:00 |  | 08:40:00 | 16:44:00 |  | 18:22:00 | 18:24:00 |  |  | 4
 | Nick Total
2018-03-26 00:00:00 | [NAME] |  | [NAME] | 06:02:00 | 06:49:00 |  | 07:57:00 | 14:02:00 |  | 14:30:00 | 14:39:00 |  |  | 8
2018-03-27 00:00:00 | [NAME] |  | [NAME] | 06:02:00 | 07:10:00 |  | 07:50:00 | 10:48:00 |  |  |  |  |  | 8
2018-03-27 00:00:00 | [NAME] |  | Creekstone |  |  |  | 12:11:00 | 12:38:00 |  |  |  |  |  | 1
2018-03-27 00:00:00 | [NAME] |  | Oaktree Pointe |  |  |  | 13:56:00 | 16:26:00 |  | 17:44:00 | 17:45:00 |  |  | 3
2018-03-28 00:00:00 | [NAME] |  | Fish Memorial | 06:00:00 | 07:49:00 |  | 09:10:00 | 16:17:00 |  | 16:44:00 | 17:01:00 |  |  | 6
2018-03-29 00:00:00 | [NAME] |  | P-304 | 06:08:00 | 07:15:00 |  | 08:43:00 | 16:42:00 |  | 17:37:00 | 17:40:00 |  |  | 8
2018-03-30 00:00:00 | [NAME] |  | Ridgewood Ph 1 | 06:00:00 | 07:29:00 |  | 08:57:00 | 13:35:00 |  | 14:45:00 | 15:09:00 |  |  | 3
 | [NAME]
2018-03-25 00:00:00 | [NAME] |  | Walmart | 20:05:00 | 20:43:00 |  | 20:59:00 | 04:55:00 |  | 05:17:00 | 05:21:00 |  |  | 48
 | [NAME]
2018-03-25 00:00:00 | [NAME] |  | Walmart | 17:07:00 | 17:34:00 |  | 22:02:00 | 08:07:00 |  | 11:57:00 | 12:10:00 |  |  | 27.5
2018-03-26 00:00:00 | [NAME] |  | Walmart | 21:04:00 | 21:16:00 |  | 21:40:00 | 03:24:00 |  | 03:29:00 | 03:33:00
2018-03-27 00:00:00 | [NAME] |  | Walmart | 18:12:00 | 18:47:00 |  | 21:04:00 | 03:30:00 |  | 05:18:00 | 05:22:00
2018-03-28 00:00:00 | [NAME] |  | Walmart | 18:58:00 | 19:35:00 |  | 21:58:00 | 07:09:00 |  | 07:54:00 | 08:04:00
2018-03-29 00:00:00 | [NAME] |  | Walmart | 18:58:00 | 19:20:00 |  | 20:34:00 | 05:49:00 |  | 07:41:00 | 07:54:00
 | Rocco Total
2018-03-28 00:00:00 | Sergio |  | Shop | 05:43:00 |  | 00:00:00 |  |  |  |  | 15:27:00 | 00:00:00 |  |  | 2
2018-03-29 00:00:00 | Sergio |  | P-304 | 05:58:00 | 07:25:00 |  | 09:48:00 | 14:47:00 |  | 15:56:00 | 16:09:00 |  |  | 8
2018-03-30 00:00:00 | Sergio |  | Orange Ave | 05:56:00 | 08:22:00 |  | 12:54:00 | 13:14:00 |  | 14:52:00 | 16:30:00
2018-03-30 00:00:00 | Sergio |  | Star [NAME] |  |  |  | 09:45:00 | 11:45:00 |  |  |  |  |  | 2
 | Sergio Total
2018-03-25 00:00:00 | [NAME] |  | Walmart | 18:13:00 | 20:13:00 |  | 00:41:00 | 08:28:00 |  | 08:43:00 | 10:14:00 |  |  | 44
2018-03-26 00:00:00 | [NAME] |  | Walmart | 17:40:00 | 17:40:00 |  | 18:45:00 | 09:19:00 |  | 09:25:00 | 09:39:00
2018-03-27 00:00:00 | [NAME] |  | Walmart | 17:52:00 | 18:26:00 |  | 19:09:00 | 11:16:00 |  | 11:20:00 | 07:41:00 | 00:00:00
2018-03-28 00:00:00 | [NAME] |  | Walmart | 18:21:00 | 18:18:00 | 00:00:00 | 18:44:00 | 08:06:00 |  | 08:45:00 | 09:04:00
2018-03-29 00:00:00 | [NAME] |  | Walmart | 17:29:00 | 17:43:00 |  | 19:27:00 | 06:54:00 |  | 11:08:00 | 12:09:00
 | [NAME]
2018-03-25 00:00:00 | [NAME] |  | Walmart | 15:44:00 | 20:13:00 |  | 00:41:00 | 08:28:00 |  | 08:43:00 | 10:13:00 |  |  | 44
2018-03-26 00:00:00 | [NAME] |  | Walmart | 17:42:00 | 17:40:00 | 00:00:00 | 18:45:00 | 09:19:00 |  | 09:25:00 | 09:37:00
2018-03-27 00:00:00 | [NAME] |  | Walmart | 17:49:00 | 18:26:00 |  | 19:09:00 | 11:16:00 |  | 11:20:00 | 07:40:00 | 00:00:00
2018-03-28 00:00:00 | [NAME] |  | Walmart | 17:55:00 | 18:18:00 |  | 18:44:00 | 08:06:00 |  | 08:45:00 | 10:18:00
2018-03-29 00:00:00 | [NAME] |  | Walmart | 17:30:00 | 17:43:00 |  | 19:27:00 | 06:54:00 |  | 11:08:00 | 11:21:00
 | [NAME]
2018-03-28 00:00:00 | TJ |  | Fish Memorial | 06:14:00 | 07:52:00 |  | 09:29:00 | 15:58:00 |  | 17:32:00 | 17:53:00 |  |  | 6
2018-03-29 00:00:00 | TJ |  | P-304 | 06:36:00 | 07:15:00 |  | 08:43:00 | 16:42:00 |  | 17:37:00 | 17:40:00 |  |  | 8
 | TJ Total
2018-03-27 00:00:00 | Willie |  | Lucaya Ph 2 | 05:50:00 | 06:28:00 |  | 09:09:00 | 11:02:00 |  | 13:22:00 | 13:48:00 |  |  | 8 | 1
2018-03-28 00:00:00 | Willie |  | Gem Products | 05:57:00 | 06:43:00 |  | 09:22:00 | 15:12:00 |  | 17:16:00 | 17:16:00 |  |  | 3
2018-03-29 00:00:00 | Willie |  | P-304 | 05:57:00 | 07:15:00 |  | 08:40:00 | 14:47:00 |  | 15:56:00 | 17:38:00 | 00:00:00 |  | 8
2018-03-30 00:00:00 | Willie |  | P-304 | 06:01:00 | 07:40:00 |  | 08:56:00 | 13:46:00 |  | 14:52:00 | 14:29:00 | 00:00:00 |  | 8
 | Willie Total
2018-03-26 00:00:00 | [NAME] |  | [NAME] | 06:00:00 | 07:47:00 |  | 09:14:00 | 13:58:00 |  | 14:35:00 | 14:30:00 | 00:00:00 |  | 2 | 1
2018-03-27 00:00:00 | [NAME] |  | [NAME] | 07:30:00 | 07:28:00 | 00:00:00 | 08:53:00 | 14:38:00 |  | 15:38:00 | 14:30:00 | 00:00:00 |  | 3
2018-03-28 00:00:00 | [NAME] |  | Fish Memorial | 07:30:00 | 07:52:00 |  | 09:29:00 | 15:58:00 |  | 14:30:00 | 14:30:00 |  |  | 6
2018-03-30 00:00:00 | [NAME] |  | Orange Ave | 09:07:00 | 09:07:00 |  | 12:54:00 | 13:14:00 |  | 13:14:00 | 13:14:00
2018-03-30 00:00:00 | [NAME] |  | Star [NAME] |  |  |  | 09:45:00 | 11:45:00 |  |  |  |  |  | 2
 | Willie S Total
 | Grand Total