Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 10282018-11032018

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
10/28/2018 | [NAME] |  | Target | 06:24 PM | 19:07:00 |  | 20:26:00 | 01:17:00 |  | 02:17:00 | 03:11 AM
10/29/2018 | [NAME] |  | pilot travel | 03:02 PM | 16:09:00 |  | 22:42:00 | 02:01:00 |  | 04:54:00 | 05:32 AM
10/30/2018 | [NAME] |  | Target | 07:04 PM | 19:29:00 | 0:00:00 | 19:39:00 | 04:54:00 |  | 05:53:00 | 06:12 AM
10/31/2018 | [NAME] |  | Target | 06:56 PM | 19:03:00 | 0:00:00 | 19:12:00 | 03:55:00 |  | 05:59:00 | 06:58 AM |  |  | 40
11/01/2018 | [NAME] |  | Target | 04:48 PM | 19:31:00 |  | 19:35:00 | 00:48:00 |  | 02:21:00 | 02:38 AM
 | Allen Total
10/28/2018 | Alonzo |  | Walmart | 06:58 PM | 19:44:00 |  | 21:46:00 | 03:09:00 |  | 04:37:00 | 04:38 AM
10/29/2018 | Alonzo |  | walmart | 06:04 PM | 18:43:00 |  | 21:19:00 | 03:49:00 |  | 05:10:00 | 05:19 AM
10/31/2018 | Alonzo |  | Walmart | 06:08 PM |  | 0:00:00 |  |  |  |  | 06:33 PM | 0:00:00 |  | 40 | 1
10/31/2018 | Alonzo |  |  | 08:05 PM | 20:08:00 |  | 21:09:00 | 03:48:00 |  | 04:51:00 | 04:58 AM
11/01/2018 | Alonzo |  | Walmart | 07:51 PM | 20:22:00 |  | 21:28:00 | 03:05:00 |  | 03:24:00 | 03:35 AM
 | Alonzo Total
10/29/2018 | [NAME] | 1 | [NAME] | 06:40 AM | 07:03:00 |  | 08:26:00 | 13:35:00 |  | 13:41:00 | 02:27 PM |  |  | 6
10/30/2018 | [NAME] | 1 | landing bay | 06:00 AM | 06:28:00 |  | 07:27:00 | 15:28:00 |  | 15:58:00 | 04:07 PM |  |  | 2
10/31/2018 | [NAME] | 1 | Pilot Zoo | 06:08 AM |  | 0:00:00 |  |  |  |  | 08:14 PM | 0:00:00 |  | 4
11/01/2018 | [NAME] | 1 | East Tract | 06:17 AM | 07:50:00 |  | 07:26:00 | 15:31:00 |  | 16:09:00 | 04:17 PM |  |  | 4
11/02/2018 | [NAME] | 1 | New Independece | 06:02 AM |  | 0:00:00 |  |  |  |  | 03:27 PM | 0:00:00 |  | 4
 | Benjamin Total
10/29/2018 | [NAME] |  | New Independece | 06:09 AM | 07:37:00 |  | 09:01:00 | 14:48:00 |  | 15:28:00 | 03:32 PM |  |  | 7
10/30/2018 | [NAME] |  | Orlando Health | 06:03 AM | 06:23:00 |  | 07:51:00 | 13:07:00 |  | 13:52:00 | 02:14 PM |  |  | 7
10/31/2018 | [NAME] |  | Orlando Health | 06:00 AM | 06:42:00 |  | 07:51:00 | 11:56:00 |  | 12:41:00 | 01:11 PM |  |  | 7
11/01/2018 | [NAME] |  | landing bay | 06:01 AM | 07:15:00 |  | 08:25:00 | 10:35:00 |  |  |  |  |  | 2
11/01/2018 | [NAME] |  | East Tract |  |  |  | 11:05:00 | 14:43:00 |  | 16:06:00 | 04:16 PM |  |  | 1
11/02/2018 | [NAME] | 6 | New Independece | 06:01 AM | 09:18:00 |  | 09:57:00 | 14:12:00 |  | 14:55:00 | 03:40 PM |  |  | 6
 | [NAME]
