Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 05272018-06022018

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
05/29/2018 | [NAME] |  | Ashton | 05:42 AM | 06:58:00 |  | 08:29:00 | 10:59:00 |  |  |  |  |  | 4
05/29/2018 | [NAME] |  | Yates |  |  |  | 11:31:00 | 13:15:00 |  | 13:47:00 | 03:27 PM | 0:00:00 |  | 8
05/30/2018 | [NAME] |  | Adventist | 05:47 AM | 07:03:00 |  | 08:17:00 | 12:02:00 |  | 12:46:00 | 12:56 PM |  |  | 4
05/31/2018 | [NAME] |  | Bainbridge |  |  |  | 14:03:00 | 15:00:00 |  | 15:35:00 | 03:38 PM |  |  | 1
05/31/2018 | [NAME] |  | [NAME] | 05:57 AM | 06:24:00 |  | 06:52:00 | 13:35:00 |  |  |  |  |  | 2
06/01/2018 | [NAME] |  | Ashton | 05:42 AM | 06:24:00 |  | 06:54:00 | 07:05:00 |  |  |  |  |  | 2.5
06/01/2018 | [NAME] |  | Bainbridge |  |  |  | 07:12:00 | 07:20:00
06/01/2018 | [NAME] |  | Sandpiper |  |  |  | 10:11:00 | 12:03:00 |  | 12:56:00 | 01:05 PM |  |  | 3
06/01/2018 | [NAME] |  | Innovation |  |  |  | 07:33:00 | 09:09:00
 | Allen Total
05/29/2018 | [NAME] |  | [NAME] | 06:28 AM | 06:43:00 |  | 07:41:00 | 14:49:00 |  | 15:26:00 | 03:47 PM |  |  | 8
05/30/2018 | [NAME] |  | [NAME] | 06:11 AM | 06:16:00 |  | 06:45:00 | 10:14:00 |  | 10:45:00 | 12:19 PM | 0:00:00 |  | 8
05/31/2018 | [NAME] |  | [NAME] | 06:05 AM | 06:30:00 |  | 07:04:00 | 11:40:00 |  | 12:11:00 | 03:10 PM | 0:00:00 |  | 8
06/01/2018 | [NAME] |  | [NAME] | 05:39 AM | 05:31:00 | 0:00:00 | 05:57:00 | 09:07:00 |  | 09:37:00 | 11:06 AM | 0:00:00 |  | 8
 | [NAME]
05/29/2018 | [NAME] |  | Cypress Park | 06:07:00 | 06:57:00 |  | 07:46:00 | 14:33:00 |  | 15:10:00 | 16:13:00 | 0:00:00 |  | 8
05/30/2018 | [NAME] |  | Adventist | 05:57:00 | 06:53:00 |  | 08:43:00 | 12:04:00 |  | 12:52:00 | 14:12:00 | 0:00:00 |  | 4
05/31/2018 | [NAME] |  | Bainbridge |  |  |  | 14:03:00 | 15:00:00 |  | 15:35:00 | 15:40:00 |  |  | 1
05/31/2018 | [NAME] |  | [NAME] | 06:01:00 | 06:24:00 |  | 06:52:00 | 13:35:00 |  |  |  |  |  | 2
06/01/2018 | [NAME] |  | Ashton | 05:59:00 | 06:24:00 |  | 06:54:00 | 07:05:00 |  |  |  |  |  | 2.5
06/01/2018 | [NAME] |  | Bainbridge |  |  |  | 07:12:00 | 07:20:00
06/01/2018 | [NAME] |  | Sandpiper |  |  |  | 10:11:00 | 12:03:00 |  | 12:56:00 | 14:59:00 | 0:00:00 |  | 3
06/01/2018 | [NAME] |  | Innovation |  |  |  | 07:33:00 | 09:09:00 |  |  |  |  |  | 3
 | [NAME]
