Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 06242018-06302018

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/25/2018 | [NAME] | 10 |  | 05:37 AM | 08:22:00 |  | 09:07:00 | 14:41:00 |  | 17:13:00 | 05:40 PM |  |  | 1
06/26/2018 | [NAME] |  | The Gatherings | 05:32 AM | 06:30:00 |  | 07:05:00 | 07:15:00 |  |  |  |  |  | 1
06/26/2018 | [NAME] |  | ASR |  |  |  | 08:06:00 | 16:35:00 |  | 17:13:00 | 05:25 PM |  |  | 4
06/27/2018 | [NAME] |  | [NAME] | 05:38 AM | 06:34:00 |  | 07:35:00 | 15:23:00 |  | 16:12:00 | 04:24 PM |  |  | 8
06/28/2018 | [NAME] |  | Chinese Church | 05:41 AM | 06:31:00 |  | 09:13:00 | 13:41:00 |  | 15:36:00 | 03:52 PM |  |  | 5
06/29/2018 | [NAME] |  | Chinese Church | 05:33 AM | 06:15:00 |  | 08:53:00 | 13:04:00 |  | 16:28:00 | 04:30 PM |  |  | 4
 | Allen Total |  |  |  |  |  |  |  |  |  |  |  |  | 29
06/25/2018 | [NAME] |  | I 295 | 03:13 AM | 06:19:00 |  | 08:15:00 | 16:20:00 |  | 17:20:00 | 04:43 PM | 0:00:00
06/26/2018 | [NAME] |  | [NAME] | 07:07 AM | 07:59:00 |  | 09:18:00 | 15:28:00 |  | 16:06:00 | 04:27 PM
06/27/2018 | [NAME] |  | [NAME] | 07:06 AM | 07:27:00 |  | 08:25:00 | 15:51:00 |  | 16:06:00 | 04:28 PM
06/28/2018 | [NAME] |  | I 295 | 06:50 PM | 11:44:00 | 0:00:00 | 11:52:00 | 12:53:00 |  | 18:31:00 | 08:10 PM
06/29/2018 | [NAME] |  | I 295 | 07:23 AM | 07:52:00 |  | 08:06:00 | 08:08:00 |  | 08:17:00 | 02:02 PM | 0:00:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 24
06/26/2018 | [NAME] | 4 | Vera | 05:54:00 | 07:35:00 |  | 08:30:00 | 14:58:00 |  | 15:26:00 | 16:53:00 |  |  | 3
06/27/2018 | [NAME] |  | Innovation | 05:56:00 | 06:40:00 |  | 12:59:00 | 15:03:00 |  |  |  |  |  | 5 | 1
06/27/2018 | [NAME] |  | disney |  |  |  | 07:42:00 | 12:16:00 |  | 15:43:00 | 17:02:00
06/28/2018 | [NAME] |  | [NAME] | 05:52:00 | 06:47:00 |  | 08:40:00 | 14:14:00 |  | 15:09:00 | 16:09:00 |  |  | 5
06/29/2018 | [NAME] |  | ASR | 05:49:00 | 07:18:00 |  | 09:45:00 | 13:41:00 |  | 14:48:00 | 15:14:00 |  |  | 7
 | [NAME]
06/24/2018 | [NAME] |  | [NAME] | 05:58 PM |  | 0:00:00 |  |  |  |  | 10:10 PM | 0:00:00
06/25/2018 | [NAME] |  | [NAME] | 05:28 PM | 18:08:00 |  | 18:58:00 | 01:09:00 |  | 01:32:00 | 02:00 AM
06/26/2018 | [NAME] |  | [NAME] | 06:30 PM | 18:39:00 |  | 19:57:00 | 12:10:00 |  | 01:23:00 | 01:31 AM |  |  | 40
06/27/2018 | [NAME] |  | [NAME] | 02:37 PM | 17:08:00 |  | 17:45:00 | 02:36:00 |  | 02:56:00 | 03:01 AM
06/28/2018 | [NAME] |  | [NAME] | 04:33 PM | 17:18:00 |  | 18:07:00 | 04:17:00 |  | 04:38:00 | 04:41 AM
 | Benjamin Total
