Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 07152018-07212018

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/16/2018 | [NAME] | 10 | Cemex | 05:32 AM | 07:04:00 |  | 09:56:00 | 14:45:00 |  | 16:45:00 | 04:50 PM |  |  | 5
07/17/2018 | [NAME] |  | Station at Alafaya | 05:40 AM | 06:19:00 |  | 06:45:00 | 15:14:00 |  | 15:24:00 | 03:36 PM |  |  | 7
07/18/2018 | [NAME] |  | Station at Alafaya | 05:44 AM | 06:27:00 |  | 07:03:00 | 13:55:00 |  | 14:06:00 | 14:07:00 |  |  | 4
07/19/2018 | [NAME] |  | Vernazza | 05:37 AM | 06:28:00 |  | 07:32:00 | 14:14:00 |  | 15:09:00 | 03:12 PM |  |  | 6
07/20/2018 | [NAME] |  | Center Point | 05:41 AM | 06:39:00 |  | 09:44:00 | 10:37:00 |  |  |  |  |  | 5
07/20/2018 | [NAME] |  | Vernazza |  |  |  | 11:49:00 | 14:47:00 |  | 15:42:00 | 03:52 PM |  |  | 3
 | Allen Total
07/16/2018 | [NAME] |  | [NAME] | 06:28 AM | 07:15:00 |  | 08:02:00 | 15:47:00 |  | 16:30:00 | 04:55 PM
07/17/2018 | [NAME] |  | Gateway | 06:50 AM | 06:55:00 |  | 07:30:00 | 13:53:00 |  | 15:20:00 | 03:37 PM
07/18/2018 | [NAME] |  | Gateway | 06:33 AM | 07:23:00 |  | 08:01:00 | 17:57:00 |  | 18:36:00 | 06:56 PM |  |  | 40
07/19/2018 | [NAME] |  | Gateway | 07:13 AM | 07:28:00 |  | 08:34:00 | 13:47:00 |  | 14:37:00 | 02:54 PM
07/19/2018 | [NAME] |  | [NAME] | 03:54 PM | 15:52:00 | 0:00:00 |  |  |  | 17:03:00 | 05:11 PM
07/20/2018 | [NAME] |  | Gateway | 06:50 AM | 07:34:00 |  | 08:30:00 | 14:33:00 |  | 15:10:00 | 03:19 PM
 | [NAME]
07/16/2018 | [NAME] |  | Avalon | 06:06 AM | 06:59:00 |  | 07:55:00 | 16:13:00 |  | 16:41:00 | 04:57 PM |  |  | 6
07/17/2018 | [NAME] |  | Maitland City | 08:05 AM | 08:47:00 |  | 09:37:00 | 11:39:00 |  |  |  |  |  | 2.5
07/17/2018 | [NAME] |  | lake dexter |  |  |  | 13:13:00 | 14:41:00 |  | 16:12:00 | 04:59 PM |  |  | 2
07/18/2018 | [NAME] |  | Bainbridge | 06:05 AM | 06:21:00 |  | 07:21:00 | 10:05:00 |  |  |  |  |  | 2.5
07/18/2018 | [NAME] |  | Avalon |  |  |  | 10:49:00 | 13:28:00 |  | 14:19:00 | 04:00 PM | 0:00:00 |  | 2.5
07/19/2018 | [NAME] |  | Eber | 05:50 AM | 06:12:00 |  | 08:21:00 | 16:03:00 |  | 16:49:00 | 06:00 PM | 0:00:00 |  | 4
07/20/2018 | [NAME] |  | UCF Various | 06:26 AM | 06:47:00 |  | 08:42:00 | 09:21:00 |  |  |  |  |  | 2.5
07/20/2018 | [NAME] |  | Walgreens |  |  |  | 09:49:00 | 12:29:00 |  | 13:09:00 | 02:44 PM | 0:00:00 |  | 3
 | Benjamin Total
07/15/2018 | [NAME] |  | Walmart | 05:52 PM | 18:49:00 |  | 20:04:00 | 07:38:00 |  | 08:19:00 | 08:26 AM
07/16/2018 | [NAME] |  | Walmart | 05:39 PM | 19:35:00 |  | 20:24:00 | 04:26:00 |  | 05:13:00 | 05:17 AM
07/17/2018 | [NAME] |  | Walmart | 04:48 PM | 19:41:00 |  | 01:30:00 | 08:01:00 |  | 09:38:00 | 10:11 AM |  |  | 56
07/18/2018 | [NAME] |  | Walmart | 04:59 PM | 17:20:00 |  | 17:40:00 | 08:18:00 |  | 08:47:00 | 09:10 AM
07/19/2018 | [NAME] |  | Walmart | 05:25 PM | 17:40:00 |  | 18:22:00 | 08:20:00 |  | 08:45:00 | 09:02 AM
07/20/2018 | [NAME] |  | Walmart | 05:18 PM | 17:36:00 |  | 18:38:00 | 07:10:00 |  | 07:30:00 | 07:53:00
 | [NAME]
