Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 10212018-10272018

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/22/2018 | [NAME] |  | [NAME] | 06:26 AM | 07:41:00 |  | 08:17:00 | 15:47:00 |  | 16:19:00 | 04:25 PM |  |  | 24
10/23/2018 | [NAME] |  |  | 06:57 AM | 07:47:00 |  | 08:29:00 | 11:37:00 |  | 12:01:00 | 12:05 PM
 | Allen Total
10/21/2018 | Alonzo |  | Walmart | 07:35 PM | 19:42:00 |  | 20:50:00 | 02:42:00 |  | 03:17:00 | 03:21 AM |  |  | 40
10/22/2018 | Alonzo |  |  | 06:36 PM | 18:43:00 |  | 19:54:00 | 22:25:00 |  | 23:07:00 | 11:13 PM
10/23/2018 | Alonzo |  |  | 05:54 PM | 18:40:00 |  | 19:58:00 | 01:47:00 |  | 02:15:00 | 02:21 AM
10/24/2018 | Alonzo |  |  | 05:57 PM | 18:58:00 |  | 21:29:00 | 00:49:00 |  | 02:48:00 | 02:48 AM
10/25/2018 | Alonzo |  |  | 06:25 PM | 19:10:00 |  | 21:03:00 | 03:25:00 |  | 05:30:00 | 05:26 AM | 0:00:00
 | Alonzo Total
2018-10-22 00:00:00 | [NAME] |  | ASR | 05:58:00 | 08:26:00 | 0:00:00 | 09:59:00 | 12:48:00 |  | 13:52:00 | 14:40:00 |  |  | 3
2018-10-23 00:00:00 | [NAME] |  | Terra | 05:56:00 | 06:49:00 |  | 08:41:00 | 10:27:00 |  |  |  |  |  | 4
2018-10-23 00:00:00 | [NAME] |  | Gramercy |  |  |  | 11:27:00 | 11:44:00 |  |  |  |  |  | 1
2018-10-23 00:00:00 | [NAME] |  | Moss Park |  |  |  | 13:22:00 | 14:09:00 |  | 14:48:00 | 15:05:00 |  |  | 1
2018-10-24 00:00:00 | [NAME] |  | Key | 05:57:00 | 06:09:00 |  | 08:25:00 | 10:54:00 |  | 12:53:00 | 15:30:00 | 0:00:00 |  | 6
2018-10-25 00:00:00 | [NAME] |  | Key | 05:57:00 | 07:24:00 | 0:00:00 | 08:55:00 | 17:23:00 |  | 18:29:00 | 18:46:00 |  |  | 6
2018-10-26 00:00:00 | [NAME] |  | Family | 05:58:00 | 08:08:00 | 0:00:00 | 10:59:00 | 15:51:00 |  | 16:53:00 | 17:00:00 |  |  | 2
2018-10-27 00:00:00 | [NAME] |  |  | 06:24:00 | 06:44:00 |  | 08:11:00 | 11:25:00 |  | 12:52:00 | 13:18:00 |  |  | 3
 | [NAME]
10/22/2018 | [NAME] |  | Ridgewood | 05:58 AM | 07:16:00 |  | 09:05:00 | 10:14:00 |  | 11:28:00 | 03:58 PM | 0:00:00 |  | 4
10/23/2018 | [NAME] |  | Terra | 05:58 AM | 06:23:00 |  | 08:11:00 | 12:37:00 |  | 13:26:00 | 03:30 PM | 0:00:00 |  | 3
10/24/2018 | [NAME] |  | Gate 1421 | 06:00 AM | 06:25:00 |  | 09:12:00 | 13:27:00 |  | 14:25:00 | 02:32 PM |  |  | 6
10/25/2018 | [NAME] |  | Landing | 05:57 AM | 06:13:00 |  | 07:06:00 | 11:53:00 |  | 12:19:00 | 06:32 PM | 0:00:00 |  | 5
10/26/2018 | [NAME] |  | Greenway | 06:02 AM | 06:40:00 |  | 07:39:00 | 14:15:00 |  | 14:54:00 | 03:29 PM |  |  | 5
 | Benjamin Total
10/22/2018 | [NAME] | 6 | Moss Park | 06:05 AM | 07:50:00 |  | 09:27:00 | 15:17:00 |  | 16:17:00 | 04:21 PM |  |  | 7
10/23/2018 | [NAME] |  | Terra | 06:05 AM | 06:18:00 |  | 07:59:00 | 12:37:00 |  | 13:23:00 | 01:31 PM |  |  | 4 | 1
10/25/2018 | [NAME] |  | Spring Isle | 06:00 AM | 06:15:00 |  | 07:11:00 | 11:49:00 |  | 18:32:00 | 06:36 PM |  |  | 6
10/26/2018 | [NAME] |  | Family | 06:05 AM | 06:45:00 |  | 08:31:00 | 16:14:00 |  | 16:55:00 | 05:01 PM |  |  | 5
 | [NAME]
