Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 11042018-11102018

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
11/04/2018 | [NAME] |  |  | 06:26 PM | 18:40:00 |  | 19:20:00 | 21:13:00 |  | 21:35:00 | 09:51 PM
11/05/2018 | [NAME] |  | Target | 11:26 AM | 11:33:00 |  |  |  |  | 12:18:00 | 12:44 PM
11/05/2018 | [NAME] |  |  | 06:24 PM | 20:11:00 |  | 20:45:00 | 02:34:00 |  | 02:57:00 | 03:35 AM
11/07/2018 | [NAME] |  |  | 06:43 AM | 07:24:00 |  | 07:36:00 | 15:37:00 |  | 16:11:00 | 04:37 PM
11/08/2018 | [NAME] |  |  | 06:49 AM | 07:26:00 |  | 07:53:00 | 14:11:00 |  | 14:44:00 | 03:43 PM |  |  | 41
11/09/2018 | [NAME] |  |  | 07:09 AM | 07:50:00 |  | 08:06:00 | 15:23:00 |  | 15:53:00 | 04:05 PM
 | Allen Total
11/04/2018 | Alonzo |  |  | 08:07 PM |  | 0:00:00 |  |  |  |  | 11:16 PM | 0:00:00
11/05/2018 | Alonzo |  | Walmart | 05:52 PM | 19:30:00 |  | 20:26:00 | 04:42:00 |  | 05:11:00 | 05:17 AM
11/06/2018 | Alonzo |  |  | 07:50 PM | 20:15:00 |  | 21:01:00 | 03:15:00 |  | 03:41:00 | 03:41 AM
11/07/2018 | Alonzo |  |  | 06:50 PM | 19:15:00 |  | 20:20:00 | 03:52:00 |  | 04:15:00 | 04:15 AM
11/08/2018 | Alonzo |  |  | 05:58 PM | 19:03:00 |  | 19:39:00 | 05:08:00 |  | 05:30:00 | 05:48 AM
 | Alonzo Total
11/05/2018 | [NAME] |  | Solo | 06:06 AM | 06:39:00 |  | 09:19:00 | 14:05:00 |  | 14:50:00 | 03:02 PM |  |  | 6
11/06/2018 | [NAME] |  | Oak Trail | 05:51 AM | 06:29:00 |  | 07:37:00 | 11:50:00 |  | 12:09:00 | 12:30 PM |  |  | 3
11/07/2018 | [NAME] |  | Orlando Health | 06:02 AM | 06:49:00 |  | 08:49:00 | 13:53:00 |  | 14:42:00 | 02:55 PM |  |  | 8
11/08/2018 | [NAME] |  | Heritage | 06:00 AM | 06:43:00 |  | 08:06:00 | 14:38:00 |  | 15:16:00 | 03:20 PM |  |  | 8
11/09/2018 | [NAME] |  | Heritage | 06:07 AM | 06:24:00 |  | 07:38:00 | 14:03:00 |  | 14:51:00 | 03:00 PM |  |  | 7
 | Benjamin Total
11/05/2018 | [NAME] |  | Reunion apts | 06:00 AM | 06:45:00 |  | 08:25:00 | 14:29:00 |  | 15:19:00 | 03:32 PM |  |  | 4
11/06/2018 | [NAME] |  | New Independence | 06:14 AM | 06:52:00 |  | 08:18:00 | 15:44:00 |  | 16:37:00 | 04:44 PM |  |  | 6 | 1
11/07/2018 | [NAME] |  | Orlando Health | 06:01 AM | 06:49:00 |  | 08:55:00 | 13:55:00 |  | 14:35:00 | 02:47 PM |  |  | 8
11/08/2018 | [NAME] |  | Shingle | 06:13 AM | 07:04:00 |  | 08:40:00 | 15:46:00 |  | 16:53:00 | 05:10 PM |  |  | 3
 | [NAME]
