Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 10072018-10132018

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/08/2018 | [NAME] |  | Pilot | 06:36 AM | 07:37:00 |  | 08:00:00 | 15:10:00 |  | 15:44:00 | 04:00 PM
10/09/2018 | [NAME] |  | Pilot | 06:55 AM | 07:43:00 |  | 08:27:00 | 12:38:00 |  | 13:13:00 | 01:39 PM
10/10/2018 | [NAME] |  | Pilot | 06:31 AM | 07:13:00 |  | 08:38:00 | 15:25:00 |  | 15:58:00 | 04:23 PM |  |  | 40
10/11/2018 | [NAME] |  | Pilot | 06:46 AM | 07:16:00 |  | 08:20:00 | 15:04:00 |  | 15:40:00 | 03:58 PM
10/12/2018 | [NAME] |  | Pilot | 06:58 AM | 08:03:00 |  | 08:33:00 | 14:54:00 |  | 15:24:00 | 03:49 PM
 | Allen Total
10/08/2018 | Alonzo |  | Walmart | 05:55 PM | 19:41:00 |  | 21:38:00 | 02:02:00 |  | 03:01:00 | 03:03 AM |  |  | 24
10/09/2018 | Alonzo |  |  | 06:06 PM | 18:09:00 |  | 20:37:00 | 10:51:00 |  | 11:56:00 | 12:03 PM
 | Alonzo Total
10/08/2018 | [NAME] |  | Moss Park | 07:00 AM | 08:29:00 |  | 09:19:00 | 13:55:00 |  | 14:18:00 | 03:01 PM |  |  | 6
10/09/2018 | [NAME] |  | 109 | 05:59 AM | 06:11:00 |  | 06:56:00 | 10:32:00 |  |  |  |  |  | 5
10/09/2018 | [NAME] |  | Adventist |  |  |  | 10:49:00 | 11:24:00 |  | 14:31:00 | 03:20 PM |  |  | 2
10/10/2018 | [NAME] |  | Beach | 05:55 AM | 06:32:00 |  | 07:51:00 | 12:47:00 |  |  |  |  |  | 3
10/10/2018 | [NAME] |  | West Central |  |  |  |  |  |  | 13:53:00 | 03:40 PM |  |  | 3
10/11/2018 | [NAME] |  | Terra | 05:57 AM | 06:48:00 |  | 09:00:00 | 13:23:00 |  | 14:00:00 | 02:32 PM |  |  | 6
10/12/2018 | [NAME] |  | Terra | 06:05 AM | 06:18:00 |  | 08:01:00 | 15:06:00 |  | 16:02:00 | 04:40 PM |  |  | 6
 | Benjamin Total
10/08/2018 | [NAME] |  | Bridge Prep | 06:00 AM | 09:58:00 |  | 11:27:00 | 12:30:00 |  | 13:39:00 | 02:02 PM |  |  | 6
10/10/2018 | [NAME] |  | Moss | 06:00 AM | 07:40:00 |  | 08:18:00 | 08:25:00 |  | 09:00:00 | 03:01 PM |  |  | 6
10/11/2018 | [NAME] |  | Shop | 06:02 AM |  | 0:00:00 |  |  |  |  | 02:54 PM
10/12/2018 | [NAME] |  | Pure | 06:00 AM | 06:15:00 |  | 07:15:00 | 09:44:00
10/12/2018 | [NAME] |  | Terra |  |  |  | 10:42:00 | 15:05:00 |  | 16:06:00 | 04:29 PM |  |  | 5
 | [NAME]
10/07/2018 | [NAME] |  |  | 06:07 PM | 18:31:00 |  | 02:48:00 | 11:52:00 |  | 07:18:00 | 07:38 AM
10/08/2018 | [NAME] |  | Walmart | 06:07 PM | 18:29:00 |  | 19:44:00 | 06:58:00 |  | 07:10:00 | 07:25 AM |  |  | 48
10/09/2018 | [NAME] |  |  | 04:50 PM | 17:16:00 |  | 18:08:00 | 07:02:00 |  | 07:12:00 | 07:39 AM
10/10/2018 | [NAME] |  |  | 10:46 AM | 11:00:00 |  | 11:59:00 | 16:45:00 |  | 18:34:00 | 06:44 PM
10/11/2018 | [NAME] |  |  | 06:04 PM | 19:20:00 |  | 21:10:00 | 05:18:00 |  | 05:28:00 | 05:30 AM
 | Brandon Total
