Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 07012018-07072018

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
07/03/2018 | [NAME] |  | The Gatherings | 05:32 AM | 08:04:00 |  | 08:27:00 | 10:36:00 |  | 11:16:00 | 11:22 AM |  |  |  | 1
07/05/2018 | [NAME] |  | UCF | 05:32 AM | 07:25:00 |  | 07:59:00 | 13:54:00 |  | 14:18:00 | 02:19 PM |  |  | 8
07/06/2018 | [NAME] |  | Daytona | 05:35 AM | 06:25:00 |  | 08:00:00 | 10:53:00 |  |  |  |  |  | 1
07/06/2018 | [NAME] |  | Hindu |  |  |  | 11:43:00 | 14:38:00 |  | 15:41:00 | 04:02 PM |  |  | 3
 | Allen Total
07/02/2018 | [NAME] |  |  | 07:04 AM |  | 0:00:00 |  |  |  |  | 0 |  |  | 0
07/05/2018 | [NAME] |  | [NAME] | 07:18 AM | 07:49:00 |  | 09:02:00 | 15:45:00 |  | 16:22:00 | 05:02 PM
07/06/2018 | [NAME] |  | [NAME] | 06:42 AM | 07:08:00 |  | 07:52:00 | 15:25:00 |  | 16:03:00 | 04:27 PM
 | [NAME]
07/01/2018 | [NAME] |  | south | 05:26 PM | 18:36:00 |  | 19:19:00 | 05:38:00 |  | 06:01:00 | 06:28 AM |  |  | 8
07/02/2018 | [NAME] |  | south | 04:48 PM | 17:15:00 |  | 18:05:00 | 01:37:00 |  | 02:28:00 | 02:33 AM |  |  | 8
07/05/2018 | [NAME] |  | UCF | 06:40 AM | 08:15:00 |  | 11:27:00 | 13:28:00 |  | 13:45:00 | 03:29 PM | 0:00:00 |  | 8
07/06/2018 | [NAME] |  | UCF | 05:57 AM | 06:28:00 |  | 07:04:00 | 14:31:00 |  | 14:57:00 | 03:30 PM |  |  | 8
 | Benjamin Total
07/01/2018 | [NAME] |  | Target | 06:01 PM | 18:37:00 |  | 20:02:00 | 22:07:00 |  | 22:57:00 | 11:15 PM |  |  | 8
07/02/2018 | [NAME] |  | Walmart | 06:11 PM | 18:45:00 |  | 20:11:00 | 07:32:00 |  | 08:21:00 | 08:34 AM |  |  | 48
07/03/2018 | [NAME] |  | Target | 05:58 PM | 18:39:00 |  | 20:30:00 | 09:01:00 |  | 09:58:00 | 10:11 AM
07/04/2018 | [NAME] |  | Walmart | 06:54 PM | 19:00:00 |  | 21:02:00 | 23:40:00 |  | 00:42:00 | 12:56 AM
07/05/2018 | [NAME] |  | Walmart | 05:51 PM | 18:22:00 |  | 20:01:00 | 23:23:00 |  | 00:27:00 | 12:30 AM
 | [NAME]
07/02/2018 | Dwayne |  | OC Library | 06:00 AM | 06:12:00 |  | 07:52:00 | 14:32:00 |  | 15:16:00 | 04:00 PM |  |  | 5
07/03/2018 | Dwayne |  | The Gatherings | 05:42 AM | 08:04:00 |  | 08:27:00 | 10:36:00 |  | 11:16:00 | 11:35 AM |  |  | 5
07/05/2018 | Dwayne |  | UCF | 05:41 AM | 07:25:00 |  | 07:59:00 | 13:54:00 |  | 14:18:00 | 02:30 PM |  |  | 8
07/06/2018 | Dwayne |  | Daytona | 05:49 AM | 06:25:00 |  | 08:00:00 | 10:53:00 |  |  |  |  |  | 1
07/06/2018 | Dwayne |  | Hindu |  |  |  | 11:43:00 | 14:38:00 |  | 15:41:00 | 03:48 PM |  |  | 3
 | [NAME]
07/02/2018 | Edgar |  | Bridge Prep | 05:59 AM | 06:18:00 |  | 08:19:00 | 14:32:00 |  | 15:18:00 | 04:21 PM | 0:00:00 |  | 6
07/03/2018 | Edgar |  | Bridge Prep | 05:59 AM | 06:13:00 |  | 08:10:00 | 10:39:00 |  | 12:12:00 | 12:19 PM |  |  | 5
07/05/2018 | Edgar |  | Vera | 06:02 AM | 06:52:00 |  | 07:55:00 | 13:59:00 |  | 14:30:00 | 02:40 PM |  |  | 5
07/06/2018 | Edgar |  | Bridge Prep | 05:59 AM | 06:27:00 |  | 07:57:00 | 14:03:00 |  | 15:35:00 | 03:43 PM |  |  | 6
 | [NAME]