10/28/2018 | [NAME] |  | Walmart | 07:09 PM | 19:31:00 |  | 21:51:00 | 05:00:00 |  | 07:00:00 | 07:22 AM
10/29/2018 | [NAME] |  | walmart | 06:09 PM | 18:43:00 |  | 21:19:00 | 03:49:00 |  | 05:10:00 | 05:15 AM |  |  | 40
10/30/2018 | [NAME] |  | walmart 2 | 06:15 PM | 19:05:00 |  | 20:13:00 | 06:47:00 |  | 08:53:00 | 09:17 AM
10/31/2018 | [NAME] |  | Walmart | 08:00 PM | 20:08:00 |  | 21:09:00 | 03:48:00 |  | 04:51:00 | 04:55 AM
11/01/2018 | [NAME] |  | Walmart | 08:03 PM | 20:22:00 |  | 21:28:00 | 03:05:00 |  | 03:24:00 | 03:29 AM
 | Brandon Total
10/31/2018 | [NAME] |  | Lake Dexter | 05:50 AM | 08:49:00 |  | 10:18:00 | 16:03:00 |  | 17:13:00 | 05:12 PM | 0:00:00 |  | 7
11/01/2018 | [NAME] |  | Pilot Zoo | 06:00 AM | 07:03:00 |  | 09:43:00 | 13:35:00 |  | 15:53:00 | 04:03 PM |  |  | 5
11/02/2018 | [NAME] |  | Princeton | 05:50 AM | 06:27:00 |  | 08:31:00 | 13:13:00 |  | 14:22:00 | 02:45 PM |  |  | 6
 | DeAndre Total
10/29/2018 | Dwayne | 10 | East Landstreet | 06:40 AM | 07:13:00 |  | 10:10:00 | 11:33:00 |  | 13:32:00 | 01:32 PM |  |  | 7
10/30/2018 | Dwayne | 10 | Orlando Health | 05:43 AM | 06:23:00 |  | 07:51:00 | 13:07:00 |  | 13:52:00 | 03:07 PM |  |  | 7
10/31/2018 | Dwayne | 10 | Orlando Health | 05:46 AM | 06:42:00 |  | 07:51:00 | 11:56:00 |  | 12:41:00 | 01:12 PM |  |  | 7 | 1
11/02/2018 | Dwayne | 10 | Princeton | 06:00 AM | 06:27:00 |  | 08:31:00 | 13:13:00 |  | 14:22:00 | 03:00 PM |  |  | 6
 | [NAME]
10/29/2018 | Edgar | 2 | East Landstreet | 05:59 AM | 06:25:00 |  | 07:28:00 | 12:30:00 |  | 13:12:00 | 01:42 PM |  |  | 7
10/30/2018 | Edgar | 2 | Landstreet | 05:59 AM | 06:26:00 |  | 07:12:00 | 15:32:00 |  | 16:13:00 | 04:30 PM |  |  | 7
10/31/2018 | Edgar | 2 | champions | 06:00 AM | 06:52:00 |  | 08:20:00 | 09:11:00 |  |  |  |  |  | 8
10/31/2018 | Edgar |  | UPS |  |  |  | 09:16:00 | 15:00:00 |  | 15:47:00 | 04:30 PM |  |  | 4
11/01/2018 | Edgar | 2 | East Tract | 06:07 AM | 06:22:00 |  | 07:14:00 | 14:55:00 |  | 16:08:00 | 04:24 PM |  |  | 6
11/02/2018 | Edgar | 2 | East Landstreet | 06:00 AM | 06:30:00 |  | 07:14:00 | 12:08:00 |  |  |  |  |  | 2
11/02/2018 | Edgar |  | Spring Isle |  |  |  | 12:26:00 | 13:52:00 |  | 14:30:00 | 03:46 PM |  |  | 2
 | [NAME]