10/21/2018 | [NAME] |  | Walmart | 06:20 PM | 18:47:00 |  | 19:46:00 | 03:09:00 |  | 03:31:00 | 03:36 AM |  |  | 40
10/22/2018 | [NAME] |  |  | 06:05 PM | 18:45:00 |  | 21:07:00 | 04:11:00 |  | 06:01:00 | 06:14 AM
10/23/2018 | [NAME] |  |  | 06:06 PM | 18:54:00 |  | 21:53:00 | 00:08:00 |  | 02:18:00 | 02:29 AM
10/24/2018 | [NAME] |  |  | 06:11 PM | 18:51:00 |  | 21:19:00 | 02:49:00 |  | 04:43:00 | 04:50 AM
10/25/2018 | [NAME] |  |  | 06:01 PM | 18:56:00 |  | 20:58:00 | 03:36:00 |  | 05:12:00 | 05:16 AM
 | Brandon Total
10/22/2018 | Dwayne |  | Action gator | 05:46 AM | 06:26:00 |  | 08:09:00 | 10:30:00 |  | 11:33:00 | 12:02 PM |  |  | 6
10/23/2018 | Dwayne |  | Terra | 05:41 AM | 06:18:00 |  | 07:59:00 | 12:37:00 |  | 13:23:00 | 01:31 PM |  |  | 4
10/24/2018 | Dwayne |  | Gate 1421 | 05:42 AM | 06:17:00 |  | 08:48:00 | 11:28:00 |  | 13:38:00 | 02:12 PM |  |  | 6
10/25/2018 | Dwayne |  | Spring Isle | 05:42 AM | 06:15:00 |  | 07:11:00 | 11:49:00 |  | 18:32:00 | 06:37 PM |  |  | 6
10/26/2018 | Dwayne |  | Family | 05:40 AM | 06:45:00 |  | 08:31:00 | 16:14:00 |  | 16:55:00 | 05:00 PM |  |  | 5
 | [NAME]
10/21/2018 | Edgar | 2 | 2016 Alden | 06:01 AM | 07:01:00 |  | 07:54:00 | 12:22:00 |  | 13:00:00 | 01:14 PM |  |  | 5
10/22/2018 | Edgar |  | Action gator | 06:00 AM | 07:44:00 |  | 08:56:00 | 10:04:00 |  |  |  |  |  | 5
10/22/2018 | Edgar |  | asr |  |  |  | 10:32:00 | 12:49:00 |  | 14:02:00 | 02:24 PM |  |  | 1
10/23/2018 | Edgar |  | Reunion | 06:02 AM | 06:24:00 |  | 07:49:00 | 12:58:00 |  | 13:54:00 | 02:36 PM |  |  | 4
2018-10-23 00:00:00 | Edgar |  | cvs | 12:07 AM | 00:54:00 |  | 04:29:00 | 09:57:00 |  | 13:03:00 | 01:16 PM |  |  | 6
10/25/2018 | Edgar |  | Hindu | 06:00 AM | 06:55:00 |  | 08:17:00 | 10:03:00 |  | 10:54:00 | 11:15 AM |  |  | 2
10/26/2018 | Edgar |  | CVS | 12:12 AM | 01:23:00 |  | 03:32:00 | 10:51:00 |  | 13:01:00 | 01:22 PM
 | [NAME]
10/21/2018 | Efrain |  | Walmart | 07:03 PM | 19:42:00 |  | 20:50:00 | 02:42:00 |  | 03:17:00 | 03:21 AM |  |  | 40
10/22/2018 | Efrain |  |  | 06:25 PM | 18:43:00 |  | 19:54:00 | 22:25:00 |  | 23:07:00 | 11:13 PM
10/23/2018 | Efrain |  |  | 06:05 PM | 18:40:00 |  | 19:58:00 | 01:47:00 |  | 02:15:00 | 02:20 AM
10/24/2018 | Efrain |  |  | 06:07 PM | 18:58:00 |  | 21:29:00 | 00:49:00 |  | 02:48:00 | 02:48 AM
10/25/2018 | Efrain |  |  | 06:28 PM | 19:10:00 |  | 21:03:00 | 03:25:00 |  | 05:30:00 | 05:40 AM
 | Efrain Total
