Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 09022018-09082018

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
09/04/2018 | [NAME] |  | Vineyards | 05:52 AM | 06:32:00 |  | 12:12:00 | 13:37:00 |  |  |  |  |  | 1
09/04/2018 | [NAME] |  | Orlando Health |  |  |  | 08:00:00 | 11:52:00 |  | 14:42:00 | 02:43 PM |  |  | 8
09/05/2018 | [NAME] |  | Central FL | 05:51 AM | 06:24:00 |  | 12:22:00 | 13:52:00 |  |  |  |  |  | 2.5
09/05/2018 | [NAME] |  | Old Lockwood |  |  |  | 14:46:00 | 15:37:00 |  |  |  |  |  | 2
09/05/2018 | [NAME] |  | Hindu |  |  |  | 07:11:00 | 11:35:00 |  | 15:55:00 | 04:04 PM |  |  | 2.5
09/06/2018 | [NAME] |  | [NAME] | 05:55 AM | 06:11:00 |  | 06:53:00 | 12:51:00 |  |  |  |  |  | 6
09/06/2018 | [NAME] |  | East Tract |  |  |  | 14:03:00 | 15:28:00 |  | 16:02:00 | 04:04 PM |  |  | 3
09/07/2018 | [NAME] |  | Vera | 05:50 AM | 06:29:00 |  | 07:41:00 | 10:34:00 |  |  |  |  |  | 4
09/07/2018 | [NAME] |  | Orlando Health |  |  |  | 11:53:00 | 13:50:00 |  | 14:32:00 | 02:36 PM |  |  | 3
 | Allen Total
09/04/2018 | [NAME] |  | [NAME] | 09:20 AM | 09:37:00 |  | 10:10:00 | 13:12:00 |  | 13:50:00 | 02:07 PM
09/05/2018 | [NAME] |  | Moody | 03:30 AM | 03:44:00 |  | 03:59:00 | 15:24:00 |  | 15:28:00 | 03:30 PM
09/06/2018 | [NAME] |  | I-295 | 07:11 PM |  | 0:00:00 |  |  |  |  | 03:03 AM | 0:00:00
 | [NAME]
09/02/2018 | [NAME] |  | Sunlake | 06:40 AM | 07:32:00 |  | 10:09:00 | 13:20:00 |  | 16:22:00 | 04:24 PM |  |  | 6
09/04/2018 | [NAME] |  | Sunlake | 05:30 AM | 06:40:00 |  | 10:39:00 | 15:51:00 |  | 18:22:00 | 06:40 PM |  |  | 10
09/05/2018 | [NAME] |  | Sunlake | 05:50 AM | 06:59:00 |  | 09:50:00 | 16:13:00 |  | 18:37:00 | 06:42 PM |  |  | 8
09/06/2018 | [NAME] |  | Sunlake | 05:50 AM |  | 0:00:00 |  |  |  |  | 05:13 PM | 0:00:00 |  | 8
09/07/2018 | [NAME] |  | Sunlake | 05:50 AM | 07:08:00 |  | 09:57:00 | 13:58:00 |  | 16:18:00 | 04:24 PM |  |  | 6
 | Benjamin Total
