Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 07222018-07282018

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/23/2018 | [NAME] |  | Bridge Prep | 05:46 AM | 06:54:00 |  | 08:33:00 | 14:35:00 |  | 15:17:00 | 03:38 PM |  |  | 6
07/24/2018 | [NAME] |  | Station | 05:36 AM | 06:40:00 |  | 07:03:00 | 15:40:00 |  | 15:56:00 | 04:18 PM |  |  | 8
07/25/2018 | [NAME] |  | Station | 05:37 AM | 06:44:00 |  | 07:05:00 | 12:41:00 |  | 13:01:00 | 02:25 PM | 0:00:00 |  | 8
07/26/2018 | [NAME] |  | Station | 05:34 AM | 06:42:00 |  | 07:19:00 | 15:31:00 |  | 15:43:00 | 03:44 PM |  |  | 7
07/27/2018 | [NAME] |  | Moss | 05:50 AM | 06:45:00 |  | 07:30:00 | 11:25:00 |  |  |  |  |  | 1.5
07/27/2018 | [NAME] |  | Station |  |  |  | 12:18:00 | 16:54:00 |  | 17:12:00 | 05:13 PM |  |  | 6
 | Allen Total
07/23/2018 | [NAME] |  | gateway | 06:55 AM | 07:09:00 |  | 08:00:00 | 14:09:00 |  | 14:55:00 | 03:17 PM
07/24/2018 | [NAME] |  | gateway | 06:23 AM | 06:34:00 |  | 07:07:00 | 15:34:00 |  | 16:12:00 | 04:23 PM
07/25/2018 | [NAME] |  | gateway | 07:00 AM | 07:30:00 |  | 09:13:00 | 14:02:00 |  | 14:41:00 | 03:40 PM
07/26/2018 | [NAME] |  | gateway | 06:56 AM | 07:19:00 |  | 08:35:00 | 14:02:00 |  | 15:36:00 | 04:37 PM
07/27/2018 | [NAME] |  | Steel creek | 06:57 AM | 07:14:00 |  | 07:58:00 | 11:36:00 |  | 17:27:00 | 05:46 PM |  |  | 2
 | [NAME]
07/23/2018 | [NAME] |  | E2R51 | 06:00 AM | 06:48:00 |  | 08:52:00 | 12:52:00 |  | 14:37:00 | 04:00 PM |  |  | 6
07/24/2018 | [NAME] |  | [NAME] | 05:51 AM | 07:33:00 |  | 09:12:00 | 15:32:00 |  | 16:09:00 | 06:10 PM | 0:00:00 |  | 5
07/25/2018 | [NAME] |  | [NAME] | 06:04 AM | 06:55:00 |  | 08:16:00 | 17:24:00 |  | 18:37:00 | 06:45 PM |  |  | 4
07/26/2018 | [NAME] |  | Walgreens | 06:00 AM | 06:39:00 |  | 07:31:00 | 09:23:00 |  |  |  |  |  | 3
07/26/2018 | [NAME] |  | [NAME] |  |  |  | 10:03:00 | 15:20:00 |  | 15:56:00 | 04:37 PM |  |  | 4
07/27/2018 | [NAME] |  | Walgreens | 06:09 AM | 06:56:00 |  | 07:24:00 | 08:07:00 |  |  |  |  |  | 1
07/27/2018 | [NAME] |  | East Tract |  |  |  | 09:09:00 | 09:15:00 |  | 11:30:00 | 12:00 PM |  |  | 1
 | Benjamin Total
07/22/2018 | [NAME] |  | Walmart | 06:18 PM |  | 0:00:00 |  |  |  |  | 06:25 PM | 0:00:00
07/23/2018 | [NAME] |  | Walmart | 05:23 PM | 18:14:00 |  | 19:59:00 | 07:11:00 |  | 08:54:00 | 10:11 AM |  |  | 72
07/24/2018 | [NAME] |  |  | 06:12 PM | 18:36:00 |  | 20:49:00 | 08:27:00 |  | 09:53:00 | 10:41 AM
07/25/2018 | [NAME] |  |  | 06:03 PM | 18:15:00 |  | 20:43:00 | 06:07:00 |  | 07:44:00 | 07:49 AM
07/26/2018 | [NAME] |  |  | 07:45 PM | 19:59:00 |  | 21:02:00 | 06:23:00 |  | 07:40:00 | 08:30 AM
07/27/2018 | [NAME] |  |  | 05:53 PM | 18:16:00 |  | 21:11:00 | 08:56:00 |  | 09:33:00 | 09:44:00
2018-07-28 00:00:00 | [NAME] |  |  | 20:19:00 | 20:35:00 |  | 21:27:00 | 07:16:00 |  | 09:09:00 | 09:30:00
 | [NAME]