10/08/2018 | Dwayne |  | 10th Street | 05:46 AM | 06:47:00 |  | 08:09:00 | 10:58:00 |  | 11:48:00 | 01:42 PM |  |  | 5
10/09/2018 | Dwayne |  | Park Square | 05:36 AM | 06:15:00 |  | 07:11:00 | 11:46:00 |  |  |  |  |  | 4
10/09/2018 | Dwayne |  | Adventist |  |  |  | 12:24:00 | 14:12:00 |  | 14:36:00 | 03:29 PM |  |  | 2
10/10/2018 | Dwayne |  | 1244 | 05:46 AM | 06:27:00 |  | 07:49:00 | 10:02:00 |  |  |  |  |  | 2
10/10/2018 | Dwayne |  | reserve |  |  |  | 10:13:00 | 12:40:00 |  |  |  |  |  | 2.5
10/10/2018 | Dwayne |  | Adventist |  |  |  | 12:58:00 | 13:26:00 |  | 14:08:00 | 02:11 PM |  |  | 1.5
10/11/2018 | Dwayne |  | creekstone | 05:41 AM | 06:39:00 |  | 07:29:00 | 09:54:00 |  |  |  |  |  | 2
10/11/2018 | Dwayne |  | renovation |  |  |  | 10:51:00 | 13:04:00 |  | 13:25:00 | 02:48 PM |  |  | 2
10/12/2018 | Dwayne |  | Pilot | 05:50 AM | 06:19:00 |  | 08:59:00 | 14:49:00 |  | 17:08:00 | 05:14 PM |  |  | 6
 | [NAME]
10/07/2018 | Edgar |  | Bank of America | 06:01 AM | 06:20:00 |  | 07:50:00 | 12:56:00 |  | 14:10:00 | 02:31 PM |  |  | 6
10/08/2018 | Edgar |  | burlington | 06:02 AM | 06:36:00 |  | 07:22:00 | 09:54:00 |  |  |  |  |  | 2.5
10/08/2018 | Edgar |  | Pure |  |  |  | 10:34:00 | 14:08:00 |  | 14:41:00 | 03:32 PM |  |  | 4
10/09/2018 | Edgar |  | Ocean Terrace | 06:00 AM | 07:00:00 |  | 08:34:00 | 12:03:00 |  | 13:11:00 | 02:31 PM |  |  | 5
10/10/2018 | Edgar |  | Bank of America | 06:00 AM | 06:13:00 |  | 07:42:00 | 09:54:00 |  |  |  |  |  | 3
10/10/2018 | Edgar |  | Audubon |  |  |  | 10:46:00 | 12:57:00 |  | 13:35:00 | 02:05 PM |  |  | 2
10/11/2018 | Edgar |  | Ulta | 06:02 AM | 06:14:00 |  | 07:43:00 | 12:33:00 |  |  |  |  |  | 4
10/11/2018 | Edgar |  | creekstone |  |  |  | 14:33:00 | 15:34:00 |  | 16:30:00 | 05:03 PM |  |  | 4
10/12/2018 | Edgar |  | Pure | 05:59 AM | 06:15:00 |  | 07:15:00 | 09:44:00 |  |  |  |  |  | 2
10/12/2018 | Edgar |  | Terra |  |  |  | 10:42:00 | 15:05:00 |  | 16:06:00 | 04:29 PM |  |  | 5
 | [NAME]
10/07/2018 | Efrain |  |  | 07:25 PM | 18:31:00 | 0:00:00 | 02:48:00 | 11:52:00 |  | 07:18:00 | 08:04 AM
10/08/2018 | Efrain |  | Walmart | 04:56 PM | 18:29:00 |  | 19:44:00 | 06:58:00 |  | 07:10:00 | 07:30 AM |  |  | 48
10/09/2018 | Efrain |  |  | 04:48 PM | 17:16:00 |  | 18:08:00 | 07:02:00 |  | 07:12:00 | 07:39 AM
10/10/2018 | Efrain |  |  | 10:44 AM | 11:00:00 |  | 11:59:00 | 16:45:00 |  | 18:34:00 | 06:56 PM
 | Efrain Total