09/02/2018 | [NAME] |  |  | 06:07 PM | 19:26:00 |  | 23:57:00 | 08:31:00 |  | 08:35:00 | 09:07 AM
09/03/2018 | [NAME] |  |  | 06:27 PM | 18:39:00 |  | 18:41:00 | 21:14:00 |  | 21:25:00 | 09:32 PM
09/04/2018 | [NAME] |  | walmart | 02:04 AM | 02:08:00 |  | 02:12:00 | 09:10:00 |  | 09:15:00 | 09:35 AM |  |  | 72
09/04/2018 | [NAME] |  |  | 05:09 PM | 17:17:00 |  |  |  |  | 17:49:00 | 06:13 PM
09/05/2018 | [NAME] |  |  | 12:54 AM | 00:59:00 |  | 01:04:00 | 09:47:00 |  | 09:53:00 | 10:05 AM
09/05/2018 | [NAME] |  |  | 04:05 PM | 16:08:00 |  |  |  |  | 16:52:00 | 05:02 PM
09/05/2018 | [NAME] |  |  | 05:37 PM | 17:48:00 |  | 19:08:00 | 07:36:00 |  | 07:43:00 | 08:08 AM
09/06/2018 | [NAME] |  |  | 11:57 AM | 12:14:00 |  |  |  |  | 14:47:00 | 03:06 PM
09/06/2018 | [NAME] |  |  | 05:21 PM | 17:49:00 |  |  |  |  | 15:36:00 | 03:53 PM
09/07/2018 | [NAME] |  |  | 10:02 PM | 22:10:00 |  | 22:24:00 | 18:00:00 |  | 06:39:00 | 05:30 AM | 0:00:00
 | Brandon Total
09/04/2018 | Dwayne |  | Vineyards | 05:58 AM | 06:32:00 |  | 12:12:00 | 13:37:00 |  |  |  |  |  | 1
09/04/2018 | Dwayne |  | Orlando Health |  |  |  | 08:00:00 | 11:52:00 |  | 14:42:00 | 03:59 PM | 0:00:00 |  | 8
09/05/2018 | Dwayne |  | Central FL | 05:50 AM | 06:24:00 |  | 12:22:00 | 13:52:00 |  |  |  |  |  | 2.5
09/05/2018 | Dwayne |  | Old Lockwood |  |  |  | 14:46:00 | 15:37:00 |  |  |  |  |  | 2
09/05/2018 | Dwayne |  | Hindu |  |  |  | 07:11:00 | 11:35:00 |  | 15:55:00 | 04:08 PM |  |  | 2.5
09/06/2018 | Dwayne |  | [NAME] | 05:47 AM | 06:11:00 |  | 06:53:00 | 12:51:00 |  |  |  |  |  | 6
09/06/2018 | Dwayne |  | East Tract |  |  |  | 14:03:00 | 15:28:00 |  | 16:02:00 | 04:09 PM |  |  | 3
09/07/2018 | Dwayne |  | Vera | 05:46 AM | 06:29:00 |  | 07:41:00 | 10:34:00 |  |  |  |  |  | 4
09/07/2018 | Dwayne |  | Orlando Health |  |  |  | 11:53:00 | 13:50:00 |  | 14:32:00 | 02:45 PM |  |  | 3
 | [NAME]
09/04/2018 | Edgar |  | Rolling oaks | 06:00 AM | 06:29:00 |  | 08:06:00 | 14:58:00 |  | 16:02:00 | 04:19 PM |  |  | 9
09/05/2018 | Edgar |  | Rolling oaks | 06:00 AM | 06:09:00 |  | 07:31:00 | 16:02:00 |  | 17:01:00 | 05:08 PM |  |  | 7
09/06/2018 | Edgar |  | Rolling oaks | 06:01 AM | 06:09:00 |  | 07:29:00 | 13:49:00 |  | 14:54:00 | 04:00 PM |  |  | 8
09/07/2018 | Edgar |  | Rolling oaks | 05:58 AM | 06:15:00 |  | 07:26:00 | 10:28:00 |  |  |  |  |  | 7
09/07/2018 | Edgar |  | East Tract |  |  |  | 12:59:00 | 15:34:00 |  | 16:15:00 | 04:26 PM |  |  | 3
 | [NAME]
09/04/2018 | [NAME] |  | shop | 06:00 AM |  | 0:00:00 |  |  |  |  | 02:30 PM | 0:00:00
09/05/2018 | [NAME] |  | Moody | 04:00 AM |  | 0:00:00 |  |  |  |  | 08:33 PM | 0:00:00
09/06/2018 | [NAME] |  | I-295 | 08:05 PM |  | 0:00:00 |  |  |  |  | 02:58 AM | 0:00:00
 | [NAME]
