Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 06172018-06232018

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
06/18/2018 | [NAME] |  | Cypress | 05:42 AM | 06:26:00 |  | 07:21:00 | 13:23:00 |  |  |  |  |  | 5
06/18/2018 | [NAME] |  | Dover |  |  |  | 14:08:00 | 15:15:00 |  | 15:47:00 | 03:47 PM |  |  | 2
06/19/2018 | [NAME] |  | Hyatt | 05:42 AM | 06:33:00 |  | 07:48:00 | 10:22:00 |  |  |  |  |  | 6
06/19/2018 | [NAME] |  | Cypress |  |  |  | 10:51:00 | 15:36:00 |  | 16:31:00 | 04:32 PM |  |  | 3
06/20/2018 | [NAME] |  | East Tract 8 | 05:28 AM | 06:34:00 |  | 07:12:00 | 07:42:00 |  |  |  |  |  | 2.5
06/20/2018 | [NAME] |  | Old Audubon |  |  |  | 08:02:00 | 12:25:00 |  |  |  |  |  | 4
06/20/2018 | [NAME] |  | Innovation |  |  |  | 13:17:00 | 13:44:00 |  | 14:14:00 | 02:30 PM |  |  | 2
06/21/2018 | [NAME] |  | Innovation | 05:34 AM | 07:16:00 |  | 08:43:00 | 12:22:00 |  | 13:08:00 | 01:11 PM |  |  | 8
06/22/2018 | [NAME] |  | ASR | 05:33 AM |  | 0:00:00 |  |  |  |  |  |  |  | 3
06/22/2018 | [NAME] |  | Old Audubon |  |  |  |  |  |  |  | 03:07 PM | 0:00:00 |  | 4
 | Allen Total
06/18/2018 | [NAME] |  | [NAME] | 03:19 AM | 03:35:00 |  | 09:17:00 | 15:46:00 |  | 16:18:00 | 04:33 PM
06/19/2018 | [NAME] |  | [NAME] | 07:06 AM | 07:07:00 |  | 07:52:00 | 14:36:00 |  | 15:01:00 | 06:23 PM
06/20/2018 | [NAME] |  | Gander | 03:30 AM | 03:44:00 | 0:00:00 | 05:52:00 | 15:47:00 |  | 16:55:00 | 05:05 PM |  |  | 8
06/21/2018 | [NAME] |  | Gander | 06:26 AM | 06:45:00 |  | 06:54:00 | 11:58:00 |  | 00:11:00 | 12:45 AM |  |  | 8
06/22/2018 | [NAME] |  | Gander | 06:43 AM | 07:00:00 |  | 07:06:00 | 12:32:00 |  | 20:55:00 | 09:11 PM |  |  | 8
 | [NAME]
06/18/2018 | [NAME] |  | Hyatt | 06:00:00 |  |  |  |  |  |  |  |  |  | 3
06/18/2018 | [NAME] |  | Village F |  |  |  |  |  |  |  | 16:45:00 | 0:00:00 |  | 7
06/19/2018 | [NAME] |  | Hyatt | 06:02:00 | 06:33:00 |  | 07:48:00 | 10:22:00 |  |  |  |  |  | 6
06/19/2018 | [NAME] |  | Cypress |  |  |  | 08:08:00 | 15:29:00 |  | 16:31:00 | 17:17:00 |  |  | 3
06/20/2018 | [NAME] |  | Innovation | 06:07:00 |  | 0:00:00 |  |  |  |  | 18:11:00 | 0:00:00 |  | 8
06/21/2018 | [NAME] |  | Innovation | 05:57:00 |  | 0:00:00 |  |  |  |  | 15:10:00 | 0:00:00 |  | 5
06/22/2018 | [NAME] |  |  | 06:02:00 |  | 0:00:00 |  |  |  |  | 16:30:00 | 0:00:00
 | [NAME]
