Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 09302018-10062018

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/01/2018 | [NAME] |  | Pilot | 06:46 AM | 08:05:00 |  | 08:40:00 | 13:45:00 |  | 14:23:00 | 14:50:00 |  |  | 8
10/02/2018 | [NAME] |  | Pilot | 07:04 AM | 07:56:00 |  | 08:36:00 | 14:34:00 |  | 15:09:00 | 03:38 PM |  |  | 8
10/03/2018 | [NAME] |  | Pilot | 03:04 AM | 03:07:00 |  | 06:15:00 | 15:21:00 |  | 15:54:00 | 05:15 PM |  |  | 8
10/04/2018 | [NAME] |  | Pilot | 07:01 AM | 07:59:00 |  | 08:11:00 | 14:49:00 |  | 15:24:00 | 03:49 PM |  |  | 8
10/05/2018 | [NAME] |  | Pilot | 07:02 AM | 08:03:00 |  | 08:36:00 | 16:06:00 |  | 16:33:00 | 04:01 PM |  |  | 8
 | Allen Total
09/30/2018 | Alonzo |  | walmart | 06:01 PM | 18:41:00 |  | 21:09:00 | 06:20:00 |  | 08:31:00 | 08:35 AM |  |  | 24
10/01/2018 | Alonzo |  |  | 06:45 PM | 19:27:00 |  | 21:49:00 | 09:12:00 |  | 09:56:00 | 10:05 AM
10/02/2018 | Alonzo |  |  | 05:56 PM | 19:01:00 |  | 21:59:00 | 05:42:00 |  | 06:48:00 | 06:56 AM
10/03/2018 | Alonzo |  |  | 05:56 PM |  | 0:00:00 |  |  |  |  | 08:54 AM
10/04/2018 | Alonzo |  |  | 06:17 PM |  | 0:00:00 |  |  |  |  | 09:47 AM
 | Alonzo Total
10/01/2018 | [NAME] |  | Lake Nona Creekside | 06:21 AM | 06:53:00 |  | 07:44:00 | 12:37:00 |  |  |  |  |  | 8
10/01/2018 | [NAME] |  | Park Square |  |  |  | 13:37:00 | 14:30:00 |  | 14:50:00 | 03:03 PM |  |  | 1
10/02/2018 | [NAME] |  | George | 05:57 AM | 06:51:00 |  | 08:14:00 | 13:29:00 |  | 14:32:00 | 03:57 PM |  |  | 7
10/03/2018 | [NAME] |  | Maitland | 05:55 AM | 06:30:00 |  | 07:30:00 | 08:39:00 |  |  |  |  |  | 2
10/03/2018 | [NAME] |  | Park Square |  |  |  | 09:25:00 | 11:32:00 |  |  |  |  |  | 4
10/03/2018 | [NAME] |  | Oaktrail |  |  |  | 12:11:00 | 13:28:00 |  | 14:16:00 | 04:15 PM |  |  | 2
10/04/2018 | [NAME] |  | Infinity | 05:58 AM | 06:19:00 |  | 08:09:00 | 11:08:00 |  |  |  |  |  | 3
10/04/2018 | [NAME] |  | Cameron Reserve |  |  |  | 11:18:00 | 13:39:00 |  | 14:35:00 | 02:58 PM |  |  | 2
10/05/2018 | [NAME] |  | Spring Isle | 06:07 AM |  | 0:00:00 |  |  |  |  | 03:07 PM |  |  | 4
 | Benjamin Total
09/30/2018 | [NAME] |  | Walmart 1 | 06:11 PM | 18:52:00 |  | 20:35:00 | 06:11:00 |  | 07:01:00 | 07:02 AM
10/01/2018 | [NAME] |  | Walmart 2695 | 06:00 PM | 18:50:00 |  | 19:17:00 | 07:35:00 |  | 08:40:00 | 08:44 AM |  |  | 40
10/02/2018 | [NAME] |  | Walmart 3 | 06:04 PM | 19:05:00 |  | 20:09:00 | 07:00:00 |  | 07:56:00 | 07:59 AM
10/03/2018 | [NAME] |  | Walmart 4 | 06:03 PM | 19:06:00 |  | 20:00:00 | 03:56:00 |  | 04:39:00 | 05:20 AM
10/04/2018 | [NAME] |  |  | 06:00 PM | 18:54:00 |  | 19:52:00 | 05:16:00 |  | 05:51:00 | 06:30 AM
 | [NAME]