05/29/2018 | [NAME] |  | Ashton | 06:26 AM | 06:58:00 |  | 08:29:00 | 10:59:00 |  |  | 0 |  |  | 4
05/29/2018 | [NAME] |  | Yates |  |  |  | 11:31:00 | 13:15:00 |  | 13:47:00 | 03:29 PM | 0:00:00 |  | 8
05/30/2018 | [NAME] |  | Adventist | 05:57 AM | 07:03:00 |  | 08:17:00 | 12:02:00 |  | 12:46:00 | 01:06 PM |  |  | 4
 | Benjamin Total
05/28/2018 | [NAME] |  | Walmart | 06:09 PM | 20:04:00 |  | 00:32:00 | 07:11:00 |  | 07:41:00 | 08:10 AM
05/29/2018 | [NAME] |  | Walmart | 04:58 PM | 17:15:00 |  | 17:57:00 | 05:39:00 |  | 06:01:00 | 06:07 AM
05/30/2018 | [NAME] |  | Walmart 2 | 05:00 PM | 17:02:00 |  | 17:37:00 | 07:18:00 |  | 07:51:00 | 08:01 AM |  |  | 72
05/31/2018 | [NAME] |  | walmart | 05:06 PM | 17:12:00 |  | 17:42:00 | 20:04:00 |  | 22:54:00 | 11:03 PM
 | Brandon Total
05/29/2018 | Dwayne |  | [NAME] | 05:43 AM | 06:27:00 |  | 07:19:00 | 10:43:00 |  |  |  |  |  | 2.5
05/29/2018 | Dwayne |  | Longwood Septic |  |  |  | 11:46:00 | 15:33:00 |  | 15:58:00 | 04:13 PM |  |  | 4 | 1
05/30/2018 | Dwayne |  | Vernazza | 05:41 AM | 06:58:00 |  | 08:31:00 | 11:22:00 |  | 12:23:00 | 12:45 PM |  | 2 | 4
05/31/2018 | Dwayne |  | Vernazza | 05:32 AM | 06:11:00 |  | 07:37:00 | 10:38:00 |  |  |  |  |  | 4
05/31/2018 | Dwayne |  | 7 Eleven |  |  |  | 11:37:00 | 12:11:00 |  | 13:12:00 | 01:27 PM |  |  | 2
 | [NAME]
05/29/2018 | Edgar |  | Cypress Park | 05:57 AM | 06:57:00 |  | 07:46:00 | 14:33:00 |  | 15:10:00 | 03:31 PM |  |  | 8
05/29/2018 | Edgar |  | [NAME] | 05:58 PM | 18:24:00 |  | 19:10:00 | 04:28:00 |  | 04:53:00 | 04:59 AM |  |  | 8
05/30/2018 | Edgar |  | [NAME] | 05:42 PM | 18:04:00 |  | 18:49:00 | 04:57:00 |  | 05:32:00 | 05:48 AM |  |  | 8
05/31/2018 | Edgar |  | [NAME] | 05:35 PM | 17:41:00 |  | 18:33:00 | 20:06:00 |  | 20:28:00 | 08:31 PM |  |  | 8
06/01/2018 | Edgar |  | Cypress Park | 06:03 AM | 06:16:00 |  | 7:16:00 | 12:28:00 |  | 13:26:00 | 01:55 PM |  |  | 5
 | [NAME]
05/28/2018 | Efrain |  | Walmart | 09:47 PM | 20:08:00 | 0:00:00 | 22:53:00 | 03:38:00 |  | 04:46:00 | 04:17 AM | 0:00:00
05/30/2018 | Efrain |  | Walmart | 07:45 PM | 18:27:00 | 0:00:00 | 19:21:00 | 06:37:00 |  | 07:10:00 | 04:44 AM | 0:00:00 |  | 48
05/31/2018 | Efrain |  | walmart | 07:19 PM | 18:22:00 | 0:00:00 | 20:32:00 | 23:49:00 |  | 01:07:00 | 12:36 AM | 0:00:00
 | Efrain Total