2018-06-23 00:00:00 | [NAME] |  | Innovation | 07:30:00 | 08:39:00 |  | 09:59:00 | 13:58:00 |  | 14:29:00 | 14:30:00 |  |  | 4
06/18/2018 | [NAME] |  | Cypress | 06:09 AM | 07:07:00 |  | 08:13:00 | 11:02:00 |  |  |  |  |  | 3
06/18/2018 | [NAME] |  | [NAME] |  |  |  | 11:37:00 | 16:03:00 |  | 16:30:00 | 05:33 PM |  |  | 5
06/19/2018 | [NAME] |  | Hyatt | 06:03 AM | 06:36:00 |  | 07:43:00 | 10:45:00 |  |  |  |  |  | 3
06/19/2018 | [NAME] |  | Village F |  |  |  | 12:02:00 | 15:47:00 |  | 16:22:00 | 05:14 PM |  |  | 3
06/20/2018 | [NAME] |  | Old Audubon | 06:00 AM | 07:43:00 |  | 08:42:00 | 17:23:00 |  | 18:07:00 | 06:17 PM |  |  | 8
06/21/2018 | [NAME] |  | Mayport | 06:02 AM | 06:44:00 |  | 10:14:00 | 10:44:00 |  | 14:07:00 | 03:25 PM |  |  | 6
06/22/2018 | [NAME] |  | Innovation | 06:00:00 | 06:40:00 |  | 07:57:00 | 13:28:00 |  | 14:34:00 | 03:19 PM |  |  | 3
 | Benjamin Total
06/17/2018 | [NAME] |  | Walmart | 04:35 PM | 17:34:00 |  | 17:52:00 | 08:48:00 |  | 10:01:00 | 10:24 AM |  |  | 48
06/18/2018 | [NAME] |  | Walmart | 05:10 PM | 18:00:00 |  | 18:49:00 | 07:04:00 |  | 07:32:00 | 08:06 AM
06/19/2018 | [NAME] |  | Walmart | 05:53 PM | 18:12:00 |  | 18:42:00 | 02:52:00 |  | 05:30:00 | 05:47 AM
06/20/2018 | [NAME] |  | Walmart | 09:14 PM | 21:33:00 |  | 22:16:00 | 03:58:00 |  | 04:24:00 | 04:37 AM
06/21/2018 | [NAME] |  | Walmart | 04:51 PM | 18:55:00 |  | 21:21:00 | 02:46:00 |  | 03:08:00 | 03:15 AM
 | [NAME]
06/17/2018 | [NAME] |  | Walmart | 05:38 PM | 18:00:00 |  | 22:23:00 | 06:49:00 |  | 07:13:00 | 07:28 AM |  |  | 56
06/18/2018 | [NAME] |  | Walmart | 05:01 PM | 17:22:00 |  | 18:36:00 | 06:45:00 |  | 06:58:00 | 07:06 AM
06/19/2018 | [NAME] |  | Walmart | 05:01 PM | 17:06:00 |  | 17:27:00 | 06:42:00 |  | 06:57:00 | 07:04 AM
06/20/2018 | [NAME] |  | Walmart | 05:08 PM | 17:14:00 |  | 17:50:00 | 06:36:00 |  | 06:54:00 | 06:59 AM
06/21/2018 | [NAME] |  | Walmart | 05:04 PM | 17:08:00 |  | 17:30:00 | 04:08:00 |  | 07:39:00 | 08:21 AM
 | Brandon Total
06/18/2018 | Dwayne |  | Cypress | 05:42 AM | 06:26:00 |  | 07:21:00 | 13:23:00 |  |  |  |  |  | 5
06/18/2018 | Dwayne |  | Dover |  |  |  | 14:08:00 | 15:15:00 |  | 15:47:00 | 03:50 PM |  |  | 2
06/19/2018 | Dwayne |  | Hyatt | 05:48 AM | 06:33:00 |  | 07:48:00 | 10:22:00 |  |  |  |  |  | 6
06/19/2018 | Dwayne |  | Cypress |  |  |  | 10:51:00 | 15:36:00 |  | 16:31:00 | 04:38 PM |  |  | 3
06/20/2018 | Dwayne |  | East Tract 8 | 05:36 AM | 06:34:00 |  | 07:12:00 | 07:42:00 |  |  |  |  |  | 2.5
06/20/2018 | Dwayne |  | Old Audubon |  |  |  | 08:02:00 | 12:25:00 |  |  |  |  |  | 4 | 2
06/20/2018 | Dwayne |  | Innovation |  |  |  | 13:17:00 | 13:44:00 |  | 14:14:00 | 03:10 PM
 | [NAME]