11/04/2018 | [NAME] |  |  | 08:07 PM | 20:49:00 |  | 22:16:00 | 22:30:00 |  | 23:10:00 | 11:18 PM
11/05/2018 | [NAME] |  | Walmart | 08:02 PM | 20:14:00 |  | 21:00:00 | 04:30:00 |  | 04:57:00 | 05:02 AM
11/06/2018 | [NAME] |  | Walmart  2 | 05:59 PM | 18:48:00 |  | 21:00:00 | 04:00:00 |  | 04:55:00 | 05:02 AM
11/07/2018 | [NAME] |  |  | 06:03 PM | 18:33:00 |  | 20:19:00 | 22:19:00 |  | 22:53:00 | 11:04 PM
11/08/2018 | [NAME] |  |  | 06:04 PM | 18:48:00 |  | 19:53:00 | 05:10:00 |  | 05:28:00 | 05:51 AM
 | Brandon Total
11/05/2018 | [NAME] |  | Reunion apts | 06:00 AM | 06:29:00 |  | 08:03:00 | 14:29:00 |  | 15:19:00 | 03:31 PM |  |  | 6
11/06/2018 | [NAME] |  | Princeton | 05:56 AM | 06:26:00 |  | 08:24:00 | 13:14:00 |  | 14:33:00 | 03:11 PM |  |  | 6
11/07/2018 | [NAME] |  | Maschmeyer | 05:53 AM | 06:23:00 |  | 08:19:00 | 11:08:00 |  |  |  |  |  | 4
11/07/2018 | [NAME] |  | [NAME] |  |  |  | 11:53:00 | 14:13:00 |  | 14:41:00 | 02:54 PM |  |  | 2
11/08/2018 | [NAME] |  | Princeton | 05:58 AM | 06:19:00 |  | 06:59:00 | 12:43:00 |  | 13:57:00 | 02:54 PM |  |  | 6
11/09/2018 | [NAME] |  | [NAME] | 05:18 AM | 05:15:00 | 0:00:00 | 05:43:00 | 08:44:00 |  |  |  |  |  | 2
11/09/2018 | [NAME] |  | east tract |  |  |  | 08:52:00 | 14:40:00 |  | 15:14:00 | 03:39 PM |  |  | 5
 | DeAndre Total
11/05/2018 | Dwayne |  | Reunion apts | 06:00 AM | 06:29:00 |  | 08:03:00 | 14:29:00 |  | 15:19:00 | 03:36 PM |  |  | 6
11/06/2018 | Dwayne |  | Princeton | 06:00 AM | 06:26:00 |  | 08:24:00 | 13:14:00 |  | 14:33:00 | 03:00 PM |  |  | 6
11/07/2018 | Dwayne |  | Maschmeyer | 06:00 AM | 06:23:00 |  | 08:19:00 | 11:08:00 |  |  |  |  |  | 4
11/07/2018 | Dwayne |  | [NAME] |  |  |  | 11:53:00 | 14:13:00 |  | 14:41:00 | 03:00 PM |  |  | 2
11/08/2018 | Dwayne |  | Princeton | 05:55 AM | 06:19:00 |  | 06:59:00 | 12:43:00 |  | 13:57:00 | 02:31 PM |  |  | 6
11/09/2018 | Dwayne |  | [NAME] | 04:43 AM | 05:15:00 |  | 05:43:00 | 08:44:00 |  |  |  |  |  | 2
11/09/2018 | Dwayne |  | east tract |  |  |  | 08:52:00 | 14:40:00 |  | 15:14:00 | 03:31 PM |  |  | 5
 | [NAME]
11/05/2018 | Edgar |  | Reunion apts | 05:57 AM | 06:26:00 |  | 07:14:00 | 08:42:00 |  |  |  |  |  | 4
11/05/2018 | Edgar |  | Spring Isle |  |  |  | 09:09:00 | 09:59:00 |  |  |  |  |  | 1
11/05/2018 | Edgar |  | East land |  |  |  | 10:50:00 | 14:37:00 |  | 15:37:00 | 03:50 PM |  |  | 2
11/06/2018 | Edgar |  | Del Webb | 05:56 AM | 06:28:00 |  | 08:07:00 | 15:44:00 |  | 16:51:00 | 05:00 PM |  |  | 3
11/07/2018 | Edgar |  | Orlando Health | 05:56 AM | 06:49:00 |  | 08:19:00 | 16:44:00 |  | 18:27:00 | 07:01 PM |  |  | 8
11/08/2018 | Edgar |  | Orlando Health | 05:59 AM | 06:14:00 |  | 07:33:00 | 16:34:00 |  | 17:38:00 | 05:42 PM |  |  | 4
11/09/2018 | Edgar |  | Emerald Island | 05:56 AM | 06:35:00 |  | 07:59:00 | 15:31:00 |  | 16:41:00 | 04:59 PM |  |  | 7
 | [NAME]