07/02/2018 | [NAME] |  | Salisbury | 07:37 AM | 07:32:00 | 0:00:00 | 08:34:00 | 10:56:00 |  | 11:41:00 | 02:06 PM | 0:00:00 |  | 3
07/03/2018 | [NAME] |  | Mayport | 07:48 AM | 06:42:00 | 0:00:00 | 09:27:00 | 13:24:00 |  | 16:20:00 | 03:35 PM | 0:00:00 |  | 8
07/05/2018 | [NAME] |  | Shop | 07:52 AM | 09:59:00 | 0:00:00 |  |  |  |  | 06:46 PM | 0:00:00
07/06/2018 | [NAME] |  | The Greater Mall | 05:34 AM | 06:54:00 |  | 07:16:00 | 13:41:00 |  | 14:00:00 | 03:50 PM |  |  | 8
 | [NAME]
07/01/2018 | [NAME] |  | south | 05:30 PM | 18:36:00 |  | 19:19:00 | 05:38:00 |  | 06:01:00 | 06:28 AM |  |  | 8
07/02/2018 | [NAME] |  | south | 04:49 PM | 17:15:00 |  | 18:05:00 | 01:37:00 |  | 02:28:00 | 02:33 AM |  |  | 8
07/05/2018 | [NAME] |  | UCF | 08:04 AM | 08:15:00 |  | 11:27:00 | 13:28:00 |  | 13:45:00 | 03:14 PM | 0:00:00 |  |  | 1
 | [NAME]
07/02/2018 | [NAME] |  | OC Library | 06:14 AM | 07:18:00 |  | 08:27:00 | 11:11:00 |  | 11:58:00 | 02:55 PM | 0:00:00 |  | 3
07/03/2018 | [NAME] |  | Mayport | 06:05 AM | 06:42:00 | 0:00:00 | 09:27:00 | 13:24:00 |  | 16:20:00 | 04:30 PM |  |  | 8
07/05/2018 | [NAME] |  | Vera | 06:13 AM | 07:36:00 |  | 08:55:00 | 12:18:00 |  |  |  |  |  | 5
07/05/2018 | [NAME] |  | [NAME] |  |  |  | 13:06:00 | 13:21:00 |  | 13:59:00 | 02:25 PM |  |  | 2
07/06/2018 | [NAME] |  | Hindu | 06:00 AM | 07:06:00 |  | 08:27:00 | 12:00:00 |  |  |  |  |  | 2
07/06/2018 | [NAME] |  | [NAME] |  |  |  | 12:38:00 | 15:30:00 |  | 16:07:00 | 04:24 PM |  |  | 5
 | Patrick Total
07/02/2018 | [NAME] |  | Lake Minneola | 06:01 AM | 06:49:00 |  | 09:41:00 | 10:33:00 |  | 11:30:00 | 02:05 PM | 0:00:00 |  | 5
07/03/2018 | [NAME] |  | PTC Speed | 05:59 AM | 06:54:00 |  | 08:34:00 | 10:50:00 |  | 12:12:00 | 01:08 PM |  |  | 3
07/05/2018 | [NAME] |  | [NAME] | 06:01 AM | 07:36:00 |  | 08:43:00 | 13:35:00 |  | 14:15:00 | 02:39 PM |  |  | 5
07/06/2018 | [NAME] |  | [NAME] | 06:00 AM | 06:59:00 |  | 07:52:00 | 15:37:00 |  | 16:24:00 | 04:30 PM |  |  | 7
 | Ryan Total
07/01/2018 | [NAME] |  | Target | 06:01 PM | 18:37:00 |  | 20:02:00 | 22:07:00 |  | 22:57:00 | 11:15 PM |  |  | 8
07/02/2018 | [NAME] |  | Walmart | 06:11 PM | 18:45:00 |  | 20:11:00 | 07:32:00 |  | 08:21:00 | 08:34 AM |  |  | 48
07/03/2018 | [NAME] |  | Target | 05:58 PM | 18:39:00 |  | 20:30:00 | 09:01:00 |  | 09:58:00 | 10:12 AM
07/04/2018 | [NAME] |  | Walmart | 06:54 PM | 19:00:00 |  | 21:02:00 | 23:40:00 |  | 00:42:00 | 12:56 AM
07/05/2018 | [NAME] |  | Walmart | 05:51 PM | 18:22:00 |  | 20:01:00 | 23:23:00 |  | 00:27:00 | 12:30 AM
 | [NAME]
07/02/2018 | Terrance |  | Lake Minneola | 06:26 AM | 06:49:00 |  | 09:41:00 | 10:33:00 |  | 11:30:00 | 01:04 PM | 0:00:00 |  | 5
07/03/2018 | Terrance |  | PTC Speed | 06:29 AM | 06:54:00 |  | 08:34:00 | 10:50:00 |  | 12:12:00 | 01:45 PM |  |  | 3
07/05/2018 | Terrance |  | [NAME] | 06:20 AM | 07:36:00 |  | 08:43:00 | 13:35:00 |  | 14:15:00 | 03:00 PM |  |  | 5
07/06/2018 | Terrance |  | [NAME] | 06:33 AM | 06:59:00 |  | 07:52:00 | 15:37:00 |  | 04:00 PM | 04:00 PM |  |  | 7
 | Terrance Total