06/18/2018 | Edgar |  | Dollar General Mims | 06:05 AM |  |  | 13:17:00 | 13:44:00 |  | 14:14:00 |  |  |  | 5
06/18/2018 | Edgar |  | Cypress |  |  |  | 11:22:00 | 13:07:00 |  |  |  |  |  | 2
06/18/2018 | Edgar |  | Dover |  |  |  | 13:31:00 | 15:16:00 |  | 15:52:00 | 04:08 PM |  |  | 2
06/19/2018 | Edgar |  | Oak Trail | 05:59 AM | 06:22:00 |  | 07:28:00 | 09:34:00 |  |  |  |  |  | 6
06/19/2018 | Edgar |  | Dover |  |  |  | 11:56:00 | 13:51:00 |  | 14:32:00 | 02:41 PM |  |  | 2
06/20/2018 | Edgar |  | Long Bay | 05:59 AM | 06:30:00 |  | 08:18:00 | 15:28:00 |  | 17:59:00 | 06:03 PM |  |  | 8
06/21/2018 | Edgar |  | Long Bay | 06:01 AM | 06:23:00 |  | 09:11:00 | 16:47:00 |  | 18:57:00 | 07:01 PM |  |  | 8
06/22/2018 | Edgar |  | Long Bay | 05:58 AM | 06:31:00 |  | 09:52:00 | 14:49:00 |  | 16:44:00 | 04:48 PM |  |  | 8
 | [NAME] |  |  |  |  |  |  |  |  |  |  | 0:00:00
06/17/2018 | Efrain |  | Walmart | 07:20 PM | 17:58:00 | 0:00:00 | 20:36:00 | 04:08:00 |  | 05:51:00 | 05:24 AM | 0:00:00
06/18/2018 | Efrain |  | Walmart | 07:52 PM | 19:09:00 | 0:00:00 | 20:03:00 | 03:29:00 |  | 05:10:00 | 04:41 AM | 0:00:00 |  | 56
06/20/2018 | Efrain |  | Walmart | 08:38 PM | 19:06:00 | 0:00:00 | 12:24:00 | 04:52:00 |  | 05:52:00 | 04:09 AM | 0:00:00
 | Efrain Total
06/18/2018 | [NAME] |  | Shop | 06:00 AM |  | 0:00:00 |  |  |  |  | 05:00 PM
06/19/2018 | [NAME] |  | Shop | 05:55 AM |  | 0:00:00 |  |  |  |  | 06:00 PM | 0:00:00
06/20/2018 | [NAME] |  | Gander | 06:00 AM | 03:44:00 | 0:00:00 | 05:52:00 | 15:47:00 |  | 16:55:00 | 05:00 PM |  |  | 8
06/21/2018 | [NAME] |  | Gander | 06:00 AM | 06:45:00 |  | 06:54:00 | 11:58:00 |  | 12:11:00 | 05:00 PM | 0:00:00 |  | 8
06/22/2018 | [NAME] |  | Gander | 06:00 AM | 07:00:00 |  | 07:06:00 | 12:32:00 |  | 20:55:00 | 09:14 PM |  |  | 8
 | [NAME]