09/30/2018 | [NAME] |  | Walmart | 05:59 PM | 18:24:00 |  | 20:48:00 | 05:48:00 |  | 07:33:00 | 07:38 AM |  |  | 48
10/01/2018 | [NAME] |  |  | 06:07 PM | 19:49:00 |  | 21:04:00 | 05:25:00 |  | 07:29:00 | 08:10 AM
10/02/2018 | [NAME] |  |  | 07:07 PM | 20:05:00 |  | 22:38:00 | 02:58:00 |  | 04:46:00 | 04:52 AM
10/03/2018 | [NAME] |  |  | 06:00 PM | 18:18:00 |  | 22:07:00 | 02:59:00 |  | 05:50:00 | 06:01 AM
10/04/2018 | [NAME] |  |  | 06:08 PM | 18:43:00 |  | 22:33:00 | 05:19:00 |  | 07:37:00 | 08:06 AM
 | Brandon Total
10/01/2018 | Dwayne |  | Park Square | 05:40 AM | 06:22:00 |  | 07:14:00 | 13:27:00 |  | 14:01:00 | 02:45 PM |  |  | 6
10/02/2018 | Dwayne |  | Cheddars | 06:00 AM | 06:46:00 |  | 09:36:00 | 16:35:00 |  | 19:00:00 | 07:30 PM |  |  | 7 | 1
10/03/2018 | Dwayne |  | Park Square | 06:00 AM | 07:03:00 |  | 08:07:00 | 15:03:00 |  | 15:29:00 | 04:00 PM |  |  | 5
10/04/2018 | Dwayne |  | Creekstone | 05:43 AM | 06:28:00 |  | 07:30:00 | 11:18:00 |  |  |  |  |  | 2
10/04/2018 | Dwayne |  | Cameron Reserve |  |  |  | 11:21:00 | 12:38:00 |  | 13:23:00 | 01:38 PM |  |  | 4
 | [NAME]
10/01/2018 | Edgar |  | East Tract | 06:01 AM | 06:25:00 |  | 07:12:00 | 11:00:00 |  | 11:35:00 | 02:45 PM |  |  | 4
10/02/2018 | Edgar |  | Steak N Shake | 06:01 AM | 06:53:00 |  | 08:29:00 | 12:20:00 |  | 13:43:00 | 02:34 PM |  |  | 5
10/03/2018 | Edgar |  | Burlington | 06:01 AM | 06:42:00 |  | 10:28:00 | 14:17:00 |  |  |  |  |  | 5
10/03/2018 | Edgar |  | Maitland |  |  |  | 07:28:00 | 08:42:00 |  |  |  |  |  | 1
10/03/2018 | Edgar |  | I-4 |  |  |  | 09:13:00 | 09:46:00 |  | 14:54:00 | 04:03 PM |  |  | 2
10/04/2018 | Edgar |  | Steak N Shake | 06:02 AM | 06:18:00 |  | 07:59:00 | 11:29:00 |  |  |  |  |  | 2.5
10/04/2018 | Edgar |  | Infinity |  |  |  | 12:35:00 | 14:02:00 |  |  |  |  |  | 4
10/04/2018 | Edgar |  | East Tract |  |  |  |  |  |  | 14:43:00 | 03:00 PM |  |  | 2
10/04/2018 | Edgar |  | walmart 2695 | 07:33 PM | 18:54:00 | 0:00:00 | 19:52:00 | 05:16:00 |  | 05:51:00 | 11:07 AM |  |  | 8
 | [NAME]
10/01/2018 | Efrain |  | walmart | 06:54 PM | 18:24:00 | 0:00:00 | 20:48:00 | 05:48:00 |  | 07:33:00 | 06:57 AM |  |  | 48
10/02/2018 | Efrain |  |  | 09:03 PM | 19:49:00 | 0:00:00 | 21:04:00 | 05:25:00 |  | 07:29:00 | 04:16 AM
10/03/2018 | Efrain |  |  | 07:13 PM | 20:05:00 |  | 22:38:00 | 02:58:00 |  | 04:46:00 | 05:23 AM
10/04/2018 | Efrain |  |  | 07:40 PM | 18:18:00 | 0:00:00 | 22:07:00 | 02:59:00 |  | 05:50:00 | 08:05 AM
 | Efrain Total |  |  |  |  |  |  |  |  |  |  | 0:00:00