10/21/2018 | [NAME] |  | Walmart 1 | 07:20 PM | 18:48:00 | 0:00:00 | 20:40:00 | 03:59:00 |  | 05:28:00 | 06:46 AM | 0:00:00 |  | 56
10/22/2018 | [NAME] |  | Walmart 1 | 05:58 PM | 18:28:00 |  | 20:40:00 | 04:39:00 |  | 06:20:00 | 10:54 AM | 0:00:00
10/23/2018 | [NAME] |  |  | 05:41 PM | 18:26:00 |  | 20:39:00 | 06:29:00 |  | 07:44:00 | 08:19 AM
10/24/2018 | [NAME] |  |  | 05:35 PM | 18:43:00 |  | 19:59:00 | 04:17:00 |  | 04:41:00 | 06:28 AM | 0:00:00
10/25/2018 | [NAME] |  |  | 08:00 PM | 19:10:00 | 0:00:00 | 22:01:00 | 04:30:00 |  | 07:32:00 | 07:49 AM
 | [NAME]
10/22/2018 | [NAME] |  | Action gator | 05:46 AM | 07:44:00 |  | 08:56:00 | 10:04:00 |  |  |  |  |  | 5
10/22/2018 | [NAME] |  | asr |  |  |  | 10:32:00 | 12:49:00 |  | 14:02:00 | 02:19 PM |  |  | 1
10/23/2018 | [NAME] |  | Reunion | 05:53 AM | 06:24:00 |  | 07:49:00 | 12:58:00 |  | 13:54:00 | 02:35 PM |  |  | 4
10/23/2018 | [NAME] |  | cvs | 00:00:00 | 00:54:00 |  | 04:29:00 | 09:57:00 |  | 13:03:00 | 01:11 PM |  |  | 6
10/25/2018 | [NAME] |  | Hindu | 05:57 AM | 06:55:00 |  | 08:17:00 | 10:03:00 |  | 10:54:00 | 11:02 AM |  |  | 2
10/26/2018 | [NAME] |  | CVS | 06:02 AM | 06:09:00 |  | 08:25:00 | 10:54:00 |  | 12:53:00 | 01:20 PM
 | [NAME]
2018-10-25 00:00:00 | [NAME] |  | Key | 06:00:00 | 07:24:00 |  | 08:55:00 | 17:23:00 |  | 18:29:00 | 18:46:00 |  |  | 6
 | [NAME]
10/21/2018 | Nick |  | Walmart 1 | 17:12:00 | 18:48:00 |  | 20:40:00 | 03:59:00 |  | 05:28:00 | 05:46:00 |  |  | 56
10/22/2018 | Nick |  | Walmart 1 | 17:47:00 | 18:28:00 |  | 20:40:00 | 04:39:00 |  | 06:20:00 | 06:50:00
10/23/2018 | Nick |  |  | 17:49:00 | 18:26:00 |  | 20:39:00 | 06:29:00 |  | 07:44:00 | 07:50:00
10/24/2018 | Nick |  |  | 17:22:00 | 18:43:00 |  | 19:59:00 | 04:17:00 |  | 04:41:00 | 04:53:00
10/25/2018 | Nick |  |  | 17:42:00 | 19:10:00 |  | 22:01:00 | 04:30:00 |  | 07:32:00 | 07:53:00
 | Nick Total
10/21/2018 | [NAME] |  | Walmart 1 | 06:01 PM | 19:24:00 |  | 22:36:00 | 06:07:00 |  | 07:03:00 | 08:01 AM |  |  | 56
10/22/2018 | [NAME] |  | Walmart 1 | 05:52 PM | 18:38:00 |  | 21:13:00 | 04:00:00 |  | 06:07:00 | 06:43 AM
10/24/2018 | [NAME] |  |  | 05:21 PM | 18:43:00 |  | 19:59:00 | 04:17:00 |  | 04:41:00 | 08:27 AM | 0:00:00 |  |  | 1
10/25/2018 | [NAME] |  |  | 05:52 PM | 19:10:00 |  | 22:01:00 | 04:30:00 |  | 07:32:00 | 08:09 AM
 | Patrick Total
10/21/2018 | [NAME] |  | Walmart 1 | 06:02 PM | 18:48:00 |  | 20:40:00 | 03:59:00 |  | 05:28:00 | 05:05 AM | 0:00:00 |  | 56
10/22/2018 | [NAME] |  | Walmart 1 | 05:55 PM | 18:28:00 |  | 20:40:00 | 04:39:00 |  | 06:20:00 | 06:41 AM
10/23/2018 | [NAME] |  |  | 05:55 PM | 18:26:00 |  | 20:39:00 | 06:29:00 |  | 07:44:00 | 07:37 AM | 0:00:00
10/24/2018 | [NAME] |  |  | 05:57 PM | 18:43:00 |  | 19:59:00 | 04:17:00 |  | 04:41:00 | 05:00 AM
 | [NAME]
