Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 09162018-09222018

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/17/2018 | [NAME] |  | Terra | 05:50 AM | 06:35:00 |  | 08:13:00 | 11:52:00 |  | 12:45:00 | 01:20 PM |  |  | 4.5
09/19/2018 | [NAME] |  |  | 05:50 AM |  | 0:00:00 |  |  |  |  | 06:04 AM | 0:00:00 |  |  | 1
09/20/2018 | [NAME] |  | Champions | 05:50 AM |  | 0:00:00 |  |  |  |  | 02:40 PM | 0:00:00 |  | 5
09/21/2018 | [NAME] |  | mater K-8 | 05:50 AM | 06:34:00 |  | 07:48:00 | 08:44:00 |  |  |  |  |  | 2
09/21/2018 | [NAME] |  | Maitland |  |  |  | 10:05:00 | 10:16:00 |  | 10:47:00 | 11:32 AM |  |  | 2
 | Allen Total
09/16/2018 | [NAME] |  |  | 09:10 PM | 21:12:00 |  | 21:54:00 | 22:59:00 |  | 23:04:00 | 11:04 PM
09/17/2018 | [NAME] |  | lowes | 10:37 AM | 11:00:00 |  | 11:24:00 | 11:29:00 |  | 11:38:00 | 11:40 AM |  |  | 40
09/17/2018 | [NAME] |  |  | 07:09 PM | 19:43:00 |  | 20:26:00 | 01:58:00 |  | 02:43:00 | 03:24 AM
09/18/2018 | [NAME] |  |  | 06:56 PM | 19:56:00 |  | 20:39:00 | 04:05:00 |  | 04:54:00 | 05:02 AM
09/19/2018 | [NAME] |  |  | 06:58 PM | 19:57:00 |  | 20:42:00 | 02:27:00 |  | 03:09:00 | 03:21 AM
09/20/2018 | [NAME] |  |  | 07:02 PM | 19:42:00 |  | 20:22:00 | 00:06:00 |  | 00:47:00 | 12:58 AM
 | [NAME]
09/17/2018 | [NAME] |  | [NAME] | 06:01 AM | 06:48:00 |  | 07:01:00 | 11:56:00 |  |  |  |  |  | 2
09/17/2018 | [NAME] |  | Laureate |  |  |  | 15:25:00 | 16:15:00 |  | 16:46:00 | 04:32 PM | 0:00:00 |  | 6
09/18/2018 | [NAME] |  | Laureate | 05:52 AM | 07:52:00 |  | 09:08:00 | 15:33:00 |  | 16:15:00 | 04:37 PM |  |  | 8
09/19/2018 | [NAME] |  | Laureate | 05:49 AM | 07:07:00 |  | 08:29:00 | 15:41:00 |  | 16:22:00 | 04:33 PM |  |  | 7
09/20/2018 | [NAME] |  | [NAME] | 06:00 AM | 07:13:00 |  | 09:06:00 | 11:33:00 |  | 15:33:00 | 05:00 PM |  |  | 3
09/21/2018 | [NAME] |  | [NAME] | 05:58 AM | 07:21:00 |  | 08:46:00 | 15:09:00 |  | 16:15:00 | 03:15 PM | 0:00:00 |  | 2
 | Benjamin Total
09/17/2018 | [NAME] |  | Renovation | 06:01 AM | 06:11:00 |  | 06:28:00 | 15:33:00 |  | 17:15:00 | 02:49 PM | 0:00:00 |  | 3
09/18/2018 | [NAME] |  | Del Webb | 06:00 AM |  | 0:00:00 |  |  |  |  |  |  |  | 2
09/18/2018 | [NAME] |  | Samoy |  |  |  |  |  |  |  | 01:30 PM | 0:00:00 |  | 2
09/19/2018 | [NAME] |  | Burlington | 06:01 AM | 06:26:00 |  | 07:30:00 | 11:57:00 |  | 12:33:00 | 03:03 PM |  |  | 5
09/20/2018 | [NAME] |  | [NAME] | 06:36 AM | 07:35:00 |  | 08:13:00 | 09:01:00 |  |  |  |  |  | 3
09/20/2018 | [NAME] |  | Trinity |  |  |  | 10:43:00 | 14:32:00 |  | 15:53:00 | 04:01 PM |  |  | 6
09/21/2018 | [NAME] |  | lake minneola | 06:00 AM | 06:39:00 |  | 08:11:00 | 11:50:00 |  | 12:51:00 | 01:15 PM |  |  | 4
 | [NAME]