07/23/2018 | [NAME] |  | Walmart | 06:47 PM | 19:18:00 |  | 20:45:00 | 04:06:00 |  | 05:19:00 | 05:40 AM |  |  | 24
07/24/2018 | [NAME] |  |  | 06:22 PM | 18:52:00 |  | 20:40:00 | 04:05:00 |  | 05:17:00 | 05:26 AM
07/25/2018 | [NAME] |  |  | 05:58 PM | 18:46:00 |  | 20:53:00 | 03:58:00 |  | 05:17:00 | 05:20 AM
07/26/2018 | [NAME] |  |  | 05:56 PM | 18:11:00 |  | 20:19:00 | 04:04:00 |  | 05:25:00 | 05:28 AM
 | Brandon Total
07/24/2018 | Dwayne |  | Station | 05:47 AM | 06:40:00 |  | 07:03:00 | 15:40:00 |  | 15:56:00 | 04:09 PM |  |  | 8 | 2
07/26/2018 | Dwayne |  | Station | 05:43 AM | 06:42:00 |  | 07:19:00 | 15:31:00 |  | 15:43:00 | 03:50 PM |  |  | 7
07/27/2018 | Dwayne |  | Moss | 05:44 AM | 06:45:00 |  | 07:30:00 | 11:25:00 |  |  |  |  |  | 1.5
07/27/2018 | Dwayne |  | Station |  |  |  | 12:18:00 | 16:54:00 |  | 17:12:00 | 05:15 PM |  |  | 6
 | [NAME]
07/23/2018 | Edgar |  | Bridge Prep | 06:00 AM | 06:54:00 |  | 08:33:00 | 14:35:00 |  | 15:17:00 | 03:28 PM |  |  | 6
07/24/2018 | Edgar |  | Old Audubon | 05:58 AM | 07:12:00 |  | 08:16:00 | 15:43:00 |  | 16:21:00 | 04:30 PM |  |  | 4
07/25/2018 | Edgar |  | Station | 06:00 AM | 06:31:00 |  | 07:05:00 | 12:41:00 |  | 13:01:00 | 01:22 PM |  |  | 8
 | [NAME]
07/24/2018 | Efrain |  | Walmart | 08:33 PM | 19:09:00 | 0:00:00 | 02:50:00 | 07:42:00 |  | 09:15:00 | 09:35 AM |  |  | 24
07/25/2018 | Efrain |  |  | 06:12 PM | 18:18:00 |  | 19:17:00 | 02:05:00 |  | 06:06:00 | 05:35 AM | 0:00:00
 | Efrain Total
07/25/2018 | [NAME] |  | [NAME] | 06:00 AM | 06:48:00 |  | 10:12:00 | 14:17:00 |  | 14:35:00 | 03:00 PM |  |  | 1.5
07/26/2018 | [NAME] |  | Shop | 01:35 PM |  | 0:00:00 |  |  |  |  | 02:00 PM | 0:00:00
07/27/2018 | [NAME] |  | Walmart Kirkman | 06:00 AM | 06:51:00 |  | 07:49:00 | 16:19:00 |  | 17:09:00 | 05:58 PM |  |  | 8
 | [NAME]
07/23/2018 | [NAME] |  | gateway | 07:02 AM | 07:09:00 |  | 08:00:00 | 14:09:00 |  | 14:55:00 | 03:46 PM |  |  | 6
07/24/2018 | [NAME] |  | gateway | 06:04 AM | 06:34:00 |  | 07:07:00 | 15:34:00 |  | 16:12:00 | 04:17 PM |  |  | 8
07/25/2018 | [NAME] |  | gateway | 07:00 AM | 07:30:00 |  | 09:13:00 | 14:02:00 |  | 14:41:00 | 02:50 PM |  |  | 5
07/26/2018 | [NAME] |  | [NAME] | 07:18 AM | 07:14:00 | 0:00:00 | 07:58:00 | 16:49:00 |  | 17:08:00 | 05:29 PM |  |  | 8
07/27/2018 | [NAME] |  | gateway | 04:01 AM | 03:00:00 | 0:00:00 | 03:36:00 | 18:44:00 |  | 18:59:00 | 05:00 PM | 0:00:00 |  | 8
 | [NAME]