06/25/2018 | [NAME] |  | Walmart | 06:55 PM | 18:58:00 |  | 19:52:00 | 07:13:00 |  | 07:39:00 | 07:50 AM |  |  | 24
06/26/2018 | [NAME] |  | Walmart | 06:02 PM | 18:27:00 |  | 20:06:00 | 04:04:00 |  | 04:57:00 | 05:05 AM
06/27/2018 | [NAME] |  | Walmart | 05:55 PM | 17:58:00 |  | 19:15:00 | 05:38:00 |  | 06:29:00 | 06:38 AM
06/28/2018 | [NAME] |  | Walmart | 06:44 PM | 19:07:00 |  | 21:24:00 | 06:15:00 |  | 07:03:00 | 07:37 AM
 | [NAME]
06/24/2018 | [NAME] |  |  | 05:34 PM | 18:42:00 |  | 03:20:00 | 08:06:00 |  | 08:33:00 | 08:44 AM
06/25/2018 | [NAME] |  |  | 06:07 PM | 18:08:00 |  | 18:44:00 | 07:58:00 |  | 08:19:00 | 08:23 AM
06/26/2018 | [NAME] |  |  | 06:06 PM | 18:06:00 |  | 18:11:00 | 07:58:00 |  | 08:32:00 | 08:43 AM
06/27/2018 | [NAME] |  |  | 06:06 PM | 18:07:00 |  | 18:40:00 | 08:05:00 |  | 08:39:00 | 08:57 AM |  |  | 72
06/28/2018 | [NAME] |  |  | 06:02 PM | 18:04:00 |  | 18:20:00 | 08:30:00 |  | 08:40:00 | 08:52 AM
06/29/2018 | [NAME] |  |  | 04:58 PM | 16:57:00 | 0:00:00 | 17:14:00 | 08:08:00 |  | 11:25:00 | 05:37 AM | 0:00:00
 | Brandon Total
06/26/2018 | Dwayne |  | The Gatherings | 05:42 AM | 06:30:00 |  | 07:05:00 | 07:15:00 |  |  |  |  |  | 4
06/26/2018 | Dwayne |  | ASR |  |  |  | 08:06:00 | 16:35:00 |  | 17:13:00 | 05:18 PM |  |  | 3
06/27/2018 | Dwayne |  | [NAME] | 05:41 AM | 06:34:00 |  | 07:35:00 | 15:23:00 |  | 16:12:00 | 04:58 PM |  |  | 8 | 1
06/28/2018 | Dwayne |  | Chinese Church | 05:45 AM | 06:31:00 |  | 09:13:00 | 13:41:00 |  | 15:36:00 | 03:44 PM |  |  | 5
06/29/2018 | Dwayne |  | Chinese Church | 05:43 AM | 06:15:00 |  | 08:53:00 | 13:04:00 |  | 16:28:00 | 04:37 PM |  |  | 4
 | [NAME]
06/25/2018 | Edgar |  | Rolling oaks 5a | 05:57 AM | 06:25:00 |  | 09:27:00 | 15:38:00 |  | 16:38:00 | 06:00 PM |  |  | 7
06/26/2018 | Edgar |  | Rolling oaks 5a | 05:59 AM | 06:15:00 |  | 08:13:00 | 14:34:00 |  | 15:32:00 | 04:09 PM |  |  | 8
06/27/2018 | Edgar |  | Rolling oaks 5a | 06:03 AM | 06:14:00 |  | 07:39:00 | 14:50:00 |  | 15:57:00 | 04:11 PM |  |  | 8
06/28/2018 | Edgar |  | Rolling oaks 5a | 06:00 AM | 06:42:00 |  | 08:12:00 | 14:08:00 |  | 14:58:00 | 03:06 PM |  |  | 8
06/29/2018 | Edgar |  | Rolling oaks 5a | 06:00 AM | 06:57:00 |  | 08:19:00 | 12:57:00 |  | 14:15:00 | 02:34 PM |  |  | 8
 | [NAME]
06/24/2018 | Efrain |  | Walmart | 08:04 PM | 18:42:00 | 0:00:00 | 03:20:00 | 08:06:00 |  | 08:33:00 | 08:47 AM |  |  | 72
06/25/2018 | Efrain |  |  | 05:59 PM | 18:08:00 |  | 18:44:00 | 07:58:00 |  | 08:19:00 | 08:34 AM
06/26/2018 | Efrain |  |  | 05:59 PM | 18:06:00 |  | 18:11:00 | 07:58:00 |  | 08:32:00 | 08:44 AM
06/27/2018 | Efrain |  |  | 06:01 PM | 18:07:00 |  | 18:40:00 | 08:05:00 |  | 08:39:00 | 08:54 AM |  |  | 72
06/28/2018 | Efrain |  |  | 05:57 PM | 18:04:00 |  | 18:20:00 | 08:30:00 |  | 08:40:00 | 08:49 AM
06/29/2018 | Efrain |  |  | 04:52 PM | 16:57:00 | 0:00:00 | 17:14:00 | 08:08:00 |  | 11:25:00 | 07:34 AM | 0:00:00
 | Efrain Total