11/04/2018 | Efrain |  |  | 09:45 PM |  | 0:00:00 |  |  |  |  | 11:16 PM | 0:00:00
11/05/2018 | Efrain |  | Walmart | 06:30 PM | 19:30:00 |  | 20:26:00 | 04:42:00 |  | 05:11:00 | 05:17 AM
11/06/2018 | Efrain |  |  | 07:30 PM | 20:15:00 |  | 21:01:00 | 03:15:00 |  | 03:41:00 | 03:41 AM |  |  | 40
11/07/2018 | Efrain |  |  | 07:00 PM | 19:15:00 |  | 20:20:00 | 03:52:00 |  | 04:15:00 | 04:15 AM
11/08/2018 | Efrain |  |  | 06:30 PM | 19:03:00 |  | 19:39:00 | 05:08:00 |  | 05:30:00 | 05:50 AM
11/09/2018 | Efrain |  |  | 04:00 PM |  | 0:00:00 |  |  |  |  | 06:01 PM | 0:00:00
 | Efrain Total
11/04/2018 | [NAME] |  | Walmart 1 | 05:31 PM | 17:58:00 |  | 20:07:00 | 05:11:00 |  | 07:43:00 | 10:21 AM
11/05/2018 | [NAME] |  | Walmart 2 | 06:21 PM | 18:40:00 |  | 20:34:00 | 07:03:00 |  | 08:10:00 | 10:31 AM | 0:00:00
11/06/2018 | [NAME] |  | Walmart 3 | 06:00 PM | 18:58:00 |  | 21:07:00 | 07:01:00 |  | 09:09:00 | 07:12 AM | 0:00:00
11/07/2018 | [NAME] |  | Walmart 4 | 05:05 PM | 18:22:00 |  | 20:20:00 | 04:22:00 |  | 05:17:00 | 10:22 AM | 0:00:00
11/08/2018 | [NAME] |  |  | 08:23 PM |  | 0:00:00 |  |  |  |  | 07:35 AM | 0:00:00
 | [NAME]
11/05/2018 | [NAME] |  | Reunion apts | 06:01 AM | 06:26:00 |  | 07:14:00 | 08:42:00 |  |  |  |  |  | 4
11/05/2018 | [NAME] |  | Spring Isle |  |  |  | 09:09:00 | 09:59:00 |  |  |  |  |  | 1
11/05/2018 | [NAME] |  | East land |  |  |  | 10:50:00 | 14:37:00 |  | 15:37:00 | 03:48 PM |  |  | 2
11/06/2018 | [NAME] |  | Del Webb | 05:58 AM | 06:28:00 |  | 08:07:00 | 15:44:00 |  | 16:51:00 | 04:58 PM |  |  | 3
11/07/2018 | [NAME] |  | Orlando Health | 07:16 AM | 06:49:00 |  | 08:19:00 | 16:44:00 |  | 18:27:00 | 06:32 PM |  |  | 8
11/08/2018 | [NAME] |  | Orlando Health | 05:57 AM | 06:14:00 |  | 07:33:00 | 16:34:00 |  | 17:38:00 | 05:41 PM |  |  | 4
11/09/2018 | [NAME] |  | Emerald Island | 05:59 AM | 06:35:00 |  | 07:59:00 | 15:31:00 |  | 16:41:00 | 04:44 PM |  |  | 7
 | [NAME]