07/02/2018 | [NAME] |  | Target | 05:58 PM | 18:45:00 |  | 20:11:00 | 07:32:00 |  | 08:21:00 | 08:35 AM |  |  | 8
07/03/2018 | [NAME] |  | Target | 05:57 PM | 18:39:00 |  | 20:30:00 | 09:01:00 |  | 09:58:00 | 10:08 AM |  |  | 48
07/04/2018 | [NAME] |  | Walmart | 06:22 PM | 19:00:00 |  | 21:02:00 | 23:40:00 |  | 00:42:00 | 01:00 AM
07/05/2018 | [NAME] |  | Walmart | 05:34 PM | 18:22:00 |  | 20:01:00 | 23:23:00 |  | 00:27:00 | 12:28 AM
 | [NAME]
07/02/2018 | [NAME] |  | Old Audubon | 06:00 AM | 06:31:00 |  | 06:58:00 | 13:21:00 |  | 13:56:00 | 09:30 AM | 0:00:00 |  | 7
07/05/2018 | [NAME] |  | Econ | 06:00 AM | 06:49:00 |  | 07:12:00 | 09:26:00 |  | 09:54:00 | 10:30 AM |  |  | 1.5 | 1
07/06/2018 | [NAME] |  | Old Audubon | 06:00 AM | 06:59:00 |  | 10:09:00 | 13:58:00 |  | 14:39:00 | 02:30 PM | 0:00:00 |  | 7
 | Willie S Total
07/02/2018 | Willie |  | Econ | 06:05 AM | 08:07:00 | 0:00:00 | 08:38:00 | 10:07:00 |  |  |  |  |  | 1.5
07/02/2018 | Willie |  | Cypress |  |  |  | 10:59:00 | 13:19:00 |  | 14:00:00 | 01:56 PM | 0:00:00 |  | 2
07/03/2018 | Willie |  | PTC Speed | 06:01 AM | 06:54:00 |  | 08:34:00 | 10:50:00 |  | 12:12:00 | 01:03 PM |  |  | 3
07/05/2018 | Willie |  | UCF | 05:56 AM | 07:36:00 |  | 07:59:00 | 13:40:00 |  | 14:03:00 | 02:17 PM |  |  | 8
07/06/2018 | Willie |  | UCF | 06:05 AM | 06:28:00 |  | 07:04:00 | 14:31:00 |  | 14:57:00 | 03:11 PM |  |  | 7
 | Willie Total
07/02/2018 | Zachary |  | Bridge Prep | 05:53 AM | 06:18:00 |  | 08:19:00 | 14:32:00 |  | 15:18:00 | 04:17 PM | 0:00:00 |  | 6
07/03/2018 | Zachary |  | Bridge Prep | 05:54 AM | 06:13:00 |  | 08:10:00 | 10:39:00 |  | 12:12:00 | 12:19 PM |  |  | 5
07/05/2018 | Zachary |  | Vera | 05:53 AM | 06:52:00 |  | 07:55:00 | 13:59:00 |  | 14:30:00 | 02:38 PM |  |  | 5
07/06/2018 | Zachary |  | Bridge Prep | 05:53 AM | 06:27:00 |  | 07:57:00 | 14:03:00 |  | 15:35:00 | 03:41 PM |  |  | 6
 | Zachary Total
07/02/2018 | Nick |  | Bridge Prep | 06:01:00 | 06:18:00 |  | 08:19:00 | 14:32:00 |  | 15:18:00 | 16:19:00 | 0:00:00 |  | 6
07/03/2018 | Nick |  | Bridge Prep | 05:57:00 | 06:13:00 |  | 08:10:00 | 10:39:00 |  | 12:12:00 | 12:25:00 |  |  | 5
07/05/2018 | Nick |  | Vera | 05:57:00 | 06:52:00 |  | 07:55:00 | 13:59:00 |  | 14:30:00 | 14:38:00 |  |  | 5
07/06/2018 | Nick |  | Bridge Prep | 05:57:00 | 06:27:00 |  | 07:57:00 | 14:03:00 |  | 15:35:00 | 15:41:00 |  |  | 6
 | Nick Total
07/02/2018 | [NAME] |  | Econ | 05:55:00 | 08:07:00 | 0:00:00 | 08:38:00 | 10:07:00 |  |  |  |  |  | 1.5
07/02/2018 | [NAME] |  | Cypress |  |  |  | 10:59:00 | 13:19:00 |  | 14:00:00 | 14:55:00 |  |  | 2
07/03/2018 | [NAME] |  | PTC Speed | 05:58:00 | 06:54:00 |  | 08:34:00 | 10:50:00 |  | 12:12:00 | 15:39:00 | 0:00:00 |  | 3
07/05/2018 | [NAME] |  | UCF | 06:15:00 | 07:36:00 |  | 07:59:00 | 13:40:00 |  | 14:03:00 | 15:00:00 | 0:00:00 |  | 8
07/06/2018 | [NAME] |  | UCF | 05:56:00 | 06:28:00 |  | 07:04:00 | 14:31:00 |  | 14:57:00 | 15:31:00 |  |  | 8
 | [NAME]