Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 09232018-09292018

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
09/24/2018 | [NAME] |  | Maitland | 05:50 AM | 06:09:00 |  | 07:33:00 | 13:28:00 |  | 13:54:00 | 02:37 PM |  |  | 2.5
09/25/2018 | [NAME] |  | shop | 05:50 AM |  | 0:00:00 |  |  |  |  | 10:41 AM | 0:00:00
09/26/2018 | [NAME] |  | Golden | 05:50 AM | 06:49:00 |  | 08:04:00 | 09:45:00 |  |  |  |  |  | 2
09/26/2018 | [NAME] |  | Watson |  |  |  | 10:52:00 | 14:12:00 |  | 14:49:00 | 03:23 PM |  |  | 3
09/27/2018 | [NAME] |  | Burlington | 05:51 AM | 06:30:00 |  | 07:31:00 | 10:51:00 |  | 11:26:00 | 11:35 AM |  |  | 5
09/28/2018 | [NAME] |  | Pure | 05:50 AM | 06:40:00 |  | 07:32:00 | 10:24:00 |  |  |  |  |  | 4
09/28/2018 | [NAME] |  | Maitland |  |  |  | 10:56:00 | 12:30:00 |  | 13:05:00 | 01:43 PM |  |  | 2.5
 | Allen Total
09/23/2018 | [NAME] |  |  | 06:21 PM | 19:10:00 |  | 20:05:00 | 23:51:00 |  | 00:37:00 | 01:19 AM
09/24/2018 | [NAME] |  |  | 06:27 PM | 19:10:00 |  | 20:05:00 | 23:51:00 |  | 00:37:00 | 01:24 AM
09/26/2018 | [NAME] |  |  | 04:44 AM | 05:07:00 |  | 06:36:00 | 15:23:00 |  | 19:56:00 | 07:58 PM
09/27/2018 | [NAME] |  |  | 06:10 AM | 07:06:00 |  | 08:54:00 | 19:09:00 |  | 20:39:00 | 08:44 PM
 | [NAME]
09/23/2018 | Alonzo |  |  | 05:30 PM |  | 0:00:00 |  |  |  |  | 07:50 AM | 0:00:00
09/24/2018 | Alonzo |  | Walmart | 05:46 PM | 18:32:00 |  | 01:22:00 | 07:36:00 |  | 07:52:00 | 08:24 AM |  |  | 24
09/25/2018 | Alonzo |  |  | 04:07 PM | 16:30:00 |  | 18:38:00 | 08:59:00 |  | 09:33:00 | 09:47 AM
09/26/2018 | Alonzo |  |  | 04:42 PM | 17:32:00 |  | 18:14:00 | 08:02:00 |  | 08:19:00 | 08:19 AM
09/27/2018 | Alonzo |  |  | 05:54 PM | 18:01:00 |  | 18:28:00 | 22:56:00 |  | 04:08:00 | 04:08 AM
 | Alonzo Total
09/24/2018 | [NAME] |  | [NAME] park | 05:45 AM | 06:28:00 |  | 09:10:00 | 15:13:00 |  | 15:47:00 | 04:09 PM |  |  | 6
09/26/2018 | [NAME] |  | Four | 06:01 AM | 06:50:00 |  | 08:09:00 | 15:34:00 |  | 16:28:00 | 04:29 PM |  |  | 7 | 1
09/27/2018 | [NAME] |  | Cameron | 10:00 AM | 06:59:00 | 0:00:00 | 08:04:00 | 12:58:00 |  | 13:54:00 | 02:20 PM |  |  | 5
 | Benjamin Total