05/29/2018 | [NAME] |  | [NAME] | 06:16 AM | 06:43:00 |  | 07:41:00 | 14:49:00 |  | 15:26:00 | 03:38 PM |  |  | 8
05/30/2018 | [NAME] |  | [NAME] | 05:51 AM | 06:16:00 |  | 06:45:00 | 10:14:00 |  | 10:45:00 | 11:05 AM |  |  | 8
05/31/2018 | [NAME] |  | [NAME] | 06:14 AM | 06:30:00 |  | 07:04:00 | 19:09:00 |  | 19:36:00 | 0 | 0:00:00 |  | 8
06/01/2018 | [NAME] |  | [NAME] | 05:22 AM | 05:31:00 |  | 05:57:00 | 09:07:00 |  | 09:37:00 | 09:44 AM |  |  | 8
 | [NAME]
05/29/2018 | [NAME] |  | [NAME] | 06:22 AM | 06:27:00 |  | 07:19:00 | 10:43:00 |  |  |  |  |  | 2.5
05/29/2018 | [NAME] |  | Longwood Septic |  |  |  | 11:46:00 | 15:33:00 |  | 15:58:00 | 04:10 PM | 0:00:00 |  | 4 | 1
05/30/2018 | [NAME] |  | Vernazza | 05:55 AM | 06:58:00 |  | 08:31:00 | 11:22:00 |  | 12:23:00 | 12:45 PM |  |  | 4
05/30/2018 | [NAME] |  | Shop | 07:00 PM |  |  |  |  |  |  | 10:30 PM | 0:00:00
06/01/2018 | [NAME] |  | Ashton | 05:59:00 | 06:24:00 |  | 06:54:00 | 07:05:00 |  |  |  |  |  | 2.5
06/01/2018 | [NAME] |  | Bainbridge |  |  |  | 07:12:00 | 07:20:00 |  |  |  |  |  | 3
06/01/2018 | [NAME] |  | Sandpiper |  |  |  | 10:11:00 | 12:03:00 |  | 12:56:00 | 14:59:00 | 0:00:00
 | [NAME]
05/28/2018 | [NAME] |  | Walmart | 06:05 PM | 20:04:00 |  | 00:32:00 | 07:11:00 |  | 07:41:00 | 08:10 AM
05/29/2018 | [NAME] |  | Walmart 2 | 04:57 PM | 17:15:00 |  | 17:57:00 | 05:39:00 |  | 06:01:00 | 06:07 AM |  |  | 72
05/30/2018 | [NAME] |  | Walmart | 04:58 PM | 17:02:00 |  | 17:37:00 | 07:18:00 |  | 07:51:00 | 07:58 AM
05/31/2018 | [NAME] |  | walmart | 05:05 PM | 17:12:00 |  | 17:42:00 | 20:04:00 |  | 22:54:00 | 11:02 PM
 | Kenneth Total
05/28/2018 | Logan |  | Walmart | 05:58 PM | 20:08:00 |  | 22:53:00 | 03:38:00 |  | 04:46:00 | 05:07 AM
05/29/2018 | Logan |  | Walmart | 06:12 PM | 18:27:00 |  | 19:21:00 | 06:37:00 |  | 07:10:00 | 07:29 AM |  |  | 48
05/30/2018 | Logan |  | Walmart | 06:33 PM | 19:02:00 |  | 21:19:00 | 04:01:00 |  | 05:17:00 | 05:24 AM
05/31/2018 | Logan |  | walmart | 06:19 PM | 18:22:00 | 0:00:00 | 20:32:00 | 23:49:00 |  | 01:07:00 | 01:26 AM
 | Logan Total