10/28/2018 | Efrain |  | Walmart | 06:55 PM | 19:44:00 |  | 21:46:00 | 03:09:00 |  | 04:37:00 | 04:38 AM
10/29/2018 | Efrain |  | walmart | 05:10 PM | 18:43:00 |  | 21:19:00 | 03:49:00 |  | 05:10:00 | 05:19 AM |  |  | 40
10/30/2018 | Efrain |  | walmart | 06:10 PM | 19:05:00 |  | 20:13:00 | 06:47:00 |  | 08:53:00 | 08:09 AM | 0:00:00
10/31/2018 | Efrain |  | Walmart | 09:55 PM | 20:08:00 | 0:00:00 | 21:09:00 | 03:48:00 |  | 04:51:00 | 04:20 AM | 0:00:00
 | Efrain Total
10/28/2018 | [NAME] |  | Walmart 1 | 07:52 PM | 19:12:00 | 0:00:00 | 00:19:00 | 06:02:00 |  | 07:59:00 | 08:14 AM
10/29/2018 | [NAME] |  | Walmart 2 | 06:07 PM | 18:23:00 |  |  |  |  |  | 12:45 PM | 0:00:00
10/30/2018 | [NAME] |  | Walmart 3 | 08:26 PM | 18:47:00 | 0:00:00 | 19:57:00 | 06:27:00 |  | 07:55:00 | 09:17 AM | 0:00:00
10/31/2018 | [NAME] |  | Walmart 3 | 09:26 PM | 18:38:00 | 0:00:00 | 20:50:00 | 05:52:00 |  | 07:23:00 | 09:01 AM | 0:00:00
11/01/2018 | [NAME] |  | Walmart 4 | 06:37 PM | 18:28:00 | 0:00:00 | 21:36:00 | 03:16:00 |  | 07:21:00 | 09:30 AM | 0:00:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 31
10/29/2018 | [NAME] | 2 | East Landstreet | 05:46 AM | 06:25:00 |  | 07:28:00 | 12:30:00 |  | 13:12:00 | 01:43 PM |  |  | 7
10/30/2018 | [NAME] |  | Landstreet | 05:57 AM | 06:26:00 |  | 07:12:00 | 15:32:00 |  | 16:13:00 | 04:23 PM |  |  | 7
10/31/2018 | [NAME] |  | champions | 05:59 AM | 06:52:00 |  | 08:20:00 | 09:11:00 |  |  |  |  |  | 8
10/31/2018 | [NAME] |  | UPS |  |  |  | 09:16:00 | 15:00:00 |  | 15:47:00 | 03:53 PM |  |  | 4
11/01/2018 | [NAME] |  | East Tract | 05:56 AM | 06:22:00 |  | 07:14:00 | 14:55:00 |  | 16:08:00 | 04:19 PM |  |  | 6
11/02/2018 | [NAME] |  | East Landstreet | 05:58 AM | 06:30:00 |  | 07:14:00 | 12:08:00 |  |  |  |  |  | 2
11/02/2018 | [NAME] |  | Spring Isle |  |  |  | 12:26:00 | 13:52:00 |  | 14:30:00 | 03:02 PM |  |  | 2
 | [NAME]
10/28/2018 | [NAME] |  | Walmart 1 | 05:28 PM | 19:12:00 |  | 00:19:00 | 06:02:00 |  | 07:59:00 | 09:15 AM | 0:00:00
10/29/2018 | [NAME] |  | Walmart 2 | 05:44 PM | 18:23:00 |  |  |  |  |  | 09:17 AM | 0:00:00
10/30/2018 | [NAME] |  | Walmart 3 | 05:51 PM | 18:47:00 |  | 19:57:00 | 06:27:00 |  | 07:55:00 | 09:02 AM
10/31/2018 | [NAME] |  | Walmart 3 | 04:20 PM | 18:38:00 |  | 20:50:00 | 05:52:00 |  | 07:23:00 | 08:12 AM
11/01/2018 | [NAME] |  | Walmart 4 | 05:49 PM | 18:28:00 |  | 21:36:00 | 03:16:00 |  | 07:21:00 | 08:30 AM
 | Patrick Total |  |  |  |  |  |  |  |  |  |  |  |  | 31