09/04/2018 | [NAME] |  | Rolling oaks | 05:57 AM | 06:29:00 |  | 08:06:00 | 14:58:00 |  | 16:02:00 | 04:15 PM |  |  | 9
09/05/2018 | [NAME] |  | Rolling oaks | 05:56 AM | 06:09:00 |  | 07:31:00 | 16:02:00 |  | 17:01:00 | 04:15 PM | 0:00:00 |  | 7
09/06/2018 | [NAME] |  | Rolling oaks | 05:57 AM | 06:09:00 |  | 07:29:00 | 13:49:00 |  | 14:54:00 | 03:58 PM |  |  | 8
09/07/2018 | [NAME] |  | Rolling oaks | 05:59 AM | 06:15:00 |  | 07:26:00 | 10:28:00 |  |  |  |  |  | 7
09/07/2018 | [NAME] |  | East Tract |  |  |  | 12:59:00 | 15:34:00 |  | 16:15:00 | 04:19 PM |  |  | 3
 | [NAME]
09/02/2018 | [NAME] |  | Sunlake | 07:00 AM | 07:32:00 |  | 10:09:00 | 13:20:00 |  | 16:22:00 | 04:24 PM |  |  | 10
09/04/2018 | [NAME] |  | Sunlake | 07:00 AM | 06:40:00 | 0:00:00 | 10:39:00 | 15:51:00 |  | 18:22:00 | 06:40 PM |  |  | 10
09/05/2018 | [NAME] |  | Sunlake | 05:53 AM | 06:59:00 |  | 09:50:00 | 16:13:00 |  | 18:37:00 | 06:42 PM |  |  | 8
09/06/2018 | [NAME] |  | Sunlake | 06:24 AM |  | 0:00:00 |  |  |  |  | 05:12 PM | 0:00:00 |  | 8
09/07/2018 | [NAME] |  | Sunlake | 06:39 AM | 07:08:00 |  | 09:57:00 | 13:58:00 |  | 16:18:00 | 04:24 PM |  |  | 6
 | [NAME]
09/04/2018 | [NAME] |  | Vera | 05:57 AM | 07:03:00 |  | 08:40:00 | 10:49:00 |  | 11:13:00 | 01:30 PM | 0:00:00 |  | 6
09/05/2018 | [NAME] |  | Sunlake | 05:57 AM | 06:58:00 |  | 09:50:00 | 16:41:00 |  | 18:38:00 | 06:41 PM |  |  | 8
09/06/2018 | [NAME] |  | shop | 06:02 AM |  | 0:00:00 |  |  |  |  | 03:20 PM | 0:00:00
09/07/2018 | [NAME] |  | Vera | 06:10 AM | 07:15:00 |  | 08:07:00 | 13:26:00 |  | 13:57:00 | 03:27 PM | 0:00:00 |  | 2.5
 | Patrick Total
09/04/2018 | [NAME] |  | Lot 2 | 06:00 AM | 08:05:00 |  | 08:56:00 | 10:35:00 |  |  |  |  |  | 1
09/04/2018 | [NAME] |  | Rolling oaks |  |  |  | 10:53:00 | 14:58:00 |  | 16:01:00 | 04:18 PM |  |  | 8
09/05/2018 | [NAME] |  | Rolling oaks | 06:05 AM | 06:54:00 |  | 08:05:00 | 15:22:00 |  | 16:24:00 | 04:41 PM |  |  | 7
09/06/2018 | [NAME] |  | Rolling oaks | 06:03 AM | 06:48:00 |  | 08:04:00 | 08:32:00 |  |  |  |  |  | 8
09/06/2018 | [NAME] |  | Sunlake |  |  |  | 10:00:00 | 15:04:00 |  | 16:56:00 | 05:13 PM |  |  | 3
09/07/2018 | [NAME] |  | Sunlake | 06:09 AM | 07:11:00 |  | 10:04:00 | 14:18:00 |  | 16:18:00 | 04:30 PM |  |  | 4
 | [NAME]