05/29/2018 | Nick |  | [NAME] | 17:49:00 | 18:24:00 |  | 19:10:00 | 04:28:00 |  | 04:53:00 | 04:57:00
05/30/2018 | Nick |  | [NAME] | 17:38:00 | 18:04:00 |  | 18:49:00 | 04:57:00 |  | 05:32:00 | 05:45:00
05/31/2018 | Nick |  | [NAME] | 17:01:00 | 17:41:00 |  | 18:33:00 | 20:06:00 |  | 20:28:00 | 20:33:00 |  |  | 8
06/01/2018 | Nick |  | Cypress Park | 05:59:00 | 06:16:00 |  | 7:16:00 | 12:28:00 |  | 13:26:00 | 13:59:00 |  |  | 5
 | Nick Total
05/29/2018 | [NAME] |  | Ashton | 05:55 AM | 06:58:00 |  | 08:29:00 | 10:59:00 |  |  |  |  |  | 8
05/29/2018 | [NAME] |  | Yates |  |  |  | 11:31:00 | 13:15:00 |  | 13:47:00 | 02:14 PM
05/30/2018 | [NAME] |  | Racetrac | 06:00 AM | 06:26:00 |  | 10:17:00 | 10:53:00 |  | 11:35:00 | 02:12 PM | 0:00:00 |  | 1
05/31/2018 | [NAME] |  | Cypress Park | 06:01 AM | 06:16:00 |  | 07:09:00 | 11:18:00 |  | 12:04:00 | 02:22 PM | 0:00:00 |  | 5
06/01/2018 | [NAME] |  | Cypress Park | 05:56 AM | 06:16:00 |  | 7:16:00 | 12:28:00 |  | 13:26:00 | 01:53 PM |  |  | 4
 | Patrick Total
05/28/2018 | [NAME] |  | Walmart | 06:05 PM | 20:04:00 |  | 00:32:00 | 07:11:00 |  | 07:41:00 | 08:10 AM
05/29/2018 | [NAME] |  | Walmart 2 | 04:57 PM | 17:15:00 |  | 17:57:00 | 05:39:00 |  | 06:01:00 | 06:07 AM |  |  | 72
05/30/2018 | [NAME] |  | walmart | 04:58 PM | 17:02:00 |  | 17:37:00 | 07:18:00 |  | 07:51:00 | 07:58 AM
05/31/2018 | [NAME] |  | walmart | 05:05 PM | 17:12:00 |  | 17:42:00 | 20:04:00 |  | 22:54:00 | 11:02 PM
 | Rocco Total
2018-05-27 00:00:00 | [NAME] |  | Walmart | 05:28 PM | 18:27:00 |  | 22:37:00 | 09:20:00 |  | 09:48:00 | 09:48 AM |  |  | 72
05/28/2018 | [NAME] |  | Walmart 2 | 06:57 PM | 19:08:00 |  | 19:35:00 | 08:23:00 |  | 08:51:00 | 08:57 AM
05/29/2018 | [NAME] |  | walmart | 05:40 PM | 17:56:00 |  | 18:27:00 | 06:05:00 |  | 06:32:00 | 06:30 AM | 0:00:00
05/30/2018 | [NAME] |  | walmart | 03:37 PM | 15:59:00 |  | 17:10:00 | 07:24:00 |  | 07:50:00 | 07:50 AM
05/31/2018 | [NAME] |  | walmart | 03:54 PM | 16:11:00 |  | 17:06:00 | 06:58:00 |  | 07:21:00 | 07:52 AM
06/01/2018 | [NAME] |  | Walmart | 10:57 AM | 11:03:00 |  | 11:35:00 | 12:44:00 |  | 12:46:00 | 12:50 PM
06/01/2018 | [NAME] |  | Walmart | 05:31 PM | 17:41:00 |  | 18:18:00 | 06:57:00 |  | 07:21:00 | 08:26:00
2018-06-02 00:00:00 | [NAME] |  | walmart | 17:53:00 | 18:17:00 |  | 19:11:00 | 06:36:00 |  | 07:24:00 | 09:57:00
 | [NAME]