10/07/2018 | [NAME] |  | Walmart 1 | 06:24 PM | 18:31:00 |  | 09:44:00 | 03:18:00 |  | 05:55:00 | 10:14 AM |  |  | 40
10/08/2018 | [NAME] |  | Walmart 2 | 03:53 PM | 18:31:00 | 0:00:00 | 19:58:00 | 04:22:00 |  | 06:30:00 | 08:02 AM
10/09/2018 | [NAME] |  | Walmart 3 | 04:54 PM | 18:10:00 | 0:00:00 | 19:41:00 | 03:22:00 |  | 05:22:00 | 05:58 AM
10/10/2018 | [NAME] |  | Walmart 4 | 05:30 PM | 18:40:00 |  | 19:43:00 | 04:47:00 |  | 05:43:00 | 07:37 AM
10/11/2018 | [NAME] |  |  | 03:00 PM | 18:33:00 | 0:00:00 | 19:38:00 | 06:32:00 |  | 07:51:00 | 09:12 AM
 | [NAME]
10/07/2018 | [NAME] |  | Bank of america | 06:00 AM | 06:20:00 |  | 07:50:00 | 12:56:00 |  | 14:10:00 | 02:10 PM |  |  | 6
10/08/2018 | [NAME] |  | burlington | 05:56 AM | 06:36:00 |  | 07:22:00 | 09:54:00 |  |  |  |  |  | 2.5
10/08/2018 | [NAME] |  | Pure |  |  |  | 10:34:00 | 14:08:00 |  | 14:41:00 | 03:03 PM |  |  | 4
10/09/2018 | [NAME] |  | Ocean Terrace | 07:02 AM | 07:00:00 | 0:00:00 | 08:34:00 | 12:03:00 |  | 13:11:00 | 02:28 PM |  |  | 5
10/10/2018 | [NAME] |  | Bank of America | 05:57 AM | 06:13:00 |  | 07:42:00 | 09:54:00 |  |  |  |  |  | 3
10/10/2018 | [NAME] |  | Audubon |  |  |  | 10:46:00 | 12:57:00 |  | 13:35:00 | 01:55 PM |  |  | 2
10/11/2018 | [NAME] |  | Ulta | 05:59 AM | 06:14:00 |  | 07:43:00 | 12:33:00 |  |  |  |  |  | 4
10/11/2018 | [NAME] |  | creekstone |  |  |  | 14:33:00 | 15:34:00 |  | 16:30:00 | 04:35 PM |  |  | 4
10/12/2018 | [NAME] |  | Pure | 05:59 AM | 06:15:00 |  | 07:15:00 | 09:44:00 |  |  |  |  |  | 2
10/12/2018 | [NAME] |  | Terra |  |  |  | 10:42:00 | 15:05:00 |  | 16:06:00 | 04:14 PM |  |  | 5
 | [NAME]
10/07/2018 | [NAME] |  | Walmart 1 | 05:50 PM | 18:31:00 |  | 09:44:00 | 03:18:00 |  | 05:55:00 | 07:36 AM
10/08/2018 | [NAME] |  | Walmart 2 | 05:59 PM | 18:31:00 |  | 19:58:00 | 04:22:00 |  | 06:30:00 | 07:30 AM |  |  | 40
10/09/2018 | [NAME] |  | Walmart 3 | 05:46 PM | 18:10:00 |  | 19:41:00 | 03:22:00 |  | 05:22:00 | 07:28 AM
10/10/2018 | [NAME] |  | Walmart 4 | 05:55 PM | 18:40:00 |  | 19:43:00 | 04:47:00 |  | 05:43:00 | 07:27 AM
10/11/2018 | [NAME] |  |  | 04:51 PM | 18:33:00 |  | 19:38:00 | 06:32:00 |  | 07:51:00 | 09:32 AM
 | Patrick Total
10/08/2018 | [NAME] |  | Bridge Prep | 06:10 AM | 09:58:00 | 0:00:00 | 11:27:00 | 12:30:00 |  | 13:39:00 | 02:02 PM |  |  | 6
10/09/2018 | [NAME] |  | Park Square | 06:13 AM | 06:55:00 |  | 07:50:00 | 15:06:00 |  | 15:26:00 | 03:38 PM |  |  | 5
10/10/2018 | [NAME] |  | moss | 06:08 AM | 07:40:00 |  | 08:18:00 | 08:25:00 |  | 09:00:00 | 03:00 PM |  |  | 6
10/11/2018 | [NAME] |  | Walmart | 05:51 PM | 18:33:00 |  | 19:38:00 | 06:32:00 |  | 07:51:00 | 07:37 AM | 0:00:00 |  | 8
 | [NAME]