10/29/2018 | [NAME] |  | Walmart 2 | 05:59 PM | 19:12:00 |  | 00:19:00 | 06:02:00 |  | 07:59:00 | 08:06 AM
10/30/2018 | [NAME] |  | Walmart 3 | 05:57 PM | 18:23:00 |  |  |  |  |  | 08:04 AM | 0:00:00 |  |  | 1
10/31/2018 | [NAME] |  | Walmart 3 | 05:59 PM | 18:47:00 |  | 19:57:00 | 06:27:00 |  | 07:55:00 | 07:32 AM | 0:00:00
11/01/2018 | [NAME] |  | Walmart 4 | 06:11 PM | 18:38:00 |  | 20:50:00 | 05:52:00 |  | 07:23:00 | 07:24 AM
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 26
10/28/2018 | [NAME] |  | walmart | 07:09 PM | 18:28:00 | 0:00:00 | 21:36:00 | 03:16:00 |  | 07:21:00 | 07:22 AM
10/29/2018 | [NAME] |  | walmart | 06:10 PM | 18:43:00 |  | 21:19:00 | 03:49:00 |  | 05:10:00 | 05:15 AM |  |  | 40
10/30/2018 | [NAME] |  | Walmart 2 | 06:14 PM | 19:05:00 |  | 20:13:00 | 06:47:00 |  | 08:53:00 | 09:14 AM
10/31/2018 | [NAME] |  | Walmart | 08:01 PM | 20:08:00 |  | 21:09:00 | 03:48:00 |  | 04:51:00 | 04:56 AM
11/01/2018 | [NAME] |  | Walmart | 08:03 PM | 20:22:00 |  | 21:28:00 | 03:05:00 |  | 03:24:00 | 03:29 AM
 | Rocco Total
10/29/2018 | Sergio |  | [NAME] | 05:58 AM | 07:03:00 |  | 08:26:00 | 13:35:00 |  | 13:41:00 | 02:27 PM |  |  | 6
10/30/2018 | Sergio |  | landing bay | 05:57 AM | 06:28:00 |  | 07:27:00 | 15:28:00 |  | 15:58:00 | 04:12 PM |  |  | 2
10/31/2018 | Sergio |  | Pilot Zoo | 05:59 AM |  | 0:00:00 |  |  |  |  | 08:14 PM | 0:00:00 |  | 4
11/01/2018 | Sergio |  | East Tract | 05:58 AM | 07:50:00 |  | 07:26:00 | 15:31:00 |  | 16:09:00 | 04:29 PM |  |  | 4
11/02/2018 | Sergio |  | New Independece | 05:59 AM |  | 0:00:00 |  |  |  |  | 03:00 PM | 0:00:00 |  | 4
 | Sergio Total
10/29/2018 | Terrance | 6 | New Independece | 06:15 AM | 07:37:00 |  | 09:01:00 | 14:48:00 |  | 15:28:00 | 03:41 PM |  |  | 7
10/30/2018 | Terrance | 6 | Gate 1421 | 06:04 AM | 07:05:00 |  | 09:58:00 | 13:30:00 |  | 15:41:00 | 03:59 PM |  |  | 2
10/31/2018 | Terrance | 6 | Pilot Zoo | 06:08 AM | 08:05:00 |  | 10:26:00 | 15:47:00 |  | 17:05:00 | 05:47 PM |  |  | 7
11/01/2018 | Terrance | 6 | landing bay | 06:14 AM | 07:15:00 |  | 08:25:00 | 10:35:00 |  |  |  |  |  | 2
11/01/2018 | Terrance |  | East Tract |  |  |  | 11:05:00 | 14:43:00 |  | 16:06:00 | 02:06 PM | 0:00:00 |  | 1
11/02/2018 | Terrance | 1 | New Independece | 06:23 AM | 07:22:00 |  | 09:08:00 | 14:31:00 |  | 15:32:00 | 03:40 PM |  |  | 6
 | Terrance Total