11/04/2018 | [NAME] |  | Walmart 1 | 05:33 PM | 17:58:00 |  | 20:07:00 | 05:11:00 |  | 07:43:00 | 11:12 AM | 0:00:00
11/05/2018 | [NAME] |  | Walmart 2 | 05:48 PM | 18:40:00 |  | 20:34:00 | 07:03:00 |  | 08:10:00 | 07:33 AM | 0:00:00
11/06/2018 | [NAME] |  | Walmart 3 | 05:12 PM |  | 0:00:00 |  |  |  |  | 07:35 AM | 0:00:00
11/07/2018 | [NAME] |  | Walmart 4 | 06:00 PM | 18:58:00 |  | 21:07:00 | 07:01:00 |  | 09:09:00 | 10:31 AM
11/08/2018 | [NAME] |  |  | 05:50 PM | 18:22:00 |  | 20:20:00 | 04:22:00 |  | 05:17:00 | 07:00 AM
 | Patrick Total
11/04/2018 | [NAME] |  | Walmart 1 | 05:43 PM | 17:58:00 |  | 20:07:00 | 05:11:00 |  | 07:43:00 | 08:46 AM
11/05/2018 | [NAME] |  | Walmart 2 | 05:47 PM | 18:40:00 |  | 20:34:00 | 07:03:00 |  | 08:10:00 | 07:56 AM | 0:00:00
11/07/2018 | [NAME] |  | Walmart 3 | 05:44 PM | 18:58:00 |  | 21:07:00 | 07:01:00 |  | 09:09:00 | 06:09 AM | 0:00:00
11/08/2018 | [NAME] |  | Walmart 4 | 05:57 PM | 18:22:00 |  | 20:20:00 | 04:22:00 |  | 05:17:00 | 05:47 AM
 | [NAME]
11/04/2018 | [NAME] |  |  | 08:07 PM | 20:49:00 |  | 22:16:00 | 22:30:00 |  | 23:10:00 | 11:18 PM
11/05/2018 | [NAME] |  | Walmart | 08:02 PM | 20:14:00 |  | 21:00:00 | 04:30:00 |  | 04:57:00 | 05:02 AM
11/06/2018 | [NAME] |  | Walmart 2 | 06:00 PM | 18:48:00 |  | 21:00:00 | 04:00:00 |  | 04:55:00 | 05:01 AM
11/07/2018 | [NAME] |  |  | 06:04 PM | 18:33:00 |  | 20:19:00 | 22:19:00 |  | 22:53:00 | 11:04 PM
11/08/2018 | [NAME] |  |  | 06:04 PM | 18:48:00 |  | 19:53:00 | 05:10:00 |  | 05:28:00 | 05:33 AM
 | Rocco Total
11/05/2018 | Sergio |  | Solo | 05:58 AM | 06:39:00 |  | 09:19:00 | 14:05:00 |  | 14:50:00 | 02:58 PM |  |  | 6
11/06/2018 | Sergio |  | Oak Trail | 05:58 AM | 06:29:00 |  | 07:37:00 | 11:50:00 |  | 12:09:00 | 12:30 PM |  |  | 3
11/07/2018 | Sergio |  | Orlando Health | 05:57 AM | 06:49:00 |  | 08:49:00 | 13:53:00 |  | 14:42:00 | 02:55 PM |  |  | 8
11/08/2018 | Sergio |  | Heritage | 05:58 AM | 06:43:00 |  | 08:06:00 | 14:38:00 |  | 15:16:00 | 03:20 PM |  |  | 8
11/09/2018 | Sergio |  | Heritage | 05:58 AM | 06:24:00 |  | 07:38:00 | 14:03:00 |  | 14:51:00 | 02:58 PM |  |  | 7
 | Sergio Total
11/06/2018 | Terrance |  | New Independence | 06:12 AM | 06:52:00 |  | 08:18:00 | 15:44:00 |  | 16:37:00 | 04:45 PM |  |  | 6
11/07/2018 | Terrance |  | Orlando Health | 06:12 AM | 06:49:00 |  | 08:55:00 | 13:55:00 |  | 14:35:00 | 02:50 PM |  |  | 8
11/08/2018 | Terrance |  | Shingle | 06:01 AM | 07:04:00 |  | 08:40:00 | 15:46:00 |  | 16:53:00 | 05:06 PM |  |  | 3 | 1
11/09/2018 | Terrance |  | Lake Dexter | 06:00 AM | 06:36:00 |  | 09:08:00 | 16:30:00 |  | 17:15:00 | 05:34 PM |  |  | 5
 | Terrance Total