09/30/2018 | [NAME] |  | Walmart 1 | 03:04 PM | 18:52:00 |  | 20:35:00 | 06:11:00 |  | 07:01:00 | 08:58 AM |  |  | 8
10/01/2018 | [NAME] |  | Walmart 2695 | 05:45 PM | 18:50:00 |  | 19:17:00 | 07:35:00 |  | 08:40:00 | 10:29 AM
10/02/2018 | [NAME] |  | Walmart 3 | 05:55 PM | 19:05:00 |  | 20:09:00 | 07:00:00 |  | 07:56:00 | 12:39 PM
10/03/2018 | [NAME] |  | Walmart 4 | 05:51 PM | 19:06:00 |  | 20:00:00 | 03:56:00 |  | 04:39:00 | 07:46 AM
10/04/2018 | [NAME] |  |  | 06:54 PM | 18:54:00 |  | 19:52:00 | 05:16:00 |  | 05:51:00 | 08:08 AM
 | [NAME]
10/01/2018 | [NAME] |  | East Tract | 06:04 AM | 06:25:00 |  | 07:12:00 | 11:00:00 |  | 11:35:00 | 02:47 PM |  |  | 4
10/02/2018 | [NAME] |  | Steak N Shake | 06:01 AM | 06:53:00 |  | 08:29:00 | 12:20:00 |  | 13:43:00 | 02:30 PM |  |  | 5
10/03/2018 | [NAME] |  | Burlington | 05:58 AM | 06:42:00 |  | 10:28:00 | 14:17:00 |  |  |  |  |  | 5
10/03/2018 | [NAME] |  | Maitland |  |  |  | 07:28:00 | 08:42:00 |  |  |  |  |  | 1
10/03/2018 | [NAME] |  | I-4 |  |  |  | 09:13:00 | 09:46:00 |  | 14:54:00 | 03:02 PM |  |  | 2
10/04/2018 | [NAME] |  | Steak N Shake | 06:00 AM | 06:18:00 |  | 07:59:00 | 11:29:00 |  |  |  |  |  | 2.5
10/04/2018 | [NAME] |  | Infinity |  |  |  | 12:35:00 | 14:02:00 |  |  |  |  |  | 4
10/04/2018 | [NAME] |  | East Tract |  |  |  |  |  |  | 14:43:00 | 02:53 PM |  |  | 2
10/05/2018 | [NAME] |  | Spring Isle | 09:20 AM |  | 0:00:00 |  |  |  |  | 0 |  |  | 4
 | [NAME]
09/30/2018 | [NAME] |  | Walmart 1 | 05:59 PM | 18:52:00 |  | 20:35:00 | 06:11:00 |  | 07:01:00 | 07:30 AM |  |  | 8
10/01/2018 | [NAME] |  | Walmart 2695 | 05:55 PM | 18:50:00 |  | 19:17:00 | 07:35:00 |  | 08:40:00 | 09:35 AM
10/02/2018 | [NAME] |  | Walmart 3 | 06:05 PM | 19:05:00 |  | 20:09:00 | 07:00:00 |  | 07:56:00 | 09:18 AM
10/03/2018 | [NAME] |  | Walmart 4 | 06:04 PM | 19:06:00 |  | 20:00:00 | 03:56:00 |  | 04:39:00 | 05:33 AM
10/04/2018 | [NAME] |  |  | 05:44 PM | 18:54:00 |  | 19:52:00 | 05:16:00 |  | 05:51:00 | 07:00 AM
 | Patrick Total
09/30/2018 | [NAME] |  | Walmart 1 | 06:05 PM | 18:52:00 |  | 20:35:00 | 06:11:00 |  | 07:01:00 | 07:06 AM
10/01/2018 | [NAME] |  | Walmart 2695 | 05:51 PM | 18:50:00 |  | 19:17:00 | 07:35:00 |  | 08:40:00 | 08:44 AM |  |  | 40
10/02/2018 | [NAME] |  | Walmart 3 | 05:56 PM | 19:05:00 |  | 20:09:00 | 07:00:00 |  | 07:56:00 | 08:00 AM
10/03/2018 | [NAME] |  | Walmart 4 | 05:53 PM | 19:06:00 |  | 20:00:00 | 03:56:00 |  | 04:39:00 | 05:21 AM
10/04/2018 | [NAME] |  |  | 05:59 PM | 18:54:00 |  | 19:52:00 | 05:16:00 |  | 05:51:00 | 06:30 AM
 | [NAME]