10/29/2018 | Willie | 7 | Cheddars | 05:59 AM |  | 0:00:00 |  |  |  |  | 01:37 PM | 0:00:00 |  | 7
10/30/2018 | Willie |  | champions | 06:00 AM | 06:59:00 |  | 08:45:00 | 09:29:00 |  |  |  |  |  | 8
10/30/2018 | Willie |  | Orlando Health |  |  |  | 09:39:00 | 11:35:00 |  | 13:10:00 | 13:21:00 |  |  | 4
10/31/2018 | Willie |  | Lake Dexter | 06:02 AM | 08:49:00 |  | 10:18:00 | 16:03:00 |  | 17:13:00 | 05:11 PM | 0:00:00 |  | 7
11/01/2018 | Willie |  | Shop | 05:59 AM |  | 0:00:00 |  |  |  |  | 09:19 AM | 0:00:00
 | Willie Total
10/28/2018 | Zachary |  | Walmart 1 | 05:39 PM | 19:06:00 |  | 21:15:00 | 06:41:00 |  | 07:48:00 | 07:53 AM
10/29/2018 | Zachary |  | Walmart 2 | 05:42 PM | 18:20:00 |  | 20:29:00 | 06:55:00 |  | 08:01:00 | 08:06 AM
10/30/2018 | Zachary |  | Walmart 3 | 06:01 PM | 18:48:00 |  | 20:53:00 | 05:39:00 |  | 07:54:00 | 07:58 AM
10/31/2018 | Zachary |  | Walmart 3 | 05:43 PM | 18:39:00 |  | 20:50:00 | 05:21:00 |  | 07:23:00 | 07:31 AM
11/01/2018 | Zachary |  | Walmart 4 | 05:43 PM | 18:27:00 |  | 19:51:00 | 04:18:00 |  | 06:09:00 | 06:18 AM
 | Zachary Total |  |  |  |  |  |  |  |  |  |  |  |  | 46
10/28/2018 | Nick |  | Walmart 1 | 17:02:00 | 19:06:00 |  | 21:15:00 | 06:41:00 |  | 07:48:00 | 08:00:00
10/29/2018 | Nick |  | Walmart 2 | 17:42:00 | 18:20:00 |  | 20:29:00 | 06:55:00 |  | 08:01:00 | 08:09:00
10/30/2018 | Nick |  | Walmart 3 | 17:16:00 | 18:48:00 |  | 20:53:00 | 05:39:00 |  | 07:54:00 | 08:04:00
10/31/2018 | Nick |  | Walmart 3 | 16:50:00 | 18:39:00 |  | 20:50:00 | 05:21:00 |  | 07:23:00 | 07:31:00
11/01/2018 | Nick |  | Walmart 4 | 17:40:00 | 18:27:00 |  | 19:51:00 | 04:18:00 |  | 06:09:00 | 06:28:00
 | Nick Total |  |  |  |  |  |  |  |  |  |  |  |  | 46
10/28/2018 | [NAME] |  | ? | 05:58:00 |  | 0:00:00 |  |  |  |  | 15:30:00 | 0:00:00
10/29/2018 | [NAME] | 7 | Cheddars | 06:03:00 |  | 0:00:00 |  |  |  |  | 16:21:00 | 0:00:00 |  | 7
10/30/2018 | [NAME] |  | Champions | 05:56:00 | 06:59:00 |  | 08:45:00 | 09:29:00 |  |  |  |  |  | 8
10/30/2018 | [NAME] | 15 | Orlando Health |  |  |  | 09:39:00 | 11:35:00 |  | 13:10:00 | 17:23:00 | 0:00:00 |  | 4
10/31/2018 | [NAME] | 8 | Lake Dexter | 06:05:00 | 08:49:00 |  | 10:18:00 | 16:03:00 |  | 17:13:00 | 17:20:00 |  |  | 7
11/01/2018 | [NAME] | 10 | Pilot Zoo | 06:01:00 | 07:03:00 |  | 09:43:00 | 13:35:00 |  | 15:53:00 | 16:00:00 |  |  | 5
11/02/2018 | [NAME] |  | Somerset | 06:00:00 | 07:40:00 |  | 09:25:00 | 10:25:00 |  |  |  |  |  | 2.5
11/02/2018 | [NAME] | 15 | New Independece |  |  |  | 10:49:00 | 14:33:00 |  | 15:30:00 | 16:00:00 |  |  | 5
 | [NAME]