2018-06-23 00:00:00 | [NAME] |  | Innovation | 08:00:00 | 08:39:00 |  | 09:59:00 | 13:58:00 |  | 14:29:00 | 14:30:00 |  |  | 4
06/19/2018 | [NAME] |  | Hyatt | 05:42 AM | 06:36:00 |  | 07:43:00 | 10:45:00 |  |  |  |  |  | 3
06/19/2018 | [NAME] |  | Village F |  |  |  | 12:02:00 | 15:47:00 |  | 16:22:00 | 05:12 PM |  |  | 3
06/20/2018 | [NAME] |  | Old Audubon | 07:00 AM | 07:43:00 |  | 08:42:00 | 17:23:00 |  | 18:07:00 | 06:17 PM |  |  | 4
06/21/2018 | [NAME] |  | Mayport | 06:40 AM | 06:44:00 |  | 10:14:00 | 10:44:00 |  | 14:07:00 | 03:25 PM |  |  | 6
06/22/2018 | [NAME] |  | Innovation | 06:04 AM | 06:40:00 |  | 07:57:00 | 13:28:00 |  | 14:34:00 | 03:20 PM |  |  | 3
 | [NAME]
06/17/2018 | Logan |  | Walmart | 05:37 PM | 17:58:00 |  | 20:36:00 | 04:08:00 |  | 05:51:00 | 05:55 AM
06/18/2018 | Logan |  | Walmart | 07:04 PM | 19:09:00 |  | 20:03:00 | 03:29:00 |  | 05:10:00 | 05:12 AM |  |  | 56
06/19/2018 | Logan |  | Walmart | 06:56 PM | 19:06:00 |  | 12:24:00 | 04:52:00 |  | 05:52:00 | 05:55 AM
 | Logan Total
06/18/2018 | Nick |  | Dollar General Mims | 05:52 AM | 06:49:00 |  | 07:47:00 | 10:21:00 |  |  |  |  |  | 5
06/18/2018 | Nick |  | Cypress |  |  |  | 11:22:00 | 13:07:00 |  |  |  |  |  | 2
06/18/2018 | Nick |  | Dover |  |  |  | 13:31:00 | 15:16:00 |  | 15:52:00 | 16:06:00 |  |  | 2
06/19/2018 | Nick |  | Oak Trail | 06:02:00 | 06:22:00 |  | 07:28:00 | 09:34:00 |  |  |  |  |  | 6
06/19/2018 | Nick |  | Dover |  |  |  | 11:56:00 | 13:51:00 |  | 14:32:00 | 14:42:00 |  |  | 2
06/20/2018 | Nick |  | Long Bay | 06:00:00 | 06:30:00 |  | 08:18:00 | 15:28:00 |  | 17:59:00 | 18:02:00 |  |  | 8
06/21/2018 | Nick |  | Long Bay | 05:55:00 | 06:23:00 |  | 09:11:00 | 16:47:00 |  | 18:57:00 | 19:00:00 |  |  | 8
06/22/2018 | Nick |  | Long Bay | 06:01:00 | 06:31:00 |  | 09:52:00 | 14:49:00 |  | 16:44:00 | 16:51:00 |  |  | 8
 | Nick Total
06/18/2018 | [NAME] |  | Hyatt | 06:03 AM | 07:18:00 |  | 09:21:00 | 12:37:00 |  | 16:13:00 | 04:48 PM |  |  | 3
06/19/2018 | [NAME] |  | Cypress | 06:01 AM | 06:53:00 |  | 08:08:00 | 15:29:00 |  | 16:01:00 | 04:35 PM |  |  | 3
06/21/2018 | [NAME] |  | Village F | 06:01 AM | 06:51:00 |  | 09:27:00 | 13:27:00 |  | 14:10:00 | 03:02 PM |  |  | 4 | 1
06/22/2018 | [NAME] |  | Cypress | 06:01 AM | 06:30:00 |  | 07:20:00 | 13:51:00 |  | 14:23:00 | 15:13:00 |  |  | 3
06/22/2018 | [NAME] |  | ASR |  |  |  |  |  |  |  | 04:30 PM | 0:00:00 |  | 5
 | Patrick Total