09/16/2018 | [NAME] |  |  | 04:57 PM | 16:58:00 |  | 20:26:00 | 07:33:00 |  | 07:56:00 | 08:38 AM
09/17/2018 | [NAME] |  | Walmart | 04:56 PM | 17:02:00 |  | 19:11:00 | 07:52:00 |  | 08:15:00 | 08:41 AM
09/18/2018 | [NAME] |  | Walmart 3 | 06:00 PM | 18:05:00 |  | 18:29:00 | 07:04:00 |  | 08:00:00 | 08:39 AM |  |  | 72
09/19/2018 | [NAME] |  |  | 04:53 PM | 16:55:00 |  | 18:51:00 | 07:52:00 |  | 08:15:00 | 08:25 AM
09/20/2018 | [NAME] |  |  | 04:56 PM | 16:59:00 |  | 18:31:00 | 07:45:00 |  | 08:09:00 | 08:19 AM
09/21/2018 | [NAME] |  |  | 06:04 PM | 18:11:00 |  | 18:28:00 | 03:33:00 |  | 05:15:00 | 05:34 AM
 | Brandon Total
09/16/2018 | Dwayne |  | Burlington | 06:39 AM |  | 0:00:00 |  |  |  |  | 11:53 AM | 0:00:00
09/17/2018 | Dwayne |  | Terra | 05:46 AM | 06:35:00 |  | 08:13:00 | 11:52:00 |  | 12:45:00 | 02:34 PM |  |  | 4.5
09/18/2018 | Dwayne |  | Burlington | 05:42 AM | 06:30:00 |  | 07:47:00 | 14:42:00 |  | 15:19:00 | 03:27 PM |  |  | 5
09/19/2018 | Dwayne |  | Burlington | 05:51 AM | 06:26:00 |  | 07:30:00 | 11:57:00 |  | 12:33:00 | 01:31 PM |  |  | 5
09/20/2018 | Dwayne |  | Pure | 05:42 AM | 06:05:00 |  | 06:53:00 | 10:51:00 |  | 11:17:00 | 02:52 PM | 0:00:00 |  | 5
09/21/2018 | Dwayne |  | mater K-8 | 05:38 AM | 06:34:00 |  | 07:48:00 | 08:44:00 |  |  |  |  |  | 2
09/21/2018 | Dwayne |  | Maitland |  |  |  | 10:05:00 | 10:16:00 |  | 10:47:00 | 11:33 AM |  |  | 2
 | [NAME]
09/17/2018 | Edgar |  | lake Nona | 06:03 AM | 06:30:00 |  | 07:44:00 | 13:50:00 |  | 14:27:00 | 02:38 PM |  |  | 4
09/18/2018 | Edgar |  | Bent | 06:00 AM | 06:27:00 |  | 07:33:00 | 09:22:00 |  |  |  |  |  | 2.5
09/18/2018 | Edgar |  | Laureate |  |  |  | 10:12:00 | 14:36:00 |  | 15:16:00 | 03:31 PM |  |  | 5
09/19/2018 | Edgar |  | Laureate | 05:58 AM | 06:31:00 |  | 07:00:00 | 14:20:00 |  | 14:41:00 | 03:19 PM |  |  | 6
09/20/2018 | Edgar |  | Champions | 05:59 AM | 06:16:00 |  | 07:13:00 | 12:17:00 |  | 13:28:00 | 02:43 PM | 0:00:00 |  | 5
 | [NAME]