09/24/2018 | [NAME] |  | Samoy | 06:01 AM | 06:32:00 |  | 08:07:00 | 14:16:00 |  | 15:10:00 | 02:03 PM | 0:00:00 |  | 6
09/25/2018 | [NAME] |  | Marjons | 06:01 AM | 06:44:00 |  | 07:51:00 | 09:01:00 |  | 09:45:00 | 12:57 PM | 0:00:00 |  | 2
09/26/2018 | [NAME] |  | McClane | 04:31 AM | 04:49:00 |  | 06:49:00 | 08:27:00 |  | 09:51:00 | 11:09 AM |  |  | 4
09/27/2018 | [NAME] |  | Hollywood | 06:00 AM | 08:20:00 |  | 12:14:00 | 22:18:00 |  | 01:46:00 | 01:50 AM |  |  | 4
09/28/2018 | [NAME] |  | Hollywood | 06:02 AM | 07:05:00 |  | 11:41:00 | 16:19:00 |  | 20:09:00 | 08:14 PM |  |  | 4
 | [NAME]
09/27/2018 | [NAME] |  | Walmart | 06:05 PM | 19:19:00 |  | 22:59:00 | 05:15:00 |  | 06:09:00 | 06:19 AM |  |  | 24
 | Brandon Total
09/24/2018 | Dwayne |  | Maitland | 05:50 AM | 06:09:00 |  | 07:33:00 | 13:28:00 |  | 13:54:00 | 02:08 PM |  |  | 2.5
09/26/2018 | Dwayne |  | Golden | 05:44 AM | 06:08:00 |  | 08:04:00 | 09:45:00 |  |  |  |  |  | 5
09/26/2018 | Dwayne |  | Watson |  |  |  | 10:52:00 | 14:12:00 |  | 14:49:00 | 02:59 PM |  |  |  | 1
09/28/2018 | Dwayne |  | Pure | 05:46 AM | 06:40:00 |  | 07:32:00 | 10:24:00 |  |  |  |  |  | 4
09/28/2018 | Dwayne |  | Maitland |  |  |  | 10:56:00 | 12:30:00 |  | 13:05:00 | 02:04 PM |  |  | 2.5
 | [NAME]
09/23/2018 | Edgar |  | Cemex | 05:01 AM |  | 0:00:00 |  |  |  |  | 12:09 PM | 0:00:00 |  | 4
09/24/2018 | Edgar |  | Publix | 06:02 AM | 06:18:00 |  | 07:20:00 | 12:25:00 |  | 13:18:00 | 03:13 PM | 0:00:00 |  | 6
09/25/2018 | Edgar |  | Champions | 05:58 AM | 06:21:00 |  | 07:31:00 | 09:26:00 |  |  |  |  |  | 2.5
09/25/2018 | Edgar |  | [NAME] park |  |  |  | 10:09:00 | 12:46:00 |  | 12:55:00 | 01:32 PM |  |  | 2
09/26/2018 | Edgar |  | McClane | 04:24 AM | 04:49:00 |  | 06:49:00 | 08:27:00 |  | 09:51:00 | 03:56 PM | 0:00:00 |  | 4
09/27/2018 | Edgar |  | Cameron | 05:59 AM | 06:21:00 |  | 07:52:00 | 12:58:00 |  | 14:33:00 | 02:42 PM |  |  | 7
09/28/2018 | Edgar |  | Pure | 05:58 AM | 06:58:00 |  | 07:43:00 | 10:24:00 |  |  |  |  |  | 4
09/28/2018 | Edgar |  | Maitland |  |  |  | 12:03:00 | 13:14:00 |  | 13:28:00 | 02:13 PM |  |  | 2.5
 | [NAME]
09/27/2018 | Efrain |  | Walmart | 08:16 PM | 19:19:00 | 0:00:00 | 22:59:00 | 05:15:00 |  | 06:09:00 | 05:41 AM | 0:00:00 |  | 24
 | Efrain Total
09/24/2018 | [NAME] |  |  | 06:00 AM |  | 0:00:00 |  |  |  |  | 04:00 PM | 0:00:00
09/25/2018 | [NAME] |  | Barclay | 06:00 AM |  | 0:00:00 |  |  |  |  |  |  |  | 4
09/25/2018 | [NAME] |  | East Airfield |  |  |  |  |  |  |  | 06:11 PM | 0:00:00 |  | 2
09/26/2018 | [NAME] |  | McClane | 04:31 AM | 04:49:00 |  | 06:49:00 | 09:26:00 |  | 11:42:00 | 07:56 PM | 0:00:00 |  | 4
09/27/2018 | [NAME] |  |  | 06:32 AM |  | 0:00:00 |  |  |  |  | 07:13 PM | 0:00:00
09/28/2018 | [NAME] |  |  | 05:59 AM |  | 0:00:00 |  |  |  |  | 01:46 PM | 0:00:00
 | [NAME]