10/07/2018 | [NAME] |  | Walmart | 06:07 PM | 18:31:00 |  | 02:48:00 | 11:52:00 |  | 07:18:00 | 08:06 AM |  |  | 48
10/08/2018 | [NAME] |  |  | 04:55 PM | 18:29:00 |  | 19:44:00 | 06:58:00 |  | 07:10:00 | 07:25 AM
10/09/2018 | [NAME] |  |  | 04:49 PM | 17:16:00 |  | 18:08:00 | 07:02:00 |  | 07:12:00 | 07:39 AM
10/10/2018 | [NAME] |  |  | 10:44 AM | 11:00:00 |  | 11:59:00 | 16:45:00 |  | 18:34:00 | 06:56 PM
10/11/2018 | [NAME] |  |  | 06:04 PM | 19:20:00 |  | 21:10:00 | 05:18:00 |  | 05:28:00 | 05:30 AM
 | Rocco Total
10/08/2018 | [NAME] |  | Bridge Prep | 06:07 AM | 06:46:00 |  | 07:49:00 | 08:30:00 |  | 15:11:00 | 04:04 PM |  |  | 6
10/09/2018 | [NAME] |  | Park Square | 05:59 AM | 06:55:00 |  | 07:50:00 | 15:06:00 |  | 15:26:00 | 03:39 PM |  |  | 6
10/10/2018 | [NAME] |  | moss | 05:57 AM | 07:40:00 |  | 08:18:00 | 08:25:00 |  | 09:00:00 | 09:56 AM
10/11/2018 | [NAME] |  | creekstone | 06:00 AM | 06:40:00 |  | 07:50:00 | 09:13:00 |  |  |  |  |  | 1.5
10/11/2018 | [NAME] |  | Moss |  |  |  | 10:46:00 | 15:47:00 |  | 16:24:00 | 04:28 PM |  |  | 4
10/12/2018 | [NAME] |  | Terra | 06:00 AM | 06:35:00 |  | 08:51:00 | 14:18:00 |  | 14:23:00 | 03:33 PM |  |  | 5
 | Ryan Total
10/08/2018 | Sergio |  | Moss | 05:58 AM | 08:29:00 |  | 09:19:00 | 13:55:00 |  | 14:18:00 | 02:27 PM |  |  | 6
10/09/2018 | Sergio |  | 109 | 05:58 AM | 06:11:00 |  | 06:56:00 | 10:32:00 |  |  |  |  |  | 5
10/09/2018 | Sergio |  | Adventist |  |  |  | 10:49:00 | 11:24:00 |  | 14:31:00 | 02:05 PM | 0:00:00 |  | 2
10/10/2018 | Sergio |  | Beach | 05:59 AM | 06:32:00 |  | 07:51:00 | 12:47:00 |  |  |  |  |  | 3
10/10/2018 | Sergio |  | West Central |  |  |  |  |  |  | 13:53:00 | 02:06 PM |  |  | 3
10/11/2018 | Sergio |  | Terra | 05:56 AM | 06:48:00 |  | 09:00:00 | 13:23:00 |  | 14:00:00 | 02:25 PM |  |  | 6
10/12/2018 | Sergio |  | Terra | 05:57 AM | 06:18:00 |  | 08:01:00 | 15:06:00 |  | 16:02:00 | 04:10 PM |  |  | 6
 | Sergio Total
10/08/2018 | [NAME] |  | Walmart | 05:42 PM | 19:41:00 |  | 21:38:00 | 02:02:00 |  | 03:01:00 | 03:06 AM |  |  | 24
10/09/2018 | [NAME] |  |  | 05:41 PM | 18:09:00 |  | 20:37:00 | 10:51:00 |  | 11:56:00 | 12:10 PM
10/10/2018 | [NAME] |  |  | 06:22 PM | 18:45:00 |  | 20:20:00 | 06:01:00 |  | 06:29:00 | 06:36 AM
10/11/2018 | [NAME] |  |  | 07:01 PM | 19:25:00 |  | 20:50:00 | 04:08:00 |  | 04:21:00 | 04:21 AM
 | [NAME]