10/21/2018 | [NAME] |  | walmart | 06:21 PM | 18:47:00 |  | 19:46:00 | 03:09:00 |  | 03:31:00 | 03:36 AM |  |  | 40
10/22/2018 | [NAME] |  |  | 06:06 PM | 18:45:00 |  | 21:07:00 | 04:11:00 |  | 06:01:00 | 06:14 AM
10/23/2018 | [NAME] |  |  | 06:06 PM | 18:54:00 |  | 21:53:00 | 00:08:00 |  | 02:18:00 | 02:26 AM
10/24/2018 | [NAME] |  |  | 06:11 PM | 18:51:00 |  | 21:19:00 | 02:49:00 |  | 04:43:00 | 04:50 AM
10/25/2018 | [NAME] |  |  | 05:59 PM | 18:56:00 |  | 20:58:00 | 03:36:00 |  | 05:12:00 | 05:16 AM
 | Rocco Total
10/21/2018 | Sergio | 2 | 2016 Alden | 07:00 AM | 07:01:00 |  | 07:54:00 | 12:22:00 |  | 13:00:00 | 01:14 PM |  |  | 5
10/22/2018 | Sergio |  | Ridgewood | 05:58 AM | 07:16:00 |  | 09:05:00 | 10:14:00 |  | 11:28:00 | 11:59 AM |  |  | 4
10/23/2018 | Sergio |  | Terra | 06:00 AM | 06:23:00 |  | 08:11:00 | 12:37:00 |  | 13:26:00 | 02:38 PM |  |  | 3
10/24/2018 | Sergio |  | Gate 1421 | 05:58 AM | 06:25:00 |  | 09:12:00 | 13:27:00 |  | 14:25:00 | 02:31 PM |  |  | 6
10/25/2018 | Sergio |  | Landing | 05:57 AM | 06:13:00 |  | 07:06:00 | 11:53:00 |  | 12:19:00 | 06:35 PM | 0:00:00 |  | 5
10/26/2018 | Sergio |  | Greenway | 05:57 AM | 06:40:00 |  | 07:39:00 | 14:15:00 |  | 14:54:00 | 03:29 PM |  |  | 5
 | Sergio Total
10/22/2018 | Terrance | 6 | Moss Park | 06:37 AM | 07:50:00 |  | 09:27:00 | 15:17:00 |  | 16:17:00 | 04:20 PM |  |  | 7
10/24/2018 | Terrance |  | Moss Park | 06:05 AM | 06:49:00 |  | 08:08:00 | 11:45:00 |  | 12:46:00 | 03:50 PM | 0:00:00 |  | 4
10/25/2018 | Terrance |  | Gate 1421 | 06:06 AM | 06:55:00 |  | 10:36:00 | 19:14:00 |  | 21:48:00 | 09:57 PM |  |  | 4
10/26/2018 | Terrance |  | Greenway | 06:08 AM | 07:48:00 |  | 09:02:00 | 16:02:00 |  | 16:36:00 | 04:47 PM |  |  | 5
 | Terrance Total
10/22/2018 | Willie |  | Action gator | 05:59 AM | 06:26:00 |  | 08:09:00 | 10:30:00 |  | 11:33:00 | 12:00 PM |  |  | 4
10/23/2018 | Willie |  | Terra | 06:01 AM | 06:49:00 |  | 08:41:00 | 10:27:00 |  |  |  |  |  | 4
10/23/2018 | Willie |  | Gramercy |  |  |  | 11:27:00 | 11:44:00 |  |  |  |  |  | 4
10/23/2018 | Willie |  | Moss Park |  |  |  | 13:22:00 | 14:09:00 |  | 14:48:00 | 02:50 PM |  |  | 4
10/24/2018 | Willie |  | Gate 1421 | 05:59 AM | 06:17:00 |  | 08:48:00 | 11:28:00 |  | 13:38:00 | 01:43 PM |  |  | 6
10/25/2018 | Willie |  | Key | 05:58 AM | 07:24:00 |  | 08:55:00 | 17:23:00 |  | 18:29:00 | 06:33 PM |  |  | 6
 | Willie Total
10/21/2018 | Zachary |  | Walmart 1 | 05:35 PM | 18:48:00 |  | 20:40:00 | 03:59:00 |  | 05:28:00 | 05:34 AM |  |  | 56
10/22/2018 | Zachary |  | Walmart 1 | 06:00 PM | 18:28:00 |  | 20:40:00 | 04:39:00 |  | 06:20:00 | 06:41 AM
10/23/2018 | Zachary |  |  | 05:40 PM | 18:26:00 |  | 20:39:00 | 06:29:00 |  | 07:44:00 | 07:46 AM
10/24/2018 | Zachary |  |  | 05:42 PM | 18:43:00 |  | 19:59:00 | 04:17:00 |  | 04:41:00 | 04:44 AM
10/25/2018 | Zachary |  |  | 05:43 PM | 19:10:00 |  | 22:01:00 | 04:30:00 |  | 07:32:00 | 08:02 AM
 | Zachary Total