09/24/2018 | [NAME] |  | Publix | 05:52 AM | 06:18:00 |  | 07:20:00 | 12:25:00 |  | 13:18:00 | 02:39 PM | 0:00:00 |  | 6
09/25/2018 | [NAME] |  | Champions | 05:53 AM | 06:21:00 |  | 07:31:00 | 09:26:00 |  |  |  |  |  | 2.5
09/25/2018 | [NAME] |  | [NAME] park |  |  |  | 10:09:00 | 12:46:00 |  | 12:55:00 | 01:40 PM |  |  | 2
09/26/2018 | [NAME] |  | Golden | 05:52 AM | 06:34:00 |  | 08:08:00 | 10:04:00 |  |  |  |  |  | 2
09/26/2018 | [NAME] |  | Watson |  |  |  |  |  |  |  | 03:39 PM | 0:00:00 |  | 3
09/27/2018 | [NAME] |  | Cameron | 06:00 AM | 06:21:00 |  | 07:52:00 | 12:58:00 |  | 14:33:00 | 02:41 PM |  |  | 7
09/28/2018 | [NAME] |  | Lake Nona | 06:00 AM | 06:52:00 |  | 08:14:00 | 16:04:00 |  | 16:41:00 | 04:53 PM |  |  | 6
 | [NAME]
09/24/2018 | [NAME] |  | Samoy | 06:50 AM |  | 0:00:00 |  |  |  |  | 07:09 AM | 0:00:00 |  | 6
09/25/2018 | [NAME] |  | Barclay | 05:56 AM |  | 0:00:00 |  |  |  |  |  |  |  | 4
09/25/2018 | [NAME] |  | East Airfield |  |  |  |  |  |  |  | 03:25 PM | 0:00:00 |  | 2
09/26/2018 | [NAME] |  | Golden | 05:59 AM | 06:34:00 |  | 08:08:00 | 10:04:00 |  |  |  |  |  | 2
09/26/2018 | [NAME] |  | Watson |  |  |  |  |  |  | 10:04:00 | 10:36 AM |  |  | 3
09/27/2018 | [NAME] |  | shop | 06:00 AM |  | 0:00:00 |  |  |  |  | 03:42 PM | 0:00:00
09/28/2018 | [NAME] |  | Maitland | 06:06 AM |  | 0:00:00 |  |  |  |  | 01:54 PM | 0:00:00 |  | 3.5
 | Patrick Total
09/24/2018 | [NAME] |  | Samoy | 06:10 AM | 06:32:00 |  | 08:07:00 | 14:16:00 |  | 15:10:00 | 03:30 PM |  |  | 6
09/25/2018 | [NAME] |  | Marjons | 06:00 AM | 06:44:00 |  | 07:51:00 | 09:01:00 |  | 09:45:00 | 12:51 PM |  |  | 2
09/26/2018 | [NAME] |  | McClane | 04:30 AM | 04:49:00 |  | 06:49:00 | 08:27:00 |  | 09:51:00 | 11:08 AM | 0:00:00 |  | 4
2018-09-27 00:00:00 | [NAME] |  | Hollywood | 06:00:00 | 08:20:00 |  | 12:14:00 | 22:18:00 |  | 01:46:00 | 01:33:00 | 0:00:00 |  | 4
09/28/2018 | [NAME] |  | Hollywood | 06:00 AM | 07:05:00 |  | 11:41:00 | 16:19:00 |  | 20:09:00 | 08:14 PM |  |  | 4
 | [NAME]
09/27/2018 | [NAME] |  | Walmart | 06:05 PM | 19:19:00 |  | 22:59:00 | 05:15:00 |  | 06:09:00 | 06:19 AM |  |  | 24
 | Rocco Total