05/30/2018 | Terrance |  | Racetrac | 06:07 AM | 06:26:00 |  | 10:17:00 | 10:53:00 |  | 11:35:00 | 01:06 PM | 0:00:00 |  | 1
05/31/2018 | Terrance |  | Sandpiper | 06:03 AM | 06:36:00 |  | 10:07:00 | 15:41:00 |  | 16:09:00 | 04:12 PM |  |  | 2
06/01/2018 | Terrance |  | Cypress Park | 05:57 AM | 06:16:00 |  | 7:16:00 | 12:28:00 |  | 13:26:00 | 03:00 PM | 0:00:00 |  | 4
 | Terrance Total
05/27/2018 | [NAME] |  | Walmart | 05:28 PM | 18:27:00 |  | 22:37:00 | 09:20:00 |  | 09:48:00 | 09:48 AM |  |  | 72
05/28/2018 | [NAME] |  | Walmart 2 | 06:57 PM | 19:08:00 |  | 19:35:00 | 08:23:00 |  | 08:51:00 | 08:51 AM
05/29/2018 | [NAME] |  | walmart | 05:40 PM | 17:56:00 |  | 18:27:00 | 06:05:00 |  | 06:32:00 | 06:30 AM | 0:00:00
05/30/2018 | [NAME] |  | walmart | 03:37 PM | 15:59:00 |  | 17:10:00 | 07:24:00 |  | 07:50:00 | 07:50 AM
05/31/2018 | [NAME] |  | Walmart | 03:54 PM | 16:11:00 |  | 17:06:00 | 06:58:00 |  | 07:21:00 | 07:52 AM
06/01/2018 | [NAME] |  | walmart | 10:57 AM | 11:03:00 |  | 11:35:00 | 12:44:00 |  | 12:46:00 | 12:50 PM
06/01/2018 | [NAME] |  | walmart | 05:31 PM | 17:41:00 |  | 18:18:00 | 06:57:00 |  | 07:21:00 | 08:24:00
2018-06-02 00:00:00 | [NAME] |  | Walmart | 17:53:00 | 18:17:00 |  | 19:11:00 | 06:36:00 |  | 07:24:00 | 09:57:00
 | [NAME]
05/29/2018 | Willie |  | Cypress Park | 05:53 AM | 06:57:00 |  | 07:46:00 | 14:33:00 |  | 15:10:00 | 03:17 PM |  |  | 8
05/30/2018 | Willie |  | Adventist | 05:54 AM | 07:03:00 |  | 08:17:00 | 12:02:00 |  | 12:46:00 | 01:00 PM |  |  | 4
05/31/2018 | Willie |  | Vernazza | 06:02 AM | 06:11:00 |  | 07:37:00 | 10:38:00 |  |  |  |  |  | 4
05/31/2018 | Willie |  | 7 Eleven |  |  |  | 11:37:00 | 12:11:00 |  | 13:12:00 | 01:20 PM |  |  | 2
 | Willie Total
05/29/2018 | Zachary |  | Ashton | 05:56 AM | 06:58:00 |  | 08:29:00 | 10:59:00
05/29/2018 | Zachary |  | Yates |  |  |  | 11:31:00 | 13:15:00 |  | 13:47:00 | 03:22 PM
05/30/2018 | Zachary |  | Adventist | 05:55 AM | 06:53:00 |  | 08:43:00 | 12:04:00 |  | 12:52:00 | 01:12 PM |  |  | 4
05/31/2018 | Zachary |  | [NAME] | 05:05 PM | 17:41:00 |  | 18:33:00 | 20:06:00 |  | 20:28:00 | 08:30 PM |  |  | 2
06/01/2018 | Zachary |  | Cypress Park | 05:55 AM | 06:16:00 |  | 7:16:00 | 12:28:00 |  | 13:26:00 | 01:41 PM |  |  | 5
 | Zachary Total
 | Grand Total