09/30/2018 | [NAME] |  |  | 06:00 PM | 18:24:00 |  | 20:48:00 | 05:48:00 |  | 07:33:00 | 07:38 AM
10/01/2018 | [NAME] |  | Walmart | 06:06 PM | 19:49:00 |  | 21:04:00 | 05:25:00 |  | 07:29:00 | 08:10 AM |  |  | 48
10/02/2018 | [NAME] |  |  | 07:07 PM | 20:05:00 |  | 22:38:00 | 02:58:00 |  | 04:46:00 | 04:52 AM
10/03/2018 | [NAME] |  |  | 06:00 PM | 18:18:00 |  | 22:07:00 | 02:59:00 |  | 05:50:00 | 06:02 AM
10/04/2018 | [NAME] |  |  | 06:08 PM | 18:43:00 |  | 22:33:00 | 05:19:00 |  | 07:37:00 | 08:06 AM
 | Rocco Total
10/01/2018 | [NAME] |  | East Tract | 06:00 AM | 07:08:00 |  | 08:37:00 | 10:42:00 |  |  |  |  |  | 3
10/01/2018 | [NAME] |  | Park Square |  |  |  | 11:17:00 | 13:17:00 |  | 13:40:00 | 01:55 PM |  |  | 3
10/02/2018 | [NAME] |  |  | 05:59 AM |  | 0:00:00 |  |  |  |  | 0
10/03/2018 | [NAME] |  | Park Square | 05:58 AM | 07:05:00 |  | 08:17:00 | 12:22:00 |  |  |  |  |  | 4
10/03/2018 | [NAME] |  | I-4 |  |  |  | 13:32:00 | 15:07:00 |  | 15:39:00 | 03:45 PM |  |  | 2
10/04/2018 | [NAME] |  | Infinity | 06:00 AM | 06:31:00 |  | 07:32:00 | 12:29:00 |  | 13:23:00 | 01:48 PM |  |  | 3
10/05/2018 | [NAME] |  | Spring Isle | 05:59 AM | 06:55:00 |  | 07:45:00 | 13:49:00 |  | 14:20:00 | 02:42 PM |  |  | 3
 | Ryan Total
10/01/2018 | Sergio |  | Lake Nona Creekside | 05:57 AM | 06:53:00 |  | 07:44:00 | 12:37:00 |  |  |  |  |  | 8
10/01/2018 | Sergio |  | Park Square |  |  |  | 13:37:00 | 14:30:00 |  | 14:50:00 | 03:01 PM |  |  | 1
10/02/2018 | Sergio |  | George | 05:59 AM | 06:51:00 |  | 08:14:00 | 13:29:00 |  | 14:32:00 | 02:44 PM |  |  | 7
10/03/2018 | Sergio |  | Maitland | 05:58 AM | 06:30:00 |  | 07:30:00 | 08:39:00 |  |  |  |  |  | 2
10/03/2018 | Sergio |  | Park Square |  |  |  | 09:25:00 | 11:32:00 |  |  |  |  |  | 4
10/03/2018 | Sergio |  | Oaktrail |  |  |  | 12:11:00 | 13:28:00 |  | 14:16:00 | 02:45 PM |  |  | 2
10/04/2018 | Sergio |  | Infinity | 06:01 AM | 06:19:00 |  | 08:09:00 | 11:08:00 |  |  |  |  |  | 3
10/04/2018 | Sergio |  | Cameron Reserve |  |  |  | 11:18:00 | 13:39:00 |  | 14:35:00 | 02:54 PM |  |  | 2
10/05/2018 | Sergio |  | Spring Isle | 05:58 AM | 06:25:00 |  | 07:22:00 | 10:16:00 |  | 10:45:00 | 01:50 PM |  |  | 4
 | Sergio Total
10/02/2018 | [NAME] |  | Walmart | 05:58 PM | 18:41:00 |  | 21:09:00 | 06:20:00 |  | 08:31:00 | 06:55 AM |  |  | 24
10/03/2018 | [NAME] |  |  | 06:23 PM |  | 0:00:00 |  |  |  |  | 08:54 AM
10/04/2018 | [NAME] |  |  | 05:43 PM |  | 0:00:00 |  |  |  |  | 09:47 AM
 | [NAME]