09/24/2018 | [NAME] |  | Publix | 05:58 AM | 06:39:00 |  | 10:34:00 | 12:34:00 |  | 13:25:00 | 02:49 PM |  |  | 6
09/26/2018 | [NAME] |  | four | 06:00 AM | 06:47:00 |  | 08:09:00 | 14:50:00 |  | 15:46:00 | 03:51 PM |  |  | 7
09/27/2018 | [NAME] |  | Cameron | 05:58 AM | 06:51:00 |  | 08:25:00 | 12:57:00 |  | 13:56:00 | 02:46 PM |  |  | 5
09/28/2018 | [NAME] |  | [NAME] | 06:00 AM | 07:01:00 |  | 08:44:00 | 15:06:00 |  | 15:39:00 | 04:00 PM |  |  | 1.5
 | Ryan Total
09/24/2018 | Sergio |  | Samoy | 05:57 AM | 06:32:00 |  | 08:07:00 | 14:16:00 |  | 15:10:00 | 03:30 PM |  |  | 6
09/25/2018 | Sergio |  | Barclay | 06:00 AM | 06:27:00 |  | 07:01:00 | 10:39:00 |  | 13:51:00 | 02:15 PM |  |  | 5
09/26/2018 | Sergio |  | Four | 05:59 AM | 06:50:00 |  | 08:09:00 | 15:34:00 |  | 16:28:00 | 04:35 PM |  |  | 7
09/27/2018 | Sergio |  | Cameron | 05:59 AM | 06:59:00 |  | 08:04:00 | 12:58:00 |  | 13:54:00 | 02:20 PM |  |  | 5
09/28/2018 | Sergio |  | Lake Nona | 05:57 AM | 06:52:00 |  | 08:14:00 | 16:04:00 |  | 16:41:00 | 04:53 PM |  |  | 6
 | Sergio Total
09/24/2018 | Terrance |  | Publix | 06:03 AM | 06:39:00 |  | 10:34:00 | 12:34:00 |  | 13:25:00 | 04:00 PM | 0:00:00 |  | 6
09/25/2018 | Terrance |  | shop | 06:11 AM |  | 0:00:00 |  |  |  |  | 01:02 PM | 0:00:00
09/26/2018 | Terrance |  | Four | 06:00 AM | 06:47:00 |  | 08:09:00 | 14:50:00 |  | 15:46:00 | 04:10 PM |  |  | 7
09/27/2018 | Terrance |  | Cameron | 06:45 AM | 06:51:00 |  | 08:25:00 | 12:57:00 |  | 13:56:00 | 02:27 PM |  |  | 5
09/28/2018 | Terrance |  | [NAME] | 06:03 AM | 07:01:00 |  | 08:44:00 | 15:06:00 |  | 15:39:00 | 03:44 PM |  |  | 1.5
 | Terrance Total
09/23/2018 | [NAME] |  |  | 05:25 PM |  | 0:00:00 |  |  |  |  | 07:48 AM | 0:00:00
09/24/2018 | [NAME] |  | Walmart | 05:52 PM | 18:32:00 |  | 01:22:00 | 07:36:00 |  | 07:52:00 | 08:23 AM
09/25/2018 | [NAME] |  |  | 04:07 PM | 16:30:00 |  | 18:38:00 | 08:59:00 |  | 09:33:00 | 09:47 AM |  |  | 24
09/26/2018 | [NAME] |  |  | 04:40 PM | 17:32:00 |  | 18:14:00 | 08:02:00 |  | 08:19:00 | 08:19 AM
09/27/2018 | [NAME] |  |  | 05:43 PM | 18:01:00 |  | 18:28:00 | 22:56:00 |  | 04:08:00 | 04:08 AM
 | [NAME]