07/25/2018 | [NAME] |  | [NAME] | 06:30 AM | 06:55:00 |  | 08:16:00 | 17:24:00 |  | 18:37:00 | 06:45 PM |  |  | 4
07/26/2018 | [NAME] |  | Walgreens | 06:00 AM | 06:39:00 |  | 07:31:00 | 09:23:00 |  |  |  |  |  | 3 | 1
07/26/2018 | [NAME] |  | [NAME] |  |  |  | 10:03:00 | 15:20:00 |  | 15:56:00 | 04:36 PM |  |  | 4
07/27/2018 | [NAME] |  | Bridge | 06:29 AM | 06:20:00 | 0:00:00 | 07:59:00 | 10:26:00 |  |  |  |  |  | 4
07/27/2018 | [NAME] |  | Avalon |  |  |  | 11:31:00 | 12:48:00 |  |  |  |  |  | 3
07/27/2018 | [NAME] |  | UCF |  |  |  | 13:09:00 | 16:57:00 |  | 17:10:00 | 05:14 PM |  |  | 4
 | [NAME]
07/23/2018 | Logan |  | Walmart | 06:47 PM | 19:18:00 |  | 20:45:00 | 04:06:00 |  | 05:19:00 | 05:40 AM
07/24/2018 | Logan |  |  | 06:22 PM | 18:52:00 |  | 20:40:00 | 04:05:00 |  | 05:17:00 | 05:26 AM |  |  | 24
07/25/2018 | Logan |  |  | 05:58 PM | 18:46:00 |  | 20:53:00 | 03:58:00 |  | 05:17:00 | 05:20 AM
07/26/2018 | Logan |  |  | 05:56 PM | 18:11:00 |  | 20:19:00 | 04:04:00 |  | 05:25:00 | 05:28 AM
 | Logan Total
07/23/2018 | [NAME] |  | [NAME] | 06:05 AM | 08:04:00 |  | 09:12:00 | 14:18:00 |  | 14:54:00 | 03:33 PM |  |  | 5
07/24/2018 | [NAME] |  | Cypress | 06:03 AM | 07:54:00 |  | 09:11:00 | 14:37:00 |  | 15:12:00 | 03:33 PM |  |  | 5
07/25/2018 | [NAME] |  | [NAME] | 06:03 AM | 07:26:00 |  | 08:59:00 | 12:49:00 |  | 13:12:00 | 04:20 PM | 0:00:00 |  | 4
07/26/2018 | [NAME] |  | PTC | 06:01 AM | 06:59:00 |  | 08:01:00 | 10:14:00 |  |  |  |  |  | 1
07/26/2018 | [NAME] |  | Walgreens |  |  |  | 11:12:00 | 13:33:00 |  | 13:54:00 | 03:38 PM | 0:00:00 |  | 3
07/27/2018 | [NAME] |  | Walgreens | 06:01 AM | 06:56:00 |  | 07:24:00 | 08:07:00 |  |  |  |  |  | 1
07/27/2018 | [NAME] |  | East Tract |  |  |  | 09:09:00 | 09:15:00 |  | 11:30:00 | 02:58 PM | 0:00:00 |  | 1
 | Patrick Total
07/24/2018 | [NAME] |  | Walmart | 05:58 PM | 19:09:00 |  | 02:50:00 | 07:42:00 |  | 09:15:00 | 09:30 AM
07/25/2018 | [NAME] |  |  | 06:12 PM | 18:18:00 |  | 19:17:00 | 02:05:00 |  | 06:06:00 | 06:27 AM |  |  | 24
07/26/2018 | [NAME] |  |  | 05:56 PM | 19:45:00 |  | 21:09:00 | 03:56:00 |  | 04:45:00 | 04:50 AM
 | Rocco Total
07/23/2018 | [NAME] |  | E2R51 | 06:03 AM | 06:48:00 |  | 08:52:00 | 12:52:00 |  | 14:37:00 | 02:55 PM |  |  | 6
07/24/2018 | [NAME] |  | [NAME] | 05:57 AM | 07:33:00 |  | 09:12:00 | 15:32:00 |  | 16:09:00 | 04:46 PM |  |  | 5
07/25/2018 | [NAME] |  | Gramercy | 06:07 AM | 06:34:00 |  | 10:52:00 | 12:48:00 |  | 16:08:00 | 02:54 PM | 0:00:00 |  | 2
07/26/2018 | [NAME] |  | Shop | 06:01 AM |  | 0:00:00 |  |  |  |  | 02:38 PM | 0:00:00
07/27/2018 | [NAME] |  | Walmart Kirkman | 05:59 AM | 06:51:00 |  | 07:49:00 | 16:19:00 |  | 17:09:00 | 06:22 PM |  |  | 8
 | Ryan Total