07/15/2018 | [NAME] |  | Walmart | 05:24 PM | 17:47:00 |  | 21:52:00 | 06:44:00 |  | 08:39:00 | 07:46 AM | 0:00:00
07/16/2018 | [NAME] |  | Walmart | 06:08 PM | 18:55:00 |  | 21:39:00 | 05:21:00 |  | 06:19:00 | 06:48 AM |  |  | 56
07/17/2018 | [NAME] |  | Walmart | 06:28 PM | 19:25:00 |  | 21:27:00 | 03:52:00 |  | 05:09:00 | 05:23 AM
07/18/2018 | [NAME] |  | Walmart | 06:56 PM | 18:45:00 | 0:00:00 | 21:29:00 | 04:03:00 |  | 05:12:00 | 05:17 AM
07/19/2018 | [NAME] |  | Walmart | 08:11 PM | 20:11:00 |  | 09:29:00 | 04:03:00 |  | 05:12:00 | 05:21 AM
 | Brandon Total
07/16/2018 | Dwayne |  | Cemex | 05:45 AM | 07:04:00 |  | 09:56:00 | 14:45:00 |  | 16:45:00 | 05:00 PM |  |  | 5
07/17/2018 | Dwayne |  | Station at Alafaya | 05:47 AM | 06:19:00 |  | 06:45:00 | 15:14:00 |  | 15:24:00 | 03:44 PM |  |  | 7
07/18/2018 | Dwayne |  | Station at Alafaya | 05:45 AM | 06:27:00 |  | 07:03:00 | 13:55:00 |  | 14:06:00 | 02:14 PM |  |  | 4
 | [NAME]
07/16/2018 | Edgar |  | lake dexter | 05:56 AM | 06:11:00 |  | 07:58:00 | 14:57:00 |  | 16:27:00 | 04:33 PM |  |  | 8
07/17/2018 | Edgar |  | lake dexter | 06:04 AM | 06:35:00 |  | 08:25:00 | 14:41:00 |  | 16:15:00 | 04:40 PM |  |  | 4
07/18/2018 | Edgar |  | Avalon | 06:02 AM | 06:18:00 |  | 08:16:00 | 13:42:00 |  | 14:22:00 | 02:32 PM |  |  | 6
07/19/2018 | Edgar |  | Waterford Lakes | 05:58 AM | 06:28:00 |  | 07:10:00 | 14:38:00 |  | 15:18:00 | 03:24 PM |  |  | 4
07/20/2018 | Edgar |  | Center Point | 06:01 AM | 06:39:00 |  | 08:45:00 | 10:37:00 |  |  |  |  |  | 5
07/20/2018 | Edgar |  | Vernazza |  |  |  | 11:49:00 | 14:47:00 |  | 15:42:00 | 04:00 PM |  |  | 3
 | [NAME]
07/15/2018 | Efrain |  | Walmart | 07:02 PM | 17:47:00 | 0:00:00 | 21:52:00 | 06:44:00 |  | 08:39:00 | 08:07 AM | 0:00:00
07/17/2018 | Efrain |  | Walmart | 09:15 PM | 20:11:00 | 0:00:00 | 01:40:00 | 07:32:00 |  | 07:47:00 | 08:19 AM |  |  | 56
07/18/2018 | Efrain |  | Walmart | 05:00 PM | 17:02:00 |  | 17:34:00 | 07:18:00 |  | 07:38:00 | 07:54 AM
07/19/2018 | Efrain |  | Walmart | 04:59 PM | 17:00:00 |  | 17:49:00 | 08:44:00 |  | 08:58:00 | 09:11 AM
07/20/2018 | Efrain |  | Walmart | 04:59 PM | 17:07:00 |  | 17:17:00 | 07:11:00 |  | 08:37:00 | 09:05:00
 | Efrain Total