09/24/2018 | Willie |  | [NAME] park | 05:56 AM | 06:28:00 |  | 09:10:00 | 15:13:00 |  | 15:47:00 | 03:49 PM |  |  | 6
09/25/2018 | Willie |  | shop | 05:53 AM |  | 0:00:00 |  |  |  |  | 06:39 AM | 0:00:00
09/26/2018 | Willie |  | Four | 05:58 AM | 06:50:00 |  | 08:09:00 | 15:34:00 |  | 16:28:00 | 04:35 PM |  |  | 7
09/27/2018 | Willie |  | Burlington | 06:02 AM | 06:30:00 |  | 07:31:00 | 10:51:00 |  | 11:26:00 | 11:31 AM |  |  | 5
09/28/2018 | Willie |  | Lake Nona | 05:55 AM | 06:52:00 |  | 08:14:00 | 16:04:00 |  | 16:41:00 | 04:44 PM |  |  | 6
 | Willie Total
09/23/2018 | Zachary |  | Cemex | 05:58 AM |  | 0:00:00 |  |  |  |  | 12:05 PM | 0:00:00 |  | 4
09/24/2018 | Zachary |  | Publix | 05:55 AM | 06:18:00 |  | 07:20:00 | 12:25:00 |  | 13:18:00 | 02:49 PM |  |  | 6
09/25/2018 | Zachary |  | Shop | 06:00 AM |  | 0:00:00 |  |  |  |  | 10:34 AM | 0:00:00
09/26/2018 | Zachary |  | Shop | 04:31 AM |  | 0:00:00 |  |  |  |  | 10:46 AM | 0:00:00 |  | 4
09/27/2018 | Zachary |  | Cameron | 05:59 AM | 06:21:00 |  | 07:52:00 | 12:58:00 |  | 14:33:00 | 02:36 PM |  |  | 7
 | Zachary Total
09/23/2018 | Nick |  | Cemex | 05:03:00 |  | 0:00:00 |  |  |  |  | 12:04:00 | 0:00:00 |  | 4
09/24/2018 | Nick |  | Publix | 05:53:00 | 06:18:00 |  | 07:20:00 | 12:25:00 |  | 13:18:00 | 15:22:00 | 0:00:00 |  | 6
09/25/2018 | Nick |  | Champions | 05:54:00 | 06:21:00 |  | 07:31:00 | 09:26:00 |  |  |  |  |  | 2.5
09/25/2018 | Nick |  | [NAME] park |  |  |  | 10:09:00 | 12:46:00 |  | 12:55:00 | 13:22:00 |  |  | 2
09/26/2018 | Nick |  | McClane | 04:33:00 | 04:49:00 |  | 06:49:00 | 08:27:00 |  | 09:51:00 | 15:56:00 | 0:00:00 |  | 4
09/27/2018 | Nick |  | Cameron | 05:59:00 | 06:21:00 |  | 07:52:00 | 12:58:00 |  | 14:33:00 | 14:45:00 |  |  | 7
2018-09-28 00:00:00 | Nick |  | Pure | 05:58:00 | 06:58:00 |  | 07:43:00 | 10:24:00 |  |  |  |  |  | 4
2018-09-28 00:00:00 | Nick |  | Maitland |  |  |  | 12:03:00 | 13:14:00 |  | 13:28:00 | 13:59:00 |  |  | 2.5
 | Nick Total
09/25/2018 | [NAME] |  | Barclay | 05:50:00 | 06:27:00 |  | 07:01:00 | 10:39:00 |  | 13:51:00 | 15:25:00 |  |  | 5
09/26/2018 | [NAME] |  | Four | 05:58:00 | 06:50:00 |  | 08:09:00 | 15:34:00 |  | 16:28:00 | 17:05:00 |  |  | 7 | 1
09/27/2018 | [NAME] |  | Burlington | 06:03:00 | 06:30:00 |  | 07:31:00 | 10:51:00 |  | 11:26:00 | 15:40:00 | 0:00:00 |  | 5
2018-09-28 00:00:00 | [NAME] |  | Lake Nona | 05:57:00 | 06:52:00 |  | 08:14:00 | 16:04:00 |  | 16:41:00 | 16:45:00 |  |  | 6
 | [NAME]
 | Grand Total