10/08/2018 | Terrance |  | Bridge Prep | 06:15 AM | 06:46:00 |  | 07:49:00 | 08:30:00 |  | 15:11:00 | 03:53 PM |  |  | 6
10/09/2018 | Terrance |  | cheddars | 05:01 AM | 06:55:00 |  | 07:50:00 | 15:06:00 |  | 15:26:00 | 04:05 PM |  |  | 5
10/10/2018 | Terrance |  | 1244 | 05:58 AM | 06:27:00 |  | 07:49:00 | 10:02:00 |  |  |  |  |  | 2
10/10/2018 | Terrance |  | reserve |  |  |  | 10:13:00 | 12:40:00 |  |  |  |  |  | 2.5
10/10/2018 | Terrance |  | Adventist |  |  |  | 12:58:00 | 13:26:00 |  | 14:08:00 | 02:40 PM |  |  | 1.5
10/11/2018 | Terrance |  | creekstone | 06:18 AM | 06:40:00 |  | 07:50:00 | 09:13:00 |  |  |  |  |  | 1.5
10/11/2018 | Terrance |  | Moss |  |  |  | 10:46:00 | 15:47:00 |  | 16:24:00 | 04:29 PM |  |  | 4
10/12/2018 | Terrance |  | Terra | 05:59 AM | 06:35:00 |  | 08:51:00 | 14:18:00 |  | 14:23:00 | 03:13 PM |  |  | 5
 | Terrance Total
10/08/2018 | [NAME] |  | Walmart | 05:41 PM | 19:41:00 |  | 21:38:00 | 02:02:00 |  | 03:01:00 | 03:06 AM |  |  | 24
10/09/2018 | [NAME] |  |  | 05:16 PM | 18:09:00 |  | 20:37:00 | 10:51:00 |  | 11:56:00 | 12:11 PM
10/10/2018 | [NAME] |  |  | 05:39 PM | 18:45:00 |  | 20:20:00 | 06:01:00 |  | 06:29:00 | 06:42 AM
10/11/2018 | [NAME] |  |  | 07:01 PM | 19:25:00 |  | 20:50:00 | 04:08:00 |  | 04:21:00 | 04:21 AM
 | [NAME]
10/08/2018 | Willie |  | 10th Street | 05:59 AM | 06:47:00 |  | 08:09:00 | 10:58:00 |  | 11:48:00 |  | 0:00:00 |  | 5
10/09/2018 | Willie |  | Park Square | 06:01 AM | 06:15:00 |  | 07:11:00 | 11:46:00 |  |  |  |  |  | 4
10/09/2018 | Willie |  | Adventist |  |  |  | 12:24:00 | 14:12:00 |  | 14:36:00 | 14:42:00 |  |  | 2 | 1
10/11/2018 | Willie |  | creekstone | 05:58 AM | 06:39:00 |  | 07:29:00 | 09:54:00 |  |  |  |  |  | 2
10/11/2018 | Willie |  | renovation |  |  |  | 10:51:00 | 13:04:00 |  | 13:25:00 | 01:34 PM |  |  | 2
10/12/2018 | Willie |  | Pilot | 05:59 AM | 06:19:00 |  | 08:59:00 | 14:49:00 |  | 17:08:00 | 05:08 PM |  |  | 6
 | Willie Total
10/07/2018 | Zachary |  | Walmart 1 | 05:22 PM | 18:31:00 |  | 09:44:00 | 03:18:00 |  | 05:55:00 | 06:11 AM
10/08/2018 | Zachary |  | Walmart 2 | 05:37 PM | 18:31:00 |  | 19:58:00 | 04:22:00 |  | 06:30:00 | 06:40 AM
10/09/2018 | Zachary |  | Walmart 3 | 05:30 PM | 18:10:00 |  | 19:41:00 | 03:22:00 |  | 05:22:00 | 05:31 AM
10/10/2018 | Zachary |  | Walmart 4 | 05:53 PM | 18:40:00 |  | 19:43:00 | 04:47:00 |  | 05:43:00 | 05:52 AM |  |  | 40
10/11/2018 | Zachary |  |  | 05:48 PM | 18:33:00 |  | 19:38:00 | 06:32:00 |  | 07:51:00 | 08:02 AM
 | Zachary Total
10/07/2018 | Nick |  | Walmart 1 | 16:58:00 | 18:31:00 |  | 09:44:00 | 03:18:00 |  | 05:55:00 | 06:08:00 |  |  | 40
10/08/2018 | Nick |  | Walmart 2 | 17:49:00 | 18:31:00 |  | 19:58:00 | 04:22:00 |  | 06:30:00 | 06:44:00
10/09/2018 | Nick |  | Walmart 3 | 18:02:00 | 18:10:00 |  | 19:41:00 | 03:22:00 |  | 05:22:00 | 05:33:00
10/10/2018 | Nick |  | Walmart 4 | 17:47:00 | 18:40:00 |  | 19:43:00 | 04:47:00 |  | 05:43:00 | 05:57:00
10/11/2018 | Nick |  |  | 17:59:00 | 18:33:00 |  | 19:38:00 | 06:32:00 |  | 07:51:00 | 07:43:00 | 0:00:00
 | Nick Total