06/25/2018 | [NAME] | 1 | Hillcrest | 03:15 AM | 06:19:00 |  | 08:15:00 | 16:20:00 |  | 17:20:00 | 06:00 PM |  |  | 7
06/26/2018 | [NAME] |  | Dollar General Mims | 05:51 AM | 06:49:00 |  | 07:42:00 | 13:00:00 |  | 13:33:00 | 06:00 PM | 0:00:00 |  | 7
06/27/2018 | [NAME] |  | disney | 06:04 AM | 06:36:00 |  | 07:42:00 | 13:27:00 |  | 15:19:00 | 05:01 PM | 0:00:00
06/29/2018 | [NAME] |  | Long Bay road | 07:52 AM | 09:32:00 |  | 10:05:00 | 13:16:00 |  | 13:31:00 | 01:38 PM |  |  | 3
 | [NAME]
06/24/2018 | [NAME] |  | [NAME] | 05:45 PM |  | 0:00:00 |  |  |  |  | 10:10 PM | 0:00:00
06/25/2018 | [NAME] |  | [NAME] | 05:06 PM | 18:08:00 |  | 18:58:00 | 01:09:00 |  | 01:32:00 | 02:00 AM |  |  | 40
06/26/2018 | [NAME] |  | [NAME] | 06:30 PM | 18:39:00 |  | 19:57:00 | 12:10:00 |  | 01:23:00 | 01:31 AM
06/27/2018 | [NAME] |  | [NAME] | 03:32 PM | 17:08:00 |  | 17:45:00 | 02:36:00 |  | 02:56:00 | 03:01 AM
06/28/2018 | [NAME] |  | [NAME] | 04:59 PM | 17:18:00 |  | 18:07:00 | 04:17:00 |  | 04:38:00 | 04:40 AM
 | [NAME]
06/24/2018 | Logan |  |  | 05:28 PM | 18:42:00 |  | 03:20:00 | 08:06:00 |  | 08:33:00 | 08:48 AM
06/25/2018 | Logan |  |  | 05:00 PM | 18:08:00 |  | 18:44:00 | 07:58:00 |  | 08:19:00 | 07:30 AM | 0:00:00
06/26/2018 | Logan |  | Walmart | 06:00 PM | 18:06:00 |  | 18:11:00 | 07:58:00 |  | 08:32:00 | 08:43 AM |  |  | 72
06/27/2018 | Logan |  |  | 06:02 PM | 18:07:00 |  | 18:40:00 | 08:05:00 |  | 08:39:00 | 08:55 AM
06/28/2018 | Logan |  |  | 05:59 PM | 18:04:00 |  | 18:20:00 | 08:30:00 |  | 08:40:00 | 07:55 AM | 0:00:00
06/29/2018 | Logan |  |  | 05:06 PM | 16:57:00 | 0:00:00 | 17:14:00 | 08:08:00 |  | 11:25:00 | 06:00 AM | 0:00:00
 | Logan Total
06/25/2018 | Nick |  | Rolling oaks 5a | 05:53:00 | 06:25:00 |  | 09:27:00 | 15:38:00 |  | 16:38:00 | 16:46:00 |  |  | 7
06/26/2018 | Nick |  | Rolling oaks 5a | 06:04:00 | 06:15:00 |  | 08:13:00 | 14:34:00 |  | 15:32:00 | 16:12:00 |  |  | 8
06/27/2018 | Nick |  | Rolling oaks 5a | 05:58:00 | 06:14:00 |  | 07:39:00 | 14:50:00 |  | 15:57:00 | 16:10:00 |  |  | 8
06/28/2018 | Nick |  | Rolling oaks 5a | 06:00:00 | 06:42:00 |  | 08:12:00 | 14:08:00 |  | 14:58:00 | 15:06:00 |  |  | 8
06/29/2018 | Nick |  | 107th | 06:00:00 | 06:45:00 |  | 09:22:00 | 09:32:00 |  |  |  |  |  | 3
06/29/2018 | Nick |  | Rolling oaks 5a |  |  |  | 12:35:00 | 12:56:00 |  | 14:00:00 | 14:03:00 |  |  | 4
 | Nick Total
06/25/2018 | [NAME] |  | Old Audubon | 06:38 AM | 08:22:00 |  | 09:07:00 | 14:41:00 |  | 15:14:00 | 03:32 PM |  |  | 7
06/26/2018 | [NAME] | 2 | Old Audubon | 06:02 AM | 06:59:00 |  | 07:41:00 | 14:33:00 |  | 15:00:00 | 04:54 PM |  |  | 8
06/27/2018 | [NAME] | 7 | Old Audubon | 06:04 AM | 07:19:00 |  | 09:15:00 | 14:51:00 |  | 15:20:00 | 04:00 PM |  |  | 6
06/28/2018 | [NAME] |  | Rolling Oaks 1a | 06:00 AM | 06:48:00 |  | 07:43:00 | 14:07:00 |  | 15:12:00 | 04:07 PM |  |  | 6
06/29/2018 | [NAME] |  | Rolling Oaks Ph 1a | 06:55 AM | 07:18:00 |  | 09:45:00 | 13:41:00 |  | 14:48:00 | 03:13 PM |  |  | 8
 | Patrick Total
06/24/2018 | [NAME] |  |  | 05:34 PM | 18:42:00 |  | 03:20:00 | 08:06:00 |  | 08:33:00 | 08:43 AM
06/25/2018 | [NAME] |  | Walmart | 06:00 PM | 18:08:00 |  | 18:44:00 | 07:58:00 |  | 08:19:00 | 08:23 AM |  |  | 72
06/26/2018 | [NAME] |  |  | 06:01 PM | 18:06:00 |  | 18:11:00 | 07:58:00 |  | 08:32:00 | 08:42 AM
06/27/2018 | [NAME] |  |  | 06:00 PM | 18:07:00 |  | 18:40:00 | 08:05:00 |  | 08:39:00 | 08:56 AM
06/28/2018 | [NAME] |  |  | 06:01 PM | 18:04:00 |  | 18:20:00 | 08:30:00 |  | 08:40:00 | 08:48 AM
06/29/2018 | [NAME] |  |  | 04:53 PM | 16:57:00 | 0:00:00 | 17:14:00 | 08:08:00 |  | 11:25:00 | 06:01 AM | 0:00:00
 | Rocco Total
06/25/2018 | [NAME] |  | Old Audubon | 06:01 AM | 08:22:00 |  | 09:07:00 | 14:41:00 |  | 15:14:00 | 03:18 PM |  |  | 7
06/26/2018 | [NAME] |  | Old Audubon | 06:01 AM | 08:22:00 |  | 09:07:00 | 14:41:00 |  | 15:14:00 | 03:21 PM |  |  | 8
06/27/2018 | [NAME] |  | [NAME] | 06:06 AM | 07:23:00 |  | 09:10:00 | 15:17:00 |  | 16:22:00 | 04:25 PM |  |  | 6
06/28/2018 | [NAME] |  | [NAME] | 06:02 AM | 07:20:00 |  | 09:36:00 | 13:41:00 |  | 14:50:00 | 04:08 PM |  |  | 5
06/29/2018 | [NAME] |  | asr | 05:58 AM | 07:18:00 |  | 09:45:00 | 13:41:00 |  | 14:48:00 | 03:13 PM |  |  | 7
 | Ryan Total
06/25/2018 | [NAME] |  | Walmart | 06:55 PM | 18:58:00 |  | 19:52:00 | 07:13:00 |  | 07:39:00 | 07:50 AM
06/26/2018 | [NAME] |  | Walmart | 06:02 PM | 18:27:00 |  | 20:06:00 | 04:04:00 |  | 04:57:00 | 05:04 AM |  |  | 24
06/27/2018 | [NAME] |  | Walmart | 05:55 PM | 17:58:00 |  | 19:15:00 | 05:38:00 |  | 06:29:00 | 06:38 AM
06/28/2018 | [NAME] |  | Walmart | 06:42 PM | 19:07:00 |  | 21:24:00 | 06:15:00 |  | 07:03:00 | 07:37 AM
 | [NAME]
06/26/2018 | Terrance | 6 | Village F | 07:27 AM | 08:15:00 |  | 10:08:00 | 15:38:00 |  | 17:32:00 | 05:38 PM |  |  | 8
06/27/2018 | Terrance |  | [NAME] | 06:20 AM | 07:20:00 |  | 09:36:00 | 13:41:00 |  | 14:50:00 | 04:37 PM |  |  | 6 | 2
06/29/2018 | Terrance |  | ASR | 06:25 AM | 07:18:00 |  | 09:45:00 | 13:41:00 |  | 14:48:00 | 04:00 PM
 | Terrance Total
06/25/2018 | [NAME] |  | Walmart | 04:47 PM | 18:58:00 |  | 19:52:00 | 07:13:00 |  | 07:39:00 | 07:50 AM
06/26/2018 | [NAME] |  | Walmart | 05:36 PM | 18:27:00 |  | 20:06:00 | 04:04:00 |  | 04:57:00 | 05:04 AM
06/27/2018 | [NAME] |  | Walmart | 05:26 PM | 17:58:00 |  | 19:15:00 | 05:38:00 |  | 06:29:00 | 06:35 AM |  |  | 24
06/28/2018 | [NAME] |  | Walmart | 05:21 PM | 19:07:00 |  | 21:24:00 | 06:15:00 |  | 07:03:00 | 07:49 AM
 | [NAME]
06/25/2018 | Willie |  |  | 05:59 AM | 08:22:00 |  | 09:08:00 | 14:41:00 |  | 15:05:00 | 04:39 PM
06/27/2018 | Willie |  | Innovation | 05:53 AM | 06:40:00 |  | 12:59:00 | 15:03:00 |  |  |  |  |  | 5
06/27/2018 | Willie |  | disney |  |  |  | 07:42:00 | 12:16:00 |  | 15:43:00 | 03:44 PM |  |  |  | 1
06/28/2018 | Willie |  | [NAME] | 06:01 AM | 06:47:00 |  | 08:40:00 | 14:14:00 |  | 15:09:00 | 15:10:00 |  |  | 5
06/29/2018 | Willie |  | Rolling Oaks 1a | 06:04 AM | 07:18:00 |  | 09:35:00 | 13:41:00 |  | 14:48:00 | 02:58 PM |  |  | 6
 | Willie Total
06/26/2018 | [NAME] | 15 | Econ Medical | 06:00 AM | 06:51:00 |  | 07:32:00 | 09:56:00 |  |  |  |  |  | 3 | 1
06/26/2018 | [NAME] |  | Old Audubon |  |  |  | 10:06:00 | 14:48:00 |  | 16:12:00 | 03:00 PM | 0:00:00 |  | 4
06/27/2018 | [NAME] |  | Old Audubon | 06:00 AM | 07:16:00 |  | 11:59:00 | 15:10:00 |  | 16:02:00 | 04:00 PM | 0:00:00 |  | 6
06/28/2018 | [NAME] |  | Old Audubon | 06:00 AM | 06:55:00 |  | 07:32:00 | 18:55:00 |  | 19:26:00 | 07:30 PM |  |  | 8
06/29/2018 | [NAME] |  | Old Audubon | 06:00 AM | 06:08:00 |  | 08:01:00 | 15:00:00 |  | 15:09:00 | 04:00 PM |  |  | 7
 | Willie S Total
06/25/2018 | Zachary |  | Rolling oaks 5a | 05:56 AM | 06:25:00 |  | 09:27:00 | 15:38:00 |  | 16:38:00 | 04:48 PM |  |  | 7
06/26/2018 | Zachary |  | Rolling oaks 5a | 05:51 AM | 06:15:00 |  | 08:13:00 | 14:34:00 |  | 15:32:00 | 04:08 PM |  |  | 8
06/27/2018 | Zachary |  | Rolling oaks 5a | 05:50 AM | 06:14:00 |  | 07:39:00 | 14:50:00 |  | 15:57:00 | 04:10 PM |  |  | 8
06/28/2018 | Zachary |  | Rolling oaks 5a | 05:57 AM | 06:42:00 |  | 08:12:00 | 14:08:00 |  | 14:58:00 | 03:00 PM |  |  | 8
06/29/2018 | Zachary |  | 107th | 05:52 AM | 06:45:00 |  | 09:22:00 | 09:32:00 |  |  |  |  |  | 3
06/29/2018 | Zachary |  | Rolling oaks 5a |  |  |  | 12:35:00 | 12:56:00 |  | 14:00:00 | 02:03 PM |  |  | 4
 | Zachary Total