09/16/2018 | Efrain |  |  | 04:57 PM | 16:58:00 |  | 20:26:00 | 07:33:00 |  | 07:56:00 | 08:38 AM
09/17/2018 | Efrain |  | Walmart | 04:56 PM | 17:02:00 |  | 19:11:00 | 07:52:00 |  | 08:15:00 | 08:42 AM |  |  | 72
09/19/2018 | Efrain |  |  | 04:52 PM | 16:55:00 |  | 18:51:00 | 07:52:00 |  | 08:15:00 | 08:25 AM
09/20/2018 | Efrain |  | Walmart 2 | 04:56 PM | 16:59:00 |  | 18:31:00 | 07:45:00 |  | 08:09:00 | 08:18 AM
09/21/2018 | Efrain |  |  | 06:04 PM | 18:11:00 |  | 18:28:00 | 03:33:00 |  | 05:15:00 | 08:31 AM
 | Efrain Total
09/17/2018 | [NAME] |  | lake Nona | 08:31 AM | 08:24:00 | 0:00:00 | 09:11:00 | 15:55:00 |  | 16:24:00 | 05:18 PM |  |  | 3
09/18/2018 | [NAME] |  | Bridge Prep | 06:00 AM | 06:38:00 |  | 07:36:00 | 14:43:00 |  | 15:18:00 | 04:00 PM |  |  | 2
09/19/2018 | [NAME] |  | mater K-8 | 06:12 AM | 07:05:00 |  | 09:04:00 | 14:26:00 |  | 14:51:00 | 05:06 PM | 0:00:00 |  | 4
09/20/2018 | [NAME] |  | lake minneola | 06:01 AM | 07:17:00 |  | 08:33:00 | 15:07:00 |  | 16:17:00 | 04:50 PM |  |  | 7
09/21/2018 | [NAME] |  | [NAME] | 06:43 AM | 07:17:00 |  | 11:05:00 | 13:39:00 |  | 14:34:00 | 02:30 PM | 0:00:00 |  | 1.5
 | [NAME]
09/17/2018 | [NAME] |  | lake Nona | 06:02 AM |  | 0:00:00 |  |  |  |  | 02:39 PM | 0:00:00 |  | 4
09/18/2018 | [NAME] |  | Burlington | 06:04 AM | 06:30:00 |  | 07:47:00 | 14:42:00 |  | 15:19:00 | 03:59 PM |  |  | 5
09/19/2018 | [NAME] |  | Burlington | 06:03 AM | 06:26:00 |  | 07:30:00 | 11:57:00 |  | 12:33:00 | 12:47 PM |  |  | 5
09/20/2018 | [NAME] |  | Pure | 05:46 AM | 06:05:00 |  | 06:53:00 | 10:51:00 |  | 11:17:00 | 02:42 PM | 0:00:00 |  | 5
09/21/2018 | [NAME] |  | Ridgewood | 07:16 AM |  | 0:00:00 |  |  |  |  | 03:39 PM | 0:00:00 |  | 7
 | [NAME]
09/17/2018 | [NAME] |  | [NAME] | 06:01 AM | 06:48:00 |  | 07:01:00 | 11:56:00 |  |  |  |  |  | 2
09/17/2018 | [NAME] |  | Laureate |  |  |  | 15:25:00 | 16:15:00 |  | 16:46:00 | 04:31 PM | 0:00:00 |  | 6
09/18/2018 | [NAME] |  | Laureate | 05:52 AM | 07:52:00 |  | 09:08:00 | 15:33:00 |  | 16:15:00 | 04:37 PM |  |  | 8
09/19/2018 | [NAME] |  | Laureate | 06:22 AM | 07:07:00 |  | 08:29:00 | 15:41:00 |  | 16:22:00 | 04:33 PM |  |  | 6
09/20/2018 | [NAME] |  | lake minneola | 06:28 AM |  | 0:00:00 |  |  |  |  | 04:20 PM | 0:00:00 |  | 7
09/21/2018 | [NAME] |  |  | 06:12 AM |  | 0:00:00 |  |  |  |  | 03:15 PM | 0:00:00
 | [NAME]