07/16/2018 | [NAME] |  | [NAME] | 07:11 AM | 07:15:00 |  | 08:02:00 | 15:47:00 |  | 16:30:00 | 04:35 PM |  |  | 7
07/17/2018 | [NAME] |  | Gateway | 06:52 AM | 06:55:00 |  | 07:30:00 | 13:08:00 |  | 15:08:00 | 05:53 PM | 0:00:00 |  | 5
07/18/2018 | [NAME] |  |  | 06:36 AM |  | 0:00:00 |  |  |  |  | 05:22 PM | 0:00:00
07/19/2018 | [NAME] |  | Eber | 06:09 AM |  | 0:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  | 3
07/19/2018 | [NAME] |  | Dollar General Mims |  |  |  | 13:00:00 | 15:00:00 |  |  | 05:30 PM | 0:00:00 |  | 2
07/20/2018 | [NAME] |  |  | 05:59 AM |  | 0:00:00 |  |  |  |  | 06:00 PM | 0:00:00
 | [NAME]
07/16/2018 | [NAME] |  | Avalon | 07:02 AM | 06:59:00 | 0:00:00 | 07:55:00 | 16:13:00 |  | 16:41:00 | 04:57 PM |  |  | 6
07/17/2018 | [NAME] |  | Maitland City | 07:19 AM | 08:47:00 |  | 09:37:00 | 11:39:00 |  |  |  |  |  | 2.5
07/17/2018 | [NAME] |  | lake dexter |  |  |  | 13:13:00 | 14:41:00 |  | 16:12:00 | 04:59 PM |  |  | 2
07/18/2018 | [NAME] |  | Bainbridge | 06:30 AM | 06:21:00 | 0:00:00 | 07:21:00 | 10:05:00 |  |  |  |  |  | 2.5
07/18/2018 | [NAME] |  | Avalon |  |  |  | 10:49:00 | 13:28:00 |  | 14:19:00 | 04:00 PM | 0:00:00 |  | 2.5
 | [NAME]
07/15/2018 | Logan |  | Walmart | 05:20 PM | 17:47:00 |  | 21:52:00 | 06:44:00 |  | 08:39:00 | 07:50 AM | 0:00:00
07/16/2018 | Logan |  | Walmart | 05:00 PM | 18:55:00 |  | 21:39:00 | 05:21:00 |  | 06:19:00 | 06:50 AM |  |  | 56
07/17/2018 | Logan |  | Walmart | 06:25 PM | 19:25:00 |  | 21:27:00 | 03:52:00 |  | 05:09:00 | 05:30 AM
07/18/2018 | Logan |  | Walmart | 06:56 PM | 18:45:00 | 0:00:00 | 21:29:00 | 04:03:00 |  | 05:12:00 | 05:17 AM
07/19/2018 | Logan |  | Walmart | 08:11 PM | 20:11:00 |  | 09:29:00 | 04:03:00 |  | 05:12:00 | 05:21:00
 | Logan Total
07/16/2018 | [NAME] |  | France BOH | 06:01 AM | 06:53:00 |  | 12:33:00 | 13:09:00 |  | 14:05:00 | 03:44 PM | 0:00:00 |  | 6
07/16/2018 | [NAME] |  | Cypress |  |  |  | 08:52:00 | 10:00:00 |  |  |  |  |  | 1.5
07/17/2018 | [NAME] |  | ASR | 05:56 AM | 07:53:00 |  | 09:17:00 | 14:16:00 |  |  | 04:48 PM |  |  | 3
07/17/2018 | [NAME] |  | St. Cloud |  |  |  |  |  |  |  | 03:53 PM |  |  | 3
07/18/2018 | [NAME] |  | station at alafaya | 06:17 AM |  | 0:00:00 |  |  |  |  | 04:48 PM | 0:00:00 |  | 3
07/19/2018 | [NAME] |  | Old Audubon | 05:58 AM |  | 0:00:00 |  |  |  |  |  |  |  | 3
07/19/2018 | [NAME] |  | Avalon |  |  |  |  |  |  |  | 05:15 PM |  |  | 3
07/20/2018 | [NAME] |  | Walgreens | 06:08 AM |  | 0:00:00 |  |  |  |  |  |  |  | 2
07/20/2018 | [NAME] |  | Avalon |  |  |  |  |  |  |  | 03:16 PM |  |  | 3
 | Patrick Total