06/17/2018 | [NAME] |  | Walmart | 05:39 PM | 18:00:00 |  | 22:23:00 | 06:49:00 |  | 07:13:00 | 07:28 AM
06/18/2018 | [NAME] |  | Walmart | 05:00 PM | 17:22:00 |  | 18:36:00 | 06:45:00 |  | 06:58:00 | 07:06 AM |  |  | 56
06/19/2018 | [NAME] |  | Walmart | 05:01 PM | 17:06:00 |  | 17:27:00 | 06:42:00 |  | 06:57:00 | 07:03 AM
06/20/2018 | [NAME] |  | Walmart | 05:08 PM | 17:14:00 |  | 17:50:00 | 06:36:00 |  | 06:54:00 | 06:58 AM
06/21/2018 | [NAME] |  | Walmart | 05:03 PM | 17:08:00 |  | 17:30:00 | 04:08:00 |  | 07:39:00 | 08:19 AM
 | Rocco Total
06/18/2018 | [NAME] |  | Hyatt | 06:03 AM | 07:18:00 |  | 09:21:00 | 12:37:00 |  | 16:13:00 | 15:18:00 | 0:00:00 |  | 3
06/18/2018 | [NAME] |  | Cypress | 06:01 AM | 06:53:00 |  | 08:08:00 | 15:29:00 |  | 16:01:00 | 04:31 PM |  |  | 7
06/19/2018 | [NAME] |  | Village F | 06:01 AM | 06:51:00 |  | 09:27:00 | 13:27:00 |  | 14:10:00 | 02:43 PM |  |  | 8
06/20/2018 | [NAME] |  | Cypress | 06:01 AM | 08:08:00 |  | 09:36:00 | 14:29:00 |  | 15:07:00 | 03:25 PM |  |  | 8
06/21/2018 | [NAME] |  | Village F | 05:59 AM | 06:51:00 |  | 09:27:00 | 13:27:00 |  | 14:10:00 | 02:19 PM |  |  | 4
06/22/2018 | [NAME] |  | Innovation | 06:00 AM |  | 0:00:00 |  |  |  |  |  |  |  | 1
06/22/2018 | [NAME] |  | Old Audubon |  |  |  |  |  |  |  | 02:41 PM | 0:00:00 |  | 6
 | Ryan Total
06/17/2018 | [NAME] |  | Walmart | 04:34 PM | 17:34:00 |  | 17:52:00 | 08:48:00 |  | 10:01:00 | 10:24 AM
06/18/2018 | [NAME] |  | Walmart | 05:10 PM | 18:00:00 |  | 18:49:00 | 07:04:00 |  | 07:32:00 | 08:08 AM
06/19/2018 | [NAME] |  | Walmart | 05:53 PM | 18:12:00 |  | 18:42:00 | 02:52:00 |  | 05:30:00 | 05:46 AM |  |  | 48
06/20/2018 | [NAME] |  | Walmart | 09:14 PM | 21:33:00 |  | 22:16:00 | 03:58:00 |  | 04:24:00 | 04:37 AM
06/21/2018 | [NAME] |  | Walmart | 04:51 PM | 18:55:00 |  | 21:21:00 | 02:46:00 |  | 03:08:00 | 03:15 AM
 | [NAME]
06/18/2018 | Terrance |  | Cypress | 06:20 AM | 08:08:00 |  | 09:36:00 | 14:29:00 |  | 15:07:00 | 03:30 PM |  |  | 8
06/19/2018 | Terrance |  | Cypress | 06:12 AM | 06:53:00 |  | 08:08:00 | 15:29:00 |  | 16:01:00 | 05:16 PM | 0:00:00 |  | 3
06/20/2018 | Terrance |  | Old Audubon | 06:14 AM |  | 0:00:00 |  |  |  |  | 06:00 PM | 0:00:00 |  | 8
06/21/2018 | Terrance |  | Innovation | 06:01 AM | 07:16:00 |  | 08:43:00 | 12:22:00 |  | 13:08:00 | 12:30 PM | 0:00:00 |  | 5
06/22/2018 | Terrance |  | Innovation | 06:19 AM |  | 0:00:00 |  |  |  |  |  |  |  | 1
06/22/2018 | Terrance |  | Old Audubon |  |  |  |  |  |  |  | 03:20 PM | 0:00:00 |  | 6
 | Terrance Total