09/04/2018 | [NAME] |  | Sunlake | 06:04 AM | 06:42:00 |  | 10:43:00 | 15:47:00 |  | 18:26:00 | 06:34 PM |  |  | 6
09/07/2018 | [NAME] |  | Sunlake | 05:58 AM | 07:08:00 |  | 09:57:00 | 13:58:00 |  | 16:18:00 | 02:39 PM | 0:00:00 |  | 10 | 2
 | Ryan Total
09/02/2018 | Sergio |  | Sunlake | 06:57 AM | 07:32:00 |  | 10:09:00 | 13:20:00 |  | 16:22:00 | 04:25 PM |  |  | 6
09/04/2018 | Sergio |  | Lot 2 | 05:52 AM | 08:05:00 |  | 08:56:00 | 10:35:00 |  |  |  |  |  | 1
09/04/2018 | Sergio |  | Rolling oaks |  |  |  | 10:53:00 | 14:58:00 |  | 16:01:00 | 04:07 PM |  |  | 8
09/05/2018 | Sergio |  | Rolling oaks | 05:58 AM | 06:54:00 |  | 08:05:00 | 15:22:00 |  | 16:24:00 | 04:30 PM |  |  | 7
09/06/2018 | Sergio |  | Rolling oaks | 05:55 AM | 06:48:00 |  | 08:04:00 | 08:32:00 |  |  |  |  |  | 8
09/06/2018 | Sergio |  | Sunlake |  |  |  | 10:00:00 | 15:04:00 |  | 16:56:00 | 05:01 PM |  |  | 4
09/07/2018 | Sergio |  | Sunlake | 05:56 AM | 07:11:00 |  | 10:04:00 | 14:18:00 |  | 16:18:00 | 04:23 PM |  |  | 4
 | Sergio Total
09/02/2018 | [NAME] |  |  | 04:02 PM | 19:26:00 |  | 23:57:00 | 08:31:00 |  | 08:35:00 | 09:08 AM
09/03/2018 | [NAME] |  |  | 06:26 PM | 18:39:00 |  | 18:41:00 | 21:14:00 |  | 21:25:00 | 09:31 PM
09/04/2018 | [NAME] |  |  | 02:03 AM | 02:08:00 |  | 02:12:00 | 09:10:00 |  | 09:15:00 | 09:35 AM
09/04/2018 | [NAME] |  | walmart | 04:56 PM | 17:17:00 |  |  |  |  | 17:49:00 | 06:13 PM |  |  | 72
09/05/2018 | [NAME] |  |  | 12:50 AM | 00:59:00 |  | 01:04:00 | 09:47:00 |  | 09:53:00 | 10:05 AM
09/05/2018 | [NAME] |  |  | 04:03 PM | 16:08:00 |  |  |  |  | 16:52:00 | 05:02 PM
09/05/2018 | [NAME] |  |  | 05:37 PM | 17:48:00 |  | 19:08:00 | 07:36:00 |  | 07:43:00 | 08:08 AM
09/06/2018 | [NAME] |  |  | 11:57 AM | 12:14:00 |  |  |  |  | 14:47:00 | 03:09 PM
09/06/2018 | [NAME] |  |  | 05:21 PM | 17:49:00 |  |  |  |  | 15:36:00 | 03:51 PM
09/07/2018 | [NAME] |  |  | 10:01 PM | 22:10:00 |  | 22:24:00 | 18:00:00 |  | 06:39:00 | 05:50 AM | 0:00:00
 | [NAME]