07/22/2018 | [NAME] |  | Walmart | 06:18 PM |  | 0:00:00 |  |  |  |  | 06:26 PM | 0:00:00
07/23/2018 | [NAME] |  | Walmart | 05:23 PM | 18:14:00 |  | 19:59:00 | 07:11:00 |  | 08:54:00 | 10:10 AM |  |  | 72
07/24/2018 | [NAME] |  |  | 06:11 PM | 18:36:00 |  | 20:49:00 | 08:27:00 |  | 09:53:00 | 10:41 AM
07/25/2018 | [NAME] |  |  | 06:02 PM | 18:15:00 |  | 20:43:00 | 06:07:00 |  | 07:44:00 | 07:49 AM
07/26/2018 | [NAME] |  |  | 07:45 PM | 19:59:00 |  | 21:02:00 | 06:23:00 |  | 07:40:00 | 08:30 AM
07/27/2018 | [NAME] |  |  | 05:53 PM | 18:16:00 |  | 21:11:00 | 08:56:00 |  | 09:33:00 | 09:43:00
2018-07-28 00:00:00 | [NAME] |  |  | 20:19:00 | 20:35:00 |  | 21:27:00 | 07:16:00 |  | 09:09:00 | 09:30:00
 | [NAME]
07/22/2018 | Terrance |  | UNF | 06:42 AM | 07:00:00 |  | 09:30:00 | 12:45:00 |  | 14:15:00 | 02:29 PM |  |  | 8
07/23/2018 | Terrance |  | Bridge Prep | 06:19 AM | 07:57:00 |  | 09:03:00 | 14:45:00 |  | 16:11:00 | 04:29 PM |  |  | 5
07/24/2018 | Terrance |  | Cypress | 06:10 AM | 07:54:00 |  | 09:11:00 | 14:37:00 |  | 15:12:00 | 03:33 PM |  |  | 5
07/25/2018 | Terrance |  | [NAME] | 06:15 AM | 07:26:00 |  | 08:59:00 | 12:49:00 |  | 13:12:00 | 02:05 PM |  |  | 4
07/26/2018 | Terrance |  | PTC | 06:22 AM | 06:59:00 |  | 08:01:00 | 10:14:00 |  |  |  |  |  | 1
07/26/2018 | Terrance |  | Walgreens |  |  |  | 11:12:00 | 13:33:00 |  | 13:54:00 | 03:06 PM | 0:00:00 |  | 3
07/27/2018 | Terrance |  | Bridge | 06:38 AM | 07:30:00 |  | 09:17:00 | 10:26:00 |  |  |  |  |  | 2.5
07/27/2018 | Terrance |  | Avalon |  |  |  | 11:47:00 | 13:51:00 |  |  |  |  |  | 2
07/27/2018 | Terrance |  | Station |  |  |  | 14:38:00 | 16:17:00 |  | 16:33:00 | 05:50 PM | 0:00:00 |  | 2
 | Terrance Total
07/22/2018 | [NAME] |  | Walmart | 06:08 PM |  | 0:00:00 |  |  |  |  | 06:41 PM | 0:00:00
07/23/2018 | [NAME] |  | Walmart | 05:28 PM | 18:14:00 |  | 19:59:00 | 07:11:00 |  | 08:54:00 | 09:10 AM |  |  | 72
07/24/2018 | [NAME] |  | Walmart | 05:54 PM | 18:36:00 |  | 20:49:00 | 08:27:00 |  | 09:53:00 | 09:53 AM
07/25/2018 | [NAME] |  | Walmart | 06:10 PM | 18:15:00 |  | 20:43:00 | 06:07:00 |  | 07:44:00 | 07:49 AM
07/26/2018 | [NAME] |  | Walmart | 07:04 PM | 19:59:00 |  | 21:02:00 | 06:23:00 |  | 07:40:00 | 08:29 AM
07/27/2018 | [NAME] |  | Walmart | 05:49 PM | 18:16:00 |  | 21:11:00 | 08:56:00 |  | 09:33:00 | 09:43:00
2018-07-28 00:00:00 | [NAME] |  | Walmart | 19:53:00 | 20:35:00 |  | 21:27:00 | 07:16:00 |  | 09:09:00 | 09:30:00
 | [NAME]