07/15/2018 | [NAME] |  | Walmart | 05:17 PM | 17:47:00 |  | 21:52:00 | 06:44:00 |  | 08:39:00 | 09:15 AM
07/16/2018 | [NAME] |  | Walmart | 06:08 PM | 18:55:00 |  | 21:39:00 | 05:21:00 |  | 06:19:00 | 06:48 AM |  |  | 56
07/17/2018 | [NAME] |  | Walmart | 06:00 PM | 20:11:00 |  | 01:40:00 | 07:32:00 |  | 07:47:00 | 08:19 AM
07/18/2018 | [NAME] |  | Walmart | 05:00 PM | 17:02:00 |  | 17:34:00 | 07:18:00 |  | 07:38:00 | 07:53 AM
07/19/2018 | [NAME] |  | Walmart | 05:00 PM | 17:00:00 |  | 17:49:00 | 08:44:00 |  | 08:58:00 | 09:10 AM
07/20/2018 | [NAME] |  | Walmart | 05:01 PM | 17:07:00 |  | 17:17:00 | 07:11:00 |  | 08:37:00 | 09:00:00
 | Rocco Total
07/16/2018 | [NAME] |  | lake dexter | 05:56 AM |  | 0:00:00
07/16/2018 | [NAME] |  | Old Audubon |  |  |  |  |  |  |  | 02:18 PM
07/17/2018 | [NAME] |  | Rolling Oaks | 06:00 AM | 06:57:00 |  | 08:16:00 | 14:55:00 |  | 15:56:00 | 03:59 PM |  |  | 7
07/18/2018 | [NAME] |  | Fountain park | 05:59 AM | 06:58:00 |  | 12:08:00 | 13:19:00 |  |  |  |  |  | 2.5
07/18/2018 | [NAME] |  | Avalon |  |  |  | 14:33:00 | 15:58:00 |  | 16:37:00 | 04:49 PM |  |  | 4
07/19/2018 | [NAME] |  | Avalon | 06:10 AM |  | 0:00:00 |  |  |  |  | 04:01 PM | 0:00:00 |  | 5
07/20/2018 | [NAME] |  | UCF Various | 05:59 AM | 06:47:00 |  | 08:42:00 | 09:21:00 |  |  |  |  |  | 2.5
07/20/2018 | [NAME] |  | Walgreens |  |  |  | 09:49:00 | 12:29:00 |  | 13:09:00 | 01:34 PM |  |  | 3
 | Ryan Total
07/15/2018 | [NAME] |  | Walmart | 05:52 PM | 18:49:00 |  | 20:04:00 | 07:38:00 |  | 08:19:00 | 08:26 AM
07/16/2018 | [NAME] |  | Walmart | 05:39 PM | 19:35:00 |  | 20:24:00 | 04:26:00 |  | 05:13:00 | 05:17 AM
07/17/2018 | [NAME] |  | Walmart | 04:48 PM | 19:41:00 |  | 01:30:00 | 08:01:00 |  | 09:38:00 | 10:11 AM |  |  | 56
07/18/2018 | [NAME] |  | Walmart | 04:59 PM | 17:20:00 |  | 17:40:00 | 08:18:00 |  | 08:47:00 | 09:10 AM
07/19/2018 | [NAME] |  | Walmart | 05:25 PM | 17:40:00 |  | 18:22:00 | 08:20:00 |  | 08:45:00 | 09:02 AM
07/20/2018 | [NAME] |  | Walmart | 05:18 PM | 17:36:00 |  | 18:38:00 | 07:10:00 |  | 07:30:00 | 07:52:00
 | [NAME]
07/17/2018 | Terrance |  | Rolling Oaks | 05:54 AM | 06:57:00 |  | 08:16:00 | 14:55:00 |  | 15:56:00 | 04:10 PM |  |  | 7
07/18/2018 | Terrance |  | Fountain park | 06:07 AM | 06:58:00 |  | 12:08:00 | 13:19:00 |  |  |  |  |  | 2.5
07/18/2018 | Terrance |  | Avalon |  |  |  | 14:33:00 | 15:58:00 |  | 16:37:00 | 05:30 PM |  |  | 4
07/20/2018 | Terrance |  | Station at Alafaya | 06:17 AM |  | 0:00:00 |  |  |  |  | 04:16 PM | 0:00:00 |  | 5 | 1
 | Terrance Total
07/15/2018 | [NAME] |  | Walmart | 06:45 PM | 18:49:00 |  | 20:04:00 | 07:38:00 |  | 08:19:00 | 08:52 AM |  |  | 16
07/16/2018 | [NAME] |  | Walmart | 06:08 PM | 19:35:00 |  | 20:24:00 | 04:26:00 |  | 05:13:00 | 05:15 AM
 | [NAME]