09/17/2018 | [NAME] |  | lake Nona | 06:08 AM | 08:24:00 |  | 09:11:00 | 15:55:00 |  | 16:24:00 | 05:01 PM |  |  | 3
09/18/2018 | [NAME] |  | Bridge Prep | 06:17 AM | 06:38:00 |  | 07:36:00 | 14:43:00 |  | 15:18:00 | 05:05 PM | 0:00:00 |  | 2
09/19/2018 | [NAME] |  | mater K-8 | 06:04 AM | 07:05:00 |  | 09:04:00 | 14:26:00 |  | 14:51:00 | 03:39 PM |  |  | 4
09/20/2018 | [NAME] |  | ASR | 06:03 AM | 06:54:00 |  | 08:21:00 | 09:54:00 |  |  |  |  |  | 2.5
09/20/2018 | [NAME] |  | lake minneola |  |  |  | 10:48:00 | 15:01:00 |  | 16:23:00 | 04:42 PM |  |  | 4
09/21/2018 | [NAME] |  | Ridgewood | 05:59 AM | 06:46:00 |  | 11:05:00 | 13:39:00 |  | 14:34:00 | 04:10 PM | 0:00:00 |  | 7
 | Patrick Total
09/16/2018 | [NAME] |  | Burlington | 06:31 AM |  | 0:00:00 |  |  |  |  | 11:31 AM | 0:00:00
09/17/2018 | [NAME] |  | [NAME] | 06:00 AM | 06:47:00 |  | 08:22:00 | 13:43:00 |  | 14:16:00 | 03:00 PM |  |  | 5
09/18/2018 | [NAME] |  | [NAME] | 05:59 AM | 06:36:00 |  | 08:55:00 | 12:44:00 |  | 13:14:00 | 01:30 PM |  |  | 2.5
09/19/2018 | [NAME] |  | mater K-8 | 06:00 AM | 07:05:00 |  | 09:04:00 | 14:26:00 |  | 14:51:00 | 03:08 PM |  |  | 4
09/20/2018 | [NAME] |  | [NAME] | 06:15 AM | 07:35:00 |  | 08:13:00 | 09:01:00 |  |  |  |  |  | 3
09/20/2018 | [NAME] |  | Trinity |  |  |  | 10:43:00 | 14:32:00 |  | 15:53:00 | 04:01 PM |  |  | 6
09/21/2018 | [NAME] |  | lake minneola | 06:00 AM | 06:39:00 |  | 08:11:00 | 11:50:00 |  | 12:51:00 | 01:13 PM |  |  | 4
 | [NAME]
09/16/2018 | [NAME] |  |  | 04:56 PM | 16:58:00 |  | 20:26:00 | 07:33:00 |  | 07:56:00 | 08:38 AM
09/17/2018 | [NAME] |  | Walmart | 04:56 PM | 17:02:00 |  | 19:11:00 | 07:52:00 |  | 08:15:00 | 08:41 AM
09/18/2018 | [NAME] |  | walmart 1 | 05:55 PM | 18:05:00 |  | 18:29:00 | 07:04:00 |  | 08:00:00 | 08:38 AM
09/19/2018 | [NAME] |  | Walmart 2 | 04:52 PM | 16:55:00 |  | 18:51:00 | 07:52:00 |  | 08:15:00 | 08:25 AM |  |  | 72
09/20/2018 | [NAME] |  |  | 04:56 PM | 16:59:00 |  | 18:31:00 | 07:45:00 |  | 08:09:00 | 08:18 AM
09/21/2018 | [NAME] |  |  | 06:04 PM | 18:11:00 |  | 18:28:00 | 03:33:00 |  | 05:15:00 | 06:00 AM
 | Rocco Total
09/17/2018 | [NAME] |  | Renovation | 06:00 AM | 06:11:00 |  | 18:28:00 | 03:33:00 |  | 05:15:00 | 03:30 PM | 0:00:00 |  | 3
09/18/2018 | [NAME] |  | Burlington | 06:00 AM | 06:30:00 |  | 07:47:00 | 14:42:00 |  | 15:19:00 | 03:30 PM |  |  | 5
09/19/2018 | [NAME] |  | the Vineyards | 06:01 AM | 06:35:00 |  | 07:45:00 | 09:03:00 |  | 14:47:00 | 03:12 PM |  |  | 3
09/20/2018 | [NAME] |  | Champions | 06:09 AM | 06:28:00 |  | 08:29:00 | 08:46:00 |  | 09:48:00 | 02:43 PM | 0:00:00 |  | 5
09/21/2018 | [NAME] |  | Montevilla | 06:00 AM | 06:36:00 |  | 09:40:00 | 11:55:00 |  | 13:36:00 | 01:48 PM |  |  | 2.5
 | Ryan Total
09/17/2018 | Sergio |  | [NAME] | 05:57 AM | 06:47:00 |  | 08:22:00 | 13:43:00 |  | 14:16:00 | 02:36 PM |  |  | 5
09/18/2018 | Sergio |  | [NAME] | 05:59 AM | 06:36:00 |  | 08:55:00 | 12:44:00 |  | 13:14:00 | 02:05 PM |  |  | 2.5
09/19/2018 | Sergio |  | Laureate | 05:57 AM | 07:07:00 |  | 07:58:00 | 15:41:00 |  | 16:22:00 | 04:31 PM |  |  | 6
09/20/2018 | Sergio |  | lake minneola | 06:00 AM | 07:17:00 |  | 08:33:00 | 15:07:00 |  | 16:17:00 | 04:22 PM |  |  | 7
09/21/2018 | Sergio |  | [NAME] | 05:57 AM | 07:21:00 |  | 08:46:00 | 15:09:00 |  | 16:15:00 | 03:28 PM | 0:00:00 |  | 2
 | Sergio Total
09/17/2018 | Terrance |  | Terra | 06:11 AM | 06:35:00 |  | 08:13:00 | 11:52:00 |  | 12:45:00 | 02:55 PM | 0:00:00 |  | 4.5 | 1
09/18/2018 | Terrance |  | Del Webb | 06:08 AM |  | 0:00:00 |  |  |  |  |  |  |  | 2
09/18/2018 | Terrance |  | Samoy |  |  |  |  |  |  |  | 01:32 PM | 0:00:00 |  | 2
09/20/2018 | Terrance |  | [NAME] | 06:36 AM | 07:13:00 |  | 09:06:00 | 11:33:00 |  | 15:33:00 | 05:00 PM |  |  | 3
09/21/2018 | Terrance |  | Montevilla | 06:06 AM | 06:36:00 |  | 09:40:00 | 11:55:00 |  | 13:36:00 | 01:47 PM |  |  | 2.5
 | Terrance Total
09/16/2018 | [NAME] |  |  | 05:41 PM | 18:13:00 |  | 19:21:00 | 06:40:00 |  | 07:19:00 | 07:37 AM
09/17/2018 | [NAME] |  |  | 05:37 PM | 17:51:00 |  | 19:02:00 | 08:05:00 |  | 08:47:00 | 09:02 AM
09/18/2018 | [NAME] |  | Walmart | 06:28 PM | 19:01:00 |  | 23:25:00 | 08:00:00 |  | 08:17:00 | 09:11 AM |  |  | 24
09/19/2018 | [NAME] |  |  | 05:16 PM | 17:34:00 |  | 18:19:00 |  |  |  | 09:21 AM | 0:00:00
09/20/2018 | [NAME] |  |  | 04:49 PM |  | 0:00:00 |  |  |  |  | 0
09/21/2018 | [NAME] |  |  | 11:15 AM |  | 0:00:00 |  |  |  |  | 0
 | [NAME]
09/17/2018 | Willie |  | Renovation | 05:59 AM | 06:47:00 |  | 07:10:00 | 07:30:00 |  |  |  |  |  | 3
09/17/2018 | Willie |  | Laureate |  |  |  | 09:11:00 | 15:55:00 |  | 16:24:00 | 04:28 PM |  |  | 4
09/18/2018 | Willie |  | Laureate | 06:00 AM | 07:52:00 |  | 09:08:00 | 15:33:00 |  | 16:15:00 | 04:15 PM |  |  | 8
09/20/2018 | Willie |  |  | 06:00 AM |  | 0:00:00 |  |  |  |  | 06:01 AM | 0:00:00 |  |  | 1
09/21/2018 | Willie |  | Montevilla | 06:00 AM |  | 0:00:00 |  |  |  |  | 02:02 PM | 0:00:00 |  | 4
 | Willie Total
09/17/2018 | Zachary |  | lake Nona | 05:55 AM | 06:30:00 |  | 07:44:00 | 13:50:00 |  | 14:27:00 | 02:36 PM |  |  | 4 | 1
09/18/2018 | Zachary |  | Bent | 05:52 AM | 06:27:00 |  | 07:33:00 | 09:22:00 |  |  |  |  |  | 2.5
09/18/2018 | Zachary |  | Laureate |  |  |  | 10:12:00 | 14:36:00 |  | 15:16:00 | 03:26 PM |  |  | 5
09/19/2018 | Zachary |  | Laureate | 05:52 AM | 06:31:00 |  | 07:00:00 | 14:20:00 |  | 14:41:00 | 03:11 PM |  |  | 6
09/21/2018 | Zachary |  | Shop | 05:53 AM |  | 0:00:00 |  |  |  |  | 09:25 AM | 0:00:00
 | Zachary Total
09/17/2018 | Nick |  | lake Nona | 05:57:00 | 06:30:00 |  | 07:44:00 | 13:50:00 |  | 14:27:00 | 14:54:00 |  |  | 4
09/18/2018 | Nick |  | Bent | 05:59:00 | 06:27:00 |  | 07:33:00 | 09:22:00 |  |  |  |  |  | 2.5
09/18/2018 | Nick |  | Laureate |  |  |  | 10:12:00 | 14:36:00 |  | 15:16:00 | 15:30:00 |  |  | 5
09/19/2018 | Nick |  | Laureate | 06:02:00 | 06:31:00 |  | 07:00:00 | 14:20:00 |  | 14:41:00 | 15:19:00 |  |  | 7
2018-09-20 00:00:00 | Nick |  | Champions | 06:01:00 | 06:16:00 |  | 07:13:00 | 12:17:00 |  | 13:28:00 | 14:41:00 | 0:00:00 |  | 5
 | Nick Total
09/17/2018 | [NAME] |  | Renovation | 06:03:00 | 06:47:00 |  | 07:10:00 | 07:30:00 |  |  |  |  |  | 3
09/17/2018 | [NAME] |  | Laureate |  |  |  | 09:11:00 | 15:55:00 |  | 16:24:00 | 17:02:00 |  |  | 5
09/18/2018 | [NAME] |  | Laureate | 06:02:00 | 07:52:00 |  | 09:08:00 | 15:33:00 |  | 16:15:00 | 17:09:00 |  |  | 8
09/19/2018 | [NAME] |  | Laureate | 06:04:00 | 07:07:00 |  | 07:58:00 | 15:41:00 |  | 16:22:00 | 16:50:00 |  |  | 7
2018-09-20 00:00:00 | [NAME] |  | lake minneola | 06:03:00 | 07:17:00 |  | 08:33:00 | 15:07:00 |  | 16:17:00 | 16:43:00 |  |  | 7
2018-09-21 00:00:00 | [NAME] |  | Montevilla | 05:58:00 | 06:33:00 |  | 08:42:00 | 12:13:00 |  | 13:58:00 | 17:46:00 | 0:00:00 |  | 4
 | [NAME]