07/23/2018 | Willie |  | Long bay | 06:00 AM | 12:45:00 | 0:00:00 | 14:24:00 | 14:40:00 |  | 16:23:00 | 07:39 PM | 0:00:00 |  | 8 | 1
07/25/2018 | Willie |  | Walgreens | 05:56 AM | 07:51:00 |  | 08:59:00 | 14:16:00 |  | 14:34:00 | 04:11 PM |  |  | 3
07/26/2018 | Willie |  | Epcot | 06:02 AM | 06:31:00 |  | 07:05:00 | 13:01:00 |  |  |  |  |  | 5
07/27/2018 | Willie |  | Station | 05:57 AM | 06:45:00 |  | 07:30:00 | 16:54:00 |  | 17:12:00 | 04:28 PM | 0:00:00 |  | 7
 | Willie Total
07/22/2018 | Zachary |  | UNF | 06:52 AM | 07:00:00 |  | 09:30:00 | 12:45:00 |  | 14:15:00 | 02:18 PM |  |  | 8
07/23/2018 | Zachary |  | [NAME] | 05:48 AM | 06:54:00 |  | 08:26:00 | 14:07:00 |  | 14:48:00 | 02:55 PM |  |  | 6
07/24/2018 | Zachary |  | Walgreens | 05:55 AM | 07:51:00 | 0:00:00 | 08:59:00 | 14:16:00 |  | 14:34:00 | 04:50 PM | 0:00:00 |  | 8
07/26/2018 | Zachary |  | UCF | 05:52 AM | 06:30:00 |  | 07:11:00 | 10:28:00 |  |  |  |  |  | 1.5
07/26/2018 | Zachary |  | Waterford |  |  |  | 10:49:00 | 13:32:00 |  | 14:03:00 | 02:16 PM |  |  | 2
07/27/2018 | Zachary |  | Bridge | 05:51 AM | 06:20:00 |  | 07:59:00 | 10:26:00 |  |  |  |  |  | 4
07/27/2018 | Zachary |  | Avalon |  |  |  | 11:31:00 | 12:48:00 |  |  |  |  |  | 3
07/27/2018 | Zachary |  | UCF |  |  |  | 13:09:00 | 16:57:00 |  | 17:10:00 | 05:15 PM |  |  | 3
 | Zachary Total
2018-07-23 00:00:00 | Nick |  | [NAME] | 05:39:00 | 06:54:00 |  | 08:26:00 | 14:07:00 |  | 14:48:00 | 14:55:00 |  |  | 8
2018-07-24 00:00:00 | Nick |  | Old Audubon | 05:55:00 | 07:12:00 |  | 08:16:00 | 15:43:00 |  | 16:21:00 | 16:28:00 |  |  | 6
2018-07-25 00:00:00 | Nick |  | [NAME] | 06:04:00 | 06:48:00 |  | 10:12:00 | 14:17:00 |  | 14:35:00 | 14:53:00 |  |  | 1.5
2018-07-26 00:00:00 | Nick |  | UCF | 06:03:00 | 06:30:00 |  | 07:11:00 | 10:28:00 |  |  |  |  |  | 1.5
2018-07-26 00:00:00 | Nick |  | Waterford |  |  |  | 10:49:00 | 13:32:00 |  | 14:03:00 | 14:23:00 |  |  | 2
07/27/2018 | Nick |  | Bridge | 05:54:00 | 06:20:00 |  | 07:59:00 | 10:26:00 |  |  |  |  |  | 4
07/27/2018 | Nick |  | Avalon |  |  |  | 11:31:00 | 12:48:00 |  |  |  |  |  | 3
07/27/2018 | Nick |  | UCF |  |  |  | 13:09:00 | 16:57:00 |  | 17:10:00 | 17:13:00 |  |  | 3
 | Nick Total
2018-07-23 00:00:00 | [NAME] |  | Long bay | 06:00:00 | 12:45:00 | 0:00:00 | 14:24:00 | 14:40:00 |  | 16:23:00 | 19:40:00 | 0:00:00 |  | 8
07/24/2018 | [NAME] |  | Walgreens | 06:02:00 | 07:51:00 |  | 08:59:00 | 14:16:00 |  | 14:34:00 | 18:04:00 | 0:00:00 |  | 8
2018-07-25 00:00:00 | [NAME] |  | Walgreens | 06:08:00 | 07:51:00 |  | 08:59:00 | 14:16:00 |  | 14:34:00 | 16:23:00 |  |  | 3
07/26/2018 | [NAME] |  | Epcot | 06:00:00 | 06:31:00 |  | 07:05:00 | 13:01:00 |  |  | 15:38:00 | 0:00:00 |  | 5
07/27/2018 | [NAME] |  |  | 05:55:00 | 06:45:00 |  | 07:30:00 | 16:54:00 |  | 17:12:00 | 16:36:00 | 0:00:00
 | [NAME]