10/01/2018 | Terrance |  | East Tract | 06:03 AM | 07:08:00 |  | 08:37:00 | 10:42:00 |  |  |  |  |  | 3
10/01/2018 | Terrance |  | Park Square |  |  |  | 11:17:00 | 13:17:00 |  | 13:40:00 | 01:58 PM |  |  | 3
10/02/2018 | Terrance |  | Cheddars | 05:56 AM |  | 0:00:00 |  |  |  |  | 0 |  |  | 7
10/03/2018 | Terrance |  | Park Square | 07:15 AM | 07:03:00 | 0:00:00 | 08:07:00 | 15:03:00 |  | 15:29:00 | 03:38 PM |  |  | 5
10/04/2018 | Terrance |  | Infinity | 06:01 AM | 06:31:00 |  | 07:32:00 | 12:29:00 |  | 13:23:00 | 01:41 PM |  |  | 3
10/05/2018 | Terrance |  | Cheddars | 06:10 AM |  | 0:00:00 |  |  |  |  | 0 |  |  | 5
 | Terrance Total
09/30/2018 | [NAME] |  | walmart | 05:36 PM | 18:41:00 |  | 21:09:00 | 06:20:00 |  | 08:31:00 | 08:42 AM |  |  | 24
10/01/2018 | [NAME] |  |  | 07:09 PM | 19:27:00 |  | 21:49:00 | 09:12:00 |  | 09:56:00 | 10:06 AM
10/02/2018 | [NAME] |  |  | 06:34 PM | 19:01:00 |  | 21:59:00 | 05:42:00 |  | 06:48:00 | 06:52 AM
10/03/2018 | [NAME] |  |  | 05:43 PM |  | 0:00:00 |  |  |  |  | 0
10/04/2018 | [NAME] |  |  | 06:49 PM |  | 0:00:00 |  |  |  |  | 0
 | [NAME]
10/01/2018 | Willie |  | Park Square | 05:57 AM | 06:22:00 |  | 07:14:00 | 13:27:00 |  | 14:01:00 | 02:03 PM |  |  | 4
10/02/2018 | Willie |  | Cheddars | 05:54 AM | 06:46:00 |  | 09:36:00 | 16:35:00 |  | 19:00:00 | 04:57 PM | 0:00:00 |  | 7
10/04/2018 | Willie |  |  | 05:59 AM | 07:03:00 |  | 08:07:00 | 15:03:00 |  | 15:29:00 | 01:27 PM | 0:00:00
10/05/2018 | Willie |  | Creekstone | 05:55 AM | 06:54:00 |  | 07:34:00 | 11:43:00 |  | 12:40:00 | 12:45 PM |  |  | 2
10/05/2018 | Willie |  | Cameron Reserve
 | Willie Total
09/30/2018 | Zachary |  | Walmart 1 | 05:47 PM | 18:52:00 |  | 20:35:00 | 06:11:00 |  | 07:01:00 | 07:08 AM |  |  | 8
10/01/2018 | Zachary |  | Walmart 2695 | 05:55 PM | 18:50:00 |  | 19:17:00 | 07:35:00 |  | 08:40:00 | 08:33 AM | 0:00:00
10/02/2018 | Zachary |  | Walmart 3 | 05:48 PM | 19:05:00 |  | 20:09:00 | 07:00:00 |  | 07:56:00 | 07:54 AM | 0:00:00 |  |  | 1
10/03/2018 | Zachary |  | Walmart 4 | 06:02 PM | 19:06:00 |  | 20:00:00 | 03:56:00 |  | 04:39:00 | 04:39 AM
 | Zachary Total
09/30/2018 | Nick |  | Walmart 1 | 17:43:00 | 18:52:00 |  | 20:35:00 | 06:11:00 |  | 07:01:00 | 07:05:00 |  |  | 40
10/01/2018 | Nick |  | Walmart 2695 | 17:57:00 | 18:50:00 |  | 19:17:00 | 07:35:00 |  | 08:40:00 | 08:33:00 | 0:00:00
10/02/2018 | Nick |  | Walmart 3 | 18:00:00 | 19:05:00 |  | 20:09:00 | 07:00:00 |  | 07:56:00 | 08:10:00
10/03/2018 | Nick |  | Walmart 4 | 18:02:00 | 19:06:00 |  | 20:00:00 | 03:56:00 |  | 04:39:00 | 04:40:00
2018-10-04 00:00:00 | Nick |  |  | 17:51:00 | 18:54:00 |  | 19:52:00 | 05:16:00 |  | 05:51:00 | 11:06:00
 | Nick Total