06/17/2018 | [NAME] |  | Walmart | 04:31 PM | 17:34:00 |  | 17:52:00 | 08:48:00 |  | 10:01:00 | 10:24 AM
06/18/2018 | [NAME] |  | Walmart | 05:05 PM | 18:00:00 |  | 18:49:00 | 07:04:00 |  | 07:32:00 | 07:32 AM
06/19/2018 | [NAME] |  | Walmart | 04:53 PM | 18:12:00 |  | 18:42:00 | 02:52:00 |  | 05:30:00 | 05:39 AM |  |  | 48
06/20/2018 | [NAME] |  | Walmart | 08:39 PM | 21:33:00 |  | 22:16:00 | 03:58:00 |  | 04:24:00 | 04:34 AM
 | [NAME]
06/19/2018 | Willie |  | Cypress | 06:01 AM | 06:53:00 |  | 08:08:00 | 15:29:00 |  | 16:01:00 | 04:40 PM |  |  | 3
06/20/2018 | Willie |  |  | 06:05 AM | 06:33:00 |  | 07:48:00 | 10:22:00 |  |  | 05:30 PM | 0:00:00
06/21/2018 | Willie |  | Innovation | 05:59 AM |  | 0:00:00 |  |  |  |  | 01:10 PM | 0:00:00 |  | 8
06/22/2018 | Willie |  |  | 06:00 AM |  | 0:00:00 |  |  |  |  | 03:35 PM | 0:00:00
 | Willie Total
06/19/2018 | [NAME] |  | Hyatt | 06:00 AM | 07:23:00 |  | 09:20:00 | 13:00:00 |  | 13:38:00 | 02:30 PM |  |  | 3 | 1
06/20/2018 | [NAME] |  | Adventist | 06:00 AM | 06:17:00 |  | 07:27:00 | 14:21:00 |  | 15:04:00 | 14:30:00 | 0:00:00 |  | 1
06/20/2018 | [NAME] |  | East Tract 8 |  |  |  |  |  |  |  | 02:30 PM | 0:00:00 |  | 2.5
06/21/2018 | [NAME] |  | Econ | 06:00 AM | 07:31:00 |  | 08:35:00 | 13:40:00 |  | 14:04:00 | 02:30 PM
06/22/2018 | [NAME] |  | Econ | 06:00 AM | 06:30:00 |  | 07:20:00 | 13:51:00 |  | 14:23:00 | 14:30:00 |  |  | 4
06/22/2018 | [NAME] |  | ASR |  |  |  |  |  |  |  | 02:30 PM | 0:00:00 |  | 3
 | Willie S Total
06/18/2018 | Zachary |  | Dollar General Mims | 05:52 AM | 06:49:00 |  | 07:47:00 | 10:21:00 |  |  |  |  |  | 8
06/18/2018 | Zachary |  | Cypress |  |  |  | 11:22:00 | 13:07:00
06/18/2018 | Zachary |  | Dover |  |  |  | 13:31:00 | 15:16:00 |  | 15:52:00 | 03:17 PM |  |  | 2
06/19/2018 | Zachary |  | Oak Trail | 05:49 AM | 06:22:00 |  | 07:28:00 | 09:34:00 |  |  | 02:43 PM | 0:00:00 |  | 6
06/19/2018 | Zachary |  | Dover |  |  |  | 11:56:00 | 13:51:00 |  | 14:32:00 | 02:43 PM |  |  | 2
06/20/2018 | Zachary |  | Old Audubon | 07:48 AM |  | 0:00:00 |  |  |  |  | 11:43 AM | 0:00:00 |  | 8
06/21/2018 | Zachary |  | Innovation | 05:55 AM |  | 0:00:00 |  |  |  |  | 01:43 PM | 0:00:00 |  | 5
06/22/2018 | Zachary |  | Long Bay | 05:55 AM | 06:31:00 |  | 09:52:00 | 14:49:00 |  | 16:44:00 | 04:48 PM |  |  | 8
 | Zachary Total |  |  |  |  |  |  |  |  |  |  | 0:00:00