07/17/2018 | Willie |  | Avalon | 06:02 AM | 08:42:00 |  | 09:21:00 | 15:30:00 |  | 15:43:00 | 02:47 PM | 0:00:00 |  | 7 | 1
07/18/2018 | Willie |  | WaWa | 05:54 AM | 06:45:00 |  | 08:17:00 | 09:40:00 |  |  |  |  |  | 2
07/18/2018 | Willie |  | East Tract 8 |  |  |  | 10:23:00 | 14:17:00 |  | 14:54:00 | 02:57 PM |  |  | 4
07/19/2018 | Willie |  | Old Audubon | 06:04 AM | 06:51:00 |  | 07:49:00 | 10:02:00 |  |  |  |  |  | 1.5
07/19/2018 | Willie |  | East Tract 8 |  |  |  | 10:36:00 | 13:41:00 |  | 14:08:00 | 02:12 PM |  |  | 3
07/20/2018 | Willie |  | Walgreens | 06:00 AM | 06:42:00 |  | 07:11:00 | 11:06:00 |  | 13:04:00 | 01:08 PM |  |  | 2.5
 | Willie Total
07/16/2018 | Zachary |  | lake dexter | 05:51 AM | 06:11:00 |  | 07:58:00 | 14:57:00 |  | 16:27:00 | 04:11 PM | 0:00:00 |  | 8
07/17/2018 | Zachary |  | lake dexter | 05:52 AM | 06:35:00 |  | 08:25:00 | 14:41:00 |  | 16:15:00 | 04:20 PM |  |  | 4
07/18/2018 | Zachary |  | Avalon | 05:53 AM | 06:18:00 |  | 08:16:00 | 13:42:00 |  | 14:22:00 | 02:30 PM |  |  | 6
07/19/2018 | Zachary |  | Waterford Lakes | 05:54 AM | 06:28:00 |  | 07:10:00 | 14:38:00 |  | 15:18:00 | 03:25 PM |  |  | 4
07/20/2018 | Zachary |  |  | 05:52 AM |  | 0:00:00 |  |  |  |  | 08:40 PM | 0:00:00
 | Zachary Total
07/16/2018 | Nick |  | lake dexter | 05:54:00 | 06:11:00 |  | 07:58:00 | 14:57:00 |  | 16:27:00 | 16:33:00 |  |  | 8
07/17/2018 | Nick |  | lake dexter | 06:04:00 | 06:35:00 |  | 08:25:00 | 14:41:00 |  | 16:15:00 | 16:21:00 |  |  | 4
07/18/2018 | Nick |  | Avalon | 05:57:00 | 06:18:00 |  | 08:16:00 | 13:42:00 |  | 14:22:00 | 14:34:00 |  |  | 6
07/19/2018 | Nick |  | Waterford Lakes | 05:59:00 | 06:28:00 |  | 07:10:00 | 14:38:00 |  | 15:18:00 | 15:28:00 |  |  | 4
 | Nick Total
07/16/2018 | [NAME] |  | France BOH | 05:56:00 | 06:53:00 |  | 12:33:00 | 13:09:00 |  | 14:05:00 | 16:15:00 | 0:00:00 |  | 6
07/16/2018 | [NAME] |  | Cypress |  |  |  | 08:52:00 | 10:00:00
07/17/2018 | [NAME] |  | Avalon | 06:04:00 | 08:42:00 |  | 09:21:00 | 15:30:00 |  | 15:43:00 | 16:03:00 |  |  | 7
07/18/2018 | [NAME] |  | WaWa | 06:01:00 | 06:45:00 |  | 08:17:00 | 09:40:00 |  |  |  |  |  | 2
07/18/2018 | [NAME] |  | East Tract 8 |  |  |  | 10:23:00 | 14:17:00 |  | 14:54:00 | 16:50:00 | 0:00:00 |  | 4
07/19/2018 | [NAME] |  | Old Audubon | 06:03:00 | 06:51:00 |  | 07:49:00 | 10:02:00 |  |  |  |  |  | 1.5
07/19/2018 | [NAME] |  | East Tract 8 |  |  |  | 10:36:00 | 13:41:00 |  | 14:08:00 | 17:09:00 | 0:00:00 |  | 3
07/20/2018 | [NAME] |  | Walgreens | 06:00:00 | 06:42:00 |  | 07:11:00 | 11:06:00 |  | 13:04:00 | 16:14:00 | 0:00:00 |  | 2.5
 | [NAME]