09/04/2018 | Terrance |  | vera | 05:50 AM | 07:03:00 |  | 08:40:00 | 10:49:00 |  | 11:13:00 | 01:44 PM | 0:00:00 |  | 6
09/05/2018 | Terrance |  | Central FL | 06:16 AM | 06:58:00 |  | 08:17:00 | 09:20:00 |  |  |  |  |  | 1.5
09/05/2018 | Terrance |  | Grande lake |  |  |  | 11:01:00 | 13:31:00 |  | 14:11:00 | 04:12 PM | 0:00:00 |  | 2
09/06/2018 | Terrance |  | shop | 06:22 AM |  | 0:00:00 |  |  |  |  | 03:34 PM | 0:00:00
09/07/2018 | Terrance |  | Vera | 06:16 AM | 07:15:00 |  | 08:07:00 | 13:26:00 |  | 13:57:00 | 02:09 PM |  |  | 2.5
 | Terrance Total
09/04/2018 | Willie |  | Sunlake | 06:09 AM | 06:42:00 |  | 10:43:00 | 15:47:00 |  | 18:26:00 | 06:26 PM |  |  | 10
09/06/2018 | Willie |  | Sunlake | 06:04 AM | 06:59:00 |  | 09:32:00 | 15:04:00 |  | 17:10:00 | 05:12 PM |  |  | 8 | 1
09/07/2018 | Willie |  | Vera | 06:00 AM | 07:13:00 |  | 08:04:00 | 11:27:00 |  |  |  |  |  | 4
09/07/2018 | Willie |  | UCF Various |  |  |  | 12:52:00 | 13:57:00 |  | 14:28:00 | 02:35 PM |  |  | 3
 | Willie Total
09/04/2018 | Zachary |  | Sunlake | 05:48 AM | 06:40:00 |  | 10:39:00 | 15:51:00 |  | 18:22:00 | 06:24 PM |  |  | 10
09/05/2018 | Zachary |  | Rolling oaks | 05:52 AM | 06:09:00 |  | 07:31:00 | 16:02:00 |  | 17:01:00 | 05:04 PM |  |  | 7
09/06/2018 | Zachary |  | Rolling oaks | 05:49 AM | 06:09:00 |  | 07:29:00 | 13:49:00 |  | 14:54:00 | 03:25 PM |  |  | 8
09/07/2018 | Zachary |  | Rolling oaks | 05:51 AM | 06:15:00 |  | 07:26:00 | 10:28:00 |  |  |  |  |  | 7
09/07/2018 | Zachary |  | East Tract |  |  |  | 12:59:00 | 15:34:00 |  | 16:15:00 | 04:19 PM |  |  | 3
 | Zachary Total
09/04/2018 | Nick |  | Rolling oaks | 06:01:00 | 06:29:00 |  | 08:06:00 | 14:58:00 |  | 16:02:00 | 16:18:00 |  |  | 9
 | Nick Total
09/04/2018 | [NAME] |  | Sunlake | 06:04:00 | 06:42:00 |  | 10:43:00 | 15:47:00 |  | 18:26:00 | 18:34:00 |  |  | 10
09/05/2018 | [NAME] |  | Del Webb | 05:55:00 | 06:55:00 |  | 08:43:00 | 11:07:00 |  |  |  |  |  | 4
09/05/2018 | [NAME] |  | Old Lockwood |  |  |  | 12:23:00 | 14:12:00 |  | 14:31:00 | 16:30:00 |  |  | 1.5
09/06/2018 | [NAME] |  | Sunlake | 05:51:00 | 06:59:00 |  | 09:32:00 | 15:04:00 |  | 17:10:00 | 17:30:00 |  |  | 8
09/07/2018 | [NAME] |  | Vera | 05:56:00 | 07:13:00 |  | 08:04:00 | 11:27:00 |  |  |  |  |  | 4
09/07/2018 | [NAME] |  | UCF Various |  |  |  | 12:52:00 | 13:57:00 |  | 14:28:00 | 17:00:00 | 0:00:00 |  | 3
 | [NAME]