11/05/2018 | Willie |  | Lake Dexter | 06:00 AM | 06:45:00 |  | 08:22:00 | 10:09:00 |  |  |  |  |  | 5
11/05/2018 | Willie |  | Cypress |  |  |  | 10:26:00 | 12:33:00 |  | 14:01:00 | 02:10 PM |  |  | 4
11/06/2018 | Willie |  | Winter Springs apt | 05:57 AM | 06:42:00 |  | 07:19:00 | 07:52:00 |  |  |  |  |  | 1
11/06/2018 | Willie |  | New Independence |  |  |  | 09:08:00 | 09:48:00 |  | 09:59:00 | 11:48 AM |  |  | 4
11/07/2018 | Willie |  | Maschmeyer | 05:54 AM | 06:23:00 |  | 08:19:00 | 11:08:00 |  | 11:45:00 | 11:57 AM |  |  | 4
11/08/2018 | Willie |  | Shingle | 05:58 AM | 06:16:00 |  | 09:00:00 | 12:47:00 |  |  |  |  |  | 4
11/08/2018 | Willie |  | Lake Dexter |  | 06:36:00 |  | 09:08:00 | 16:30:00 |  | 17:15:00 | 05:38 PM |  |  | 4
 | Willie Total
11/04/2018 | Zachary |  | Walmart 1 | 05:35 PM | 17:58:00 |  | 20:07:00 | 05:11:00 |  | 07:43:00 | 07:50 AM
11/05/2018 | Zachary |  | Walmart 2 | 05:45 PM | 18:40:00 |  | 20:34:00 | 07:03:00 |  | 08:10:00 | 08:13 AM
11/07/2018 | Zachary |  | Walmart 3 | 05:58 PM | 18:58:00 |  | 21:07:00 | 07:01:00 |  | 09:09:00 | 09:13 AM
11/08/2018 | Zachary |  | Walmart 4 | 05:53 PM | 18:22:00 |  | 20:20:00 | 04:22:00 |  | 05:17:00 | 05:19 AM
 | Zachary Total
11/04/2018 | Nick |  | Walmart 1 | 16:56:00 | 17:58:00 |  | 20:07:00 | 05:11:00 |  | 07:43:00 | 07:49:00
11/05/2018 | Nick |  | Walmart 2 | 17:24:00 | 18:40:00 |  | 20:34:00 | 07:03:00 |  | 08:10:00 | 08:14:00 |  |  | 1
11/07/2018 | Nick |  | Walmart 3 | 17:31:00 | 18:58:00 |  | 21:07:00 | 07:01:00 |  | 09:09:00 | 09:16:00
11/08/2018 | Nick |  | Walmart 4 | 17:55:00 | 18:22:00 |  | 20:20:00 | 04:22:00 |  | 05:17:00 | 05:21:00
 | Nick Total
11/05/2018 | [NAME] |  | Lake Dexter | 05:59:00 | 06:45:00 |  | 08:22:00 | 10:09:00 |  |  |  |  |  | 5
11/05/2018 | [NAME] |  | Cypress |  |  |  | 10:26:00 | 12:33:00 |  | 14:01:00 | 16:14:00 | 0:00:00 |  | 4
11/06/2018 | [NAME] |  | Winter Springs apt | 05:56:00 | 06:42:00 |  | 07:19:00 | 07:52:00 |  |  |  |  |  | 1
11/06/2018 | [NAME] |  | New Independence |  |  |  | 09:08:00 | 09:48:00 |  | 09:59:00 | 16:05:00 | 0:00:00 |  | 4
11/08/2018 | [NAME] |  | Shingle | 06:00:00 | 06:16:00 |  | 09:00:00 | 12:47:00 |  |  |  |  |  | 4
11/08/2018 | [NAME] |  | Lake Dexter |  |  |  | 13:00:00 | 16:30:00 |  | 17:30:00 | 17:40:00 |  |  | 4
11/09/2018 | [NAME] |  | Lake Dexter | 06:03:00 | 06:36:00 |  | 09:08:00 | 16:30:00 |  | 17:15:00 | 17:32:00 |  |  | 5
 | [NAME]