Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 08192018-08252018

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
08/20/2018 | [NAME] |  | [NAME] | 05:51 AM | 06:47:00 |  | 07:47:00 | 12:38:00 |  | 13:01:00 | 01:35 PM |  |  | 4
08/21/2018 | [NAME] |  | [NAME] | 05:50 AM | 06:11:00 |  | 07:25:00 | 14:01:00 |  | 14:32:00 | 02:35 PM |  |  | 5
08/22/2018 | [NAME] |  | Fedex | 05:50 AM | 06:22:00 |  | 07:35:00 | 14:22:00 |  | 15:01:00 | 04:04 PM |  |  | 7
08/23/2018 | [NAME] |  | grande lakes | 05:51 AM | 06:20:00 |  | 07:46:00 | 10:03:00 |  |  |  |  |  | 2.5
08/23/2018 | [NAME] |  | Fedex |  |  |  | 10:19:00 | 13:51:00 |  | 14:41:00 | 03:57 PM |  |  | 3
08/24/2018 | [NAME] |  | lake nona | 05:50 AM |  | 0:00:00 |  |  |  |  | 12:16 PM | 0:00:00 |  | 2
 | Allen Total
08/20/2018 | [NAME] |  | [NAME] | 06:55 AM | 07:12:00 |  | 08:37:00 | 15:03:00 |  | 15:36:00 | 04:05 PM
08/21/2018 | [NAME] |  | [NAME] | 03:29 AM | 07:59:00 | 0:00:00 | 12:09:00 | 15:22:00 |  | 15:29:00 | 03:47 PM
08/22/2018 | [NAME] |  | [NAME] | 07:01 AM | 07:49:00 |  | 08:54:00 | 15:41:00 |  | 16:18:00 | 04:34 PM |  |  | 40
08/23/2018 | [NAME] |  | 1-295 | 07:21 PM | 19:43:00 |  | 20:12:00 | 03:57:00 |  | 04:02:00 | 04:25 AM
08/24/2018 | [NAME] |  | [NAME] | 12:15 PM | 12:11:00 | 0:00:00 | 12:55:00 | 15:11:00 |  | 15:45:00 | 03:51 PM
 | [NAME]
08/20/2018 | [NAME] |  | Old | 06:16 AM | 06:41:00 |  | 08:52:00 | 10:10:00 |  |  |  |  |  | 2
08/20/2018 | [NAME] |  | [NAME] |  |  |  | 10:40:00 | 12:34:00 |  | 13:33:00 | 04:28 PM |  |  | 3
08/21/2018 | [NAME] |  | Trinity | 06:03 AM | 07:15:00 |  | 08:45:00 | 12:30:00 |  | 13:34:00 | 04:52 PM |  |  | 4
08/22/2018 | [NAME] |  | Long Bay | 06:09 AM | 06:25:00 |  | 09:53:00 | 16:01:00 |  | 18:55:00 | 07:40 PM |  |  | 7
08/23/2018 | [NAME] |  | Long Bay | 06:09 AM | 07:27:00 |  | 10:59:00 | 13:41:00 |  | 16:54:00 | 04:35 PM | 0:00:00 |  | 6
08/24/2018 | [NAME] |  | FDOT | 06:00 AM | 07:19:00 |  | 11:33:00 | 13:22:00 |  |  |  |  |  | 3
08/24/2018 | [NAME] |  | Long Bay |  |  |  | 14:18:00 | 14:38:00 |  | 17:32:00 | 05:47 PM |  |  | 3
 | Benjamin Total
08/20/2018 | Dwayne |  | [NAME] | 05:41 AM | 06:47:00 |  | 07:47:00 | 12:38:00 |  | 13:01:00 | 01:57 PM |  |  | 4
08/21/2018 | Dwayne |  | [NAME] | 05:49 AM | 06:11:00 |  | 07:25:00 | 14:01:00 |  | 14:32:00 | 03:11 PM |  |  | 5
08/22/2018 | Dwayne |  | grande lakes | 05:44 AM | 06:22:00 |  | 07:35:00 | 14:22:00 |  | 15:01:00 | 03:14 PM |  |  | 2.5
08/23/2018 | Dwayne |  | grande lakes | 05:50 AM | 06:20:00 |  | 07:46:00 | 10:03:00 |  |  |  |  |  | 2.5
08/23/2018 | Dwayne |  | Fedex |  |  |  | 10:19:00 | 13:51:00 |  | 14:41:00 | 03:04 PM |  |  | 3
08/24/2018 | Dwayne |  | lake nona | 05:46 AM |  | 0:00:00 |  |  |  |  | 05:31 PM | 0:00:00 |  | 2
 | [NAME]
08/20/2018 | Edgar |  | East Airfield | 06:02 AM | 06:17:00 |  | 07:13:00 | 12:47:00 |  | 13:20:00 | 01:58 PM |  |  | 2
08/21/2018 | Edgar |  | Ulta | 06:07 AM | 06:28:00 |  | 07:29:00 | 09:06:00 |  |  |  |  |  | 2
08/21/2018 | Edgar |  | Fedex |  |  |  | 09:39:00 | 14:55:00 |  | 15:44:00 | 04:21 PM |  |  | 6
08/22/2018 | Edgar |  | Lake Nona | 05:59 AM | 06:26:00 |  | 07:41:00 | 13:36:00 |  | 14:15:00 | 05:21 PM | 0:00:00 |  | 7
08/23/2018 | Edgar |  | Fedex | 06:00 AM | 06:22:00 |  | 07:15:00 | 13:56:00 |  | 14:49:00 | 03:01 PM |  |  | 5
08/24/2018 | Edgar |  | [NAME] | 05:58 AM | 06:37:00 |  | 07:29:00 | 16:07:00 |  | 17:27:00 | 05:31 PM |  |  | 7
 | [NAME]
08/19/2018 | Efrain |  | Walmart 4 | 03:22 PM | 16:24:00 |  | 19:55:00 | 07:55:00 |  | 08:26:00 | 08:43 AM
08/20/2018 | Efrain |  |  | 03:12 PM | 15:14:00 |  | 15:42:00 | 19:09:00 |  | 19:36:00 | 07:40 PM
08/21/2018 | Efrain |  |  | 07:05 AM | 07:01:00 | 0:00:00 | 07:13:00 | 04:42:00 |  | 07:45:00 | 07:48 AM
08/21/2018 | Efrain |  |  | 05:10 PM | 18:08:00 |  | 18:49:00 | 07:44:00 |  | 08:34:00 | 08:54 AM
08/22/2018 | Efrain |  |  | 06:03 PM | 18:08:00 |  | 18:49:00 | 07:44:00 |  | 07:50:00 | 08:04 AM
08/23/2018 | Efrain |  |  | 05:59 PM | 18:03:00 |  | 18:23:00 | 07:31:00 |  | 07:49:00 | 08:03 AM |  |  | 72
08/24/2018 | Efrain |  |  | 05:56 PM | 18:06:00 |  | 18:12:00 | 06:36:00 |  | 06:00:00 | 06:06 AM
 | Efrain Total
08/20/2018 | [NAME] |  |  | 06:06 AM |  | 0:00:00 |  |  |  |  | 04:21 PM | 0:00:00
08/21/2018 | [NAME] |  | Vernazza | 06:28 AM |  | 0:00:00 |  |  |  |  | 05:30 PM | 0:00:00 |  | 2
08/22/2018 | [NAME] |  | Lake Nona | 06:04 AM | 06:49:00 |  | 07:25:00 | 13:24:00 |  | 13:59:00 | 05:00 PM | 0:00:00 |  | 7
08/23/2018 | [NAME] |  |  | 07:35 PM |  | 0:00:00 |  |  |  |  | 04:35 AM | 0:00:00
 | [NAME]
08/20/2018 | [NAME] |  | old | 06:45 AM | 06:41:00 | 0:00:00 | 08:52:00 | 10:10:00 |  |  |  |  |  | 2
08/20/2018 | [NAME] |  | [NAME] |  |  |  | 10:40:00 | 12:34:00 |  | 13:33:00 | 06:45 PM | 0:00:00 |  | 3
08/21/2018 | [NAME] |  | Trinity | 06:23 AM | 07:15:00 |  | 08:45:00 | 12:30:00 |  | 13:34:00 | 01:42 PM |  |  | 4
08/22/2018 | [NAME] |  | Long Bay | 06:19 AM | 06:25:00 |  | 09:53:00 | 16:01:00 |  | 18:55:00 | 07:40 PM |  |  | 7
08/23/2018 | [NAME] |  | Long Bay | 07:30 AM | 07:27:00 | 0:00:00 | 10:59:00 | 13:41:00 |  | 16:54:00 | 04:05 PM | 0:00:00 |  | 6
08/24/2018 | [NAME] |  | FDOT | 06:20 AM | 07:19:00 |  | 11:33:00 | 13:22:00 |  |  |  |  |  | 3
08/24/2018 | [NAME] |  | Long Bay |  |  |  | 14:18:00 | 14:38:00 |  | 17:32:00 | 05:48 PM |  |  | 3
 | [NAME]
08/20/2018 | [NAME] |  |  | 06:09 AM | 08:13:00 |  | 09:13:00 | 12:02:00 |  | 12:28:00 | 04:29 PM | 0:00:00
08/21/2018 | [NAME] |  | Vernazza | 06:27 AM | 07:38:00 |  | 08:40:00 | 11:06:00 |  | 17:14:00 | 05:14 PM |  |  | 2
08/22/2018 | [NAME] |  | Vernazza | 06:16 AM | 07:50:00 |  | 09:35:00 | 09:57:00 |  |  |  |  |  | 1.5
08/22/2018 | [NAME] |  | Ulta |  |  |  | 11:04:00 | 11:24:00 |  |  |  |  |  | 1
08/22/2018 | [NAME] |  | Fedex |  |  |  | 12:13:00 | 13:42:00 |  | 14:15:00 | 04:29 PM | 0:00:00 |  | 3
08/23/2018 | [NAME] |  | Fedex | 05:57 AM | 06:48:00 |  | 08:46:00 | 13:55:00 |  |  |  |  |  | 3.5
08/23/2018 | [NAME] |  | CVS |  |  |  | 15:06:00 | 15:38:00 |  | 15:49:00 | 04:31 PM |  |  | 3
08/24/2018 | [NAME] |  | CVS | 05:54 AM | 06:59:00 |  | 07:35:00 | 08:52:00 |  |  |  |  |  | 2.5
08/24/2018 | [NAME] |  | CVS |  |  |  | 13:34:00 | 14:13:00 |  | 14:34:00 | 03:10 PM |  |  | 4
 | Patrick Total
08/20/2018 | [NAME] |  | [NAME] | 06:12 AM | 06:51:00 |  | 07:57:00 | 11:51:00 |  | 12:19:00 | 04:31 PM | 0:00:00 |  | 3
08/21/2018 | [NAME] |  | Trinity | 06:05 AM | 07:13:00 |  | 08:40:00 | 11:00:00 |  | 12:27:00 | 06:11 PM | 0:00:00 |  | 3
08/22/2018 | [NAME] |  | [NAME] | 06:11 AM | 06:58:00 |  | 08:01:00 | 11:54:00 |  | 12:40:00 | 02:04 PM |  |  | 7
08/23/2018 | [NAME] |  | edison | 06:09 AM | 06:45:00 |  | 07:30:00 | 14:39:00 |  | 15:25:00 | 04:30 PM |  |  | 8
08/24/2018 | [NAME] |  | edison | 06:12 AM | 06:58:00 |  | 07:46:00 | 14:22:00 |  | 14:47:00 | 03:07 PM |  |  | 7
 | [NAME]
08/19/2018 | [NAME] |  | Walmart 4 | 03:06 PM | 16:24:00 |  | 19:55:00 | 07:55:00 |  | 08:26:00 | 08:43 AM
08/20/2018 | [NAME] |  |  | 03:00 PM | 15:14:00 |  | 15:42:00 | 19:09:00 |  | 19:36:00 | 07:40 PM |  |  | 72
08/21/2018 | [NAME] |  |  | 07:04 AM | 07:01:00 | 0:00:00 | 07:13:00 | 04:42:00 |  | 07:45:00 | 07:57 AM
08/21/2018 | [NAME] |  |  | 05:10 PM | 18:08:00 |  | 18:49:00 | 07:44:00 |  | 08:34:00 | 08:55 AM
08/22/2018 | [NAME] |  |  | 06:03 PM | 18:08:00 |  | 18:49:00 | 07:44:00 |  | 07:50:00 | 08:04 AM
08/23/2018 | [NAME] |  |  | 05:59 PM | 18:03:00 |  | 18:23:00 | 07:31:00 |  | 07:49:00 | 08:03 AM
08/24/2018 | [NAME] |  |  | 05:55 PM | 18:06:00 |  | 18:12:00 | 06:36:00 |  | 06:00:00 | 06:01 AM
 | Rocco Total
08/20/2018 | [NAME] |  |  | 06:01 AM |  | 0:00:00 |  |  |  |  | 03:56 PM | 0:00:00
08/21/2018 | [NAME] |  | The Crossing | 06:16 AM | 06:50:00 |  |  |  |  |  |  |  |  | 2.5
08/21/2018 | [NAME] |  | Rolling Oaks |  |  |  | 10:03:00 | 13:22:00 |  |  |  |  |  | 2.5
08/21/2018 | [NAME] |  | Lake Lucerne |  |  |  | 08:39:00 | 09:19:00 |  | 13:51:00 | 02:49 PM |  |  | 2
08/22/2018 | [NAME] |  | shop | 05:59 AM |  | 0:00:00 |  |  |  |  | 03:47 PM | 0:00:00 |  | 7
08/23/2018 | [NAME] |  | edison | 06:00 AM | 06:45:00 |  | 07:30:00 | 14:39:00 |  | 15:25:00 | 03:46 PM |  |  | 8
08/24/2018 | [NAME] |  | edison | 06:14 AM | 06:58:00 |  | 07:46:00 | 14:22:00 |  | 14:47:00 | 02:55 PM |  |  | 7
 | Ryan Total
08/19/2018 | [NAME] |  | Walmart 2 | 05:00 PM | 16:18:00 | 0:00:00 | 18:15:00 | 07:17:00 |  | 09:37:00 | 10:22 AM
08/22/2018 | [NAME] |  |  | 05:05 PM | 20:00:00 |  | 23:08:00 | 07:00:00 |  | 08:00:00 | 08:05 AM |  |  |  | 24
08/23/2018 | [NAME] |  |  | 05:25 PM | 18:00:00 |  | 19:15:00 | 10:00:00 |  | 11:28:00 | 12:04 PM
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 0
08/20/2018 | Terrance |  | [NAME] | 06:00 AM | 06:51:00 |  | 07:57:00 | 11:51:00 |  | 12:19:00 | 04:35 PM | 0:00:00 |  | 3
08/21/2018 | Terrance |  | Trinity | 06:00 AM | 07:13:00 |  | 08:40:00 | 11:00:00 |  | 12:27:00 | 06:08 PM | 0:00:00 |  | 3
08/22/2018 | Terrance |  | shop | 06:28 AM |  | 0:00:00 |  |  |  |  | 10:18 AM | 0:00:00 |  | 7
 | Terrance Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
08/19/2018 | [NAME] |  | walmart 2 | 05:18 PM | 16:18:00 | 0:00:00 | 18:15:00 | 07:17:00 |  | 09:37:00 | 10:22 AM
08/22/2018 | [NAME] |  |  | 06:04 PM | 20:00:00 |  | 23:08:00 | 07:00:00 |  | 08:00:00 | 08:05 AM |  |  |  | 24
08/23/2018 | [NAME] |  |  | 05:26 PM | 18:00:00 |  | 19:15:00 | 10:00:00 |  | 11:28:00 | 11:56 AM
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 0
08/20/2018 | Willie |  | ASR | 06:00 AM | 06:20:00 |  | 08:33:00 | 10:47:00 |  | 12:55:00 | 01:10 PM |  |  | 4
08/22/2018 | Willie |  | Long Bay | 06:10 AM | 06:24:00 |  | 09:53:00 | 16:19:00 |  | 18:51:00 | 07:25 PM |  |  | 7 | 1
08/23/2018 | Willie |  | Fedex | 06:00 AM | 07:11:00 |  | 08:14:00 | 14:50:00 |  | 15:48:00 | 03:52 PM |  |  | 3.5
08/24/2018 | Willie |  | edison | 06:00 AM | 06:34:00 |  | 07:32:00 | 07:45:00 |  |  |  |  |  | 2.5
08/24/2018 | Willie |  | Vernazza |  |  |  | 08:59:00 | 12:31:00 |  | 13:26:00 | 01:40 PM |  |  | 4
 | Willie Total
08/20/2018 | Zachary |  | East Airfield | 05:52 AM | 06:17:00 |  | 07:13:00 | 12:47:00 |  | 13:20:00 | 01:57 PM |  |  | 2
08/21/2018 | Zachary |  | Ulta | 05:52 AM | 06:28:00 |  | 07:29:00 | 09:06:00 |  |  |  |  |  | 2
08/21/2018 | Zachary |  | Fedex |  |  |  | 09:39:00 | 14:55:00 |  | 15:44:00 | 04:21 PM |  |  | 6
08/22/2018 | Zachary |  | Lake Nona | 05:52 AM | 06:26:00 |  | 07:41:00 | 13:36:00 |  | 14:15:00 | 02:26 PM |  |  | 7
08/23/2018 | Zachary |  | Fedex | 05:51 AM | 06:48:00 |  | 08:46:00 | 13:55:00 |  |  |  |  |  | 3.5
08/23/2018 | Zachary |  | CVS |  |  |  | 15:06:00 | 15:38:00 |  | 15:49:00 | 03:54 PM |  |  | 3
08/24/2018 | Zachary |  | [NAME] | 05:53 AM | 06:37:00 |  | 07:29:00 | 16:07:00 |  | 17:27:00 | 05:31 PM |  |  | 7
 | Zachary Total
08/20/2018 | Nick |  | East Airfield | 06:04:00 | 06:17:00 |  | 07:13:00 | 12:47:00 |  | 13:20:00 | 13:57:00 |  |  | 2
08/21/2018 | Nick |  | Ulta | 06:03:00 | 06:28:00 |  | 07:29:00 | 09:06:00 |  |  |  |  |  | 2
08/21/2018 | Nick |  | Fedex |  |  |  | 09:39:00 | 14:55:00 |  | 15:44:00 | 16:23:00 |  |  | 6
08/22/2018 | Nick |  | Lake Nona | 06:03:00 | 06:26:00 |  | 07:41:00 | 13:36:00 |  | 14:15:00 | 16:29:00 | 0:00:00 |  | 7
08/23/2018 | Nick |  | Fedex | 06:00:00 | 06:22:00 |  | 07:15:00 | 13:56:00 |  | 14:49:00 | 15:01:00 |  |  | 5
08/24/2018 | Nick |  | [NAME] | 06:00:00 | 06:37:00 |  | 07:29:00 | 16:07:00 |  | 17:27:00 | 17:30:00 |  |  | 7
 | Nick Total
08/20/2018 | [NAME] |  | ASR | 06:02:00 | 06:20:00 |  | 08:33:00 | 10:47:00 |  | 12:55:00 | 16:04:00 | 0:00:00 |  | 4
08/21/2018 | [NAME] |  | The Crossing | 05:59:00 | 06:50:00 |  |  |  |  |  |  |  |  | 2.5
08/21/2018 | [NAME] |  | Rolling Oaks |  |  |  | 10:03:00 | 13:22:00 |  |  |  |  |  | 2.5
08/21/2018 | [NAME] |  | Lake Lucerne |  |  |  | 08:39:00 | 09:19:00 |  | 13:51:00 | 16:10:00 | 0:00:00 |  | 2
08/22/2018 | [NAME] |  | Long Bay | 05:56:00 | 06:24:00 |  | 09:53:00 | 16:19:00 |  | 18:51:00 | 19:01:00 |  |  | 7
08/23/2018 | [NAME] |  | Fedex | 05:59:00 | 07:11:00 |  | 08:14:00 | 14:50:00 |  | 15:48:00 | 16:31:00 |  |  | 3.5
08/24/2018 | [NAME] |  | edison | 05:57:00 | 06:34:00 |  | 07:32:00 | 07:45:00 |  |  |  |  |  | 2.5
08/24/2018 | [NAME] |  | Vernazza |  |  |  | 08:59:00 | 12:31:00 |  | 13:26:00 | 16:35:00 | 0:00:00 |  | 4
 | [NAME]