Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 06102018-06162018

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
06/11/2018 | [NAME] |  | [NAME] | 05:45 AM | 06:32:00 |  | 12:09:00 | 14:34:00 |  |  |  |  |  | 4.5
06/11/2018 | [NAME] |  | Gatherings |  |  |  | 07:06:00 | 07:33:00 | 15:13:00 | 15:13:00 | 03:35 PM |  |  | 2.5
06/12/2018 | [NAME] |  | [NAME] | 06:12 AM | 06:56:00 |  | 08:12:00 | 14:42:00 |  | 15:09:00 | 03:30 PM |  |  | 8
06/13/2018 | [NAME] |  | Econ | 05:37 AM | 06:21:00 |  | 07:20:00 | 15:19:00 |  | 15:40:00 | 04:00 PM |  |  | 6
06/14/2018 | [NAME] |  | Old Audobon | 05:39 AM | 07:07:00 |  | 08:09:00 | 12:31:00 | 13:08:00 | 13:08:00 | 02:10 PM |  |  | 8
06/15/2018 | [NAME] |  | [NAME] | 05:40 AM | 06:28:00 |  | 09:00:00 | 15:33:00 |  | 17:51:00 | 05:52 PM |  |  | 6
 | Allen Total
06/11/2018 | [NAME] |  |  | 04:00 AM |  | 0:00:00 |  |  |  |  | 05:00 PM | 0:00:00
06/13/2018 | [NAME] |  | [NAME] | 06:48 AM | 07:15:00 |  | 08:10:00 | 14:17:00 |  | 14:49:00 | 03:14 PM
06/14/2018 | [NAME] |  | [NAME] | 06:31 AM | 07:07:00 |  | 08:07:00 | 14:40:00 |  | 15:14:00 | 03:26 PM
06/15/2018 | [NAME] |  | [NAME] | 06:38 AM | 06:50:00 |  | 07:50:00 | 15:42:00 |  | 16:23:00 | 04:33 PM |  |  | 6
 | [NAME]
06/11/2018 | [NAME] |  | [NAME] | 05:58:00 | 06:47:00 |  | 07:50:00 | 15:34:00 |  | 15:39:00 | 16:19:00 |  |  | 8
06/12/2018 | [NAME] |  | [NAME] | 05:58:00 | 06:18:00 |  | 07:11:00 | 15:22:00 |  | 15:36:00 | 16:42:00 |  |  | 8
06/13/2018 | [NAME] |  | Econ | 06:07:00 | 06:21:00 |  | 07:20:00 | 15:19:00 |  | 15:40:00 | 16:30:00 |  |  | 6
06/14/2018 | [NAME] |  | Disney | 06:05:00 | 07:02:00 |  | 08:13:00 | 14:36:00 |  | 15:23:00 | 16:36:00 |  |  | 2
06/15/2018 | [NAME] |  | Bam | 05:57:00 | 06:59:00 |  | 09:19:00 | 13:25:00 |  | 15:33:00 | 16:14:00 |  |  | 5
 | [NAME]
06/11/2018 | [NAME] |  | CDBG | 06:15 AM | 06:42:00 |  | 07:05:00 | 17:24:00 |  | 18:54:00 | 07:05 PM |  |  | 7
06/12/2018 | [NAME] |  | [NAME] | 06:08 AM | 07:40:00 |  | 08:33:00 | 14:11:00 |  | 14:49:00 | 04:45 PM | 0:00:00 |  | 8
06/13/2018 | [NAME] |  | [NAME] | 06:04 AM | 06:42:00 |  | 08:20:00 | 12:23:00 |  |  |  |  |  | 3
06/13/2018 | [NAME] |  | Econ |  |  |  | 12:44:00 | 14:20:00 |  | 14:43:00 | 04:50 PM | 0:00:00 |  | 2.5
06/14/2018 | [NAME] |  | Disney | 06:14 AM | 06:43:00 |  | 09:44:00 | 14:58:00 |  | 15:37:00 | 04:39 PM | 0:00:00 |  | 5
06/15/2018 | [NAME] |  | [NAME] | 06:14 AM | 06:32:00 |  | 08:57:00 | 16:19:00 |  | 16:56:00 | 05:05 PM
 | Benjamin Total
06/11/2018 | [NAME] |  | Walmart | 03:45 PM |  | 0:00:00 |  |  |  |  | 12:24 PM | 0:00:00 |  | 74
06/12/2018 | [NAME] |  | Walmart | 05:46 PM |  | 0:00:00 |  |  |  |  | 09:46 AM | 0:00:00
06/13/2018 | [NAME] |  | Walmart | 03:07 PM |  | 0:00:00 | 16:55:00 | 07:55:00 |  | 08:26:00 | 09:07 AM
06/14/2018 | [NAME] |  | Walmart | 05:08 PM | 17:34:00 |  | 19:04:00 | 08:22:00 |  | 09:01:00 | 09:47 AM
06/15/2018 | [NAME] |  | Walmart | 05:38 PM | 18:09:00 |  | 20:39:00 | 08:41:00 |  | 09:00:00 | 09:25:00
2018-06-16 00:00:00 | [NAME] |  | Walmart | 15:54:00 |  | 0:00:00 |  |  |  |  | 17:30:00 | 0:00:00
2018-06-16 00:00:00 | [NAME] |  | Walmart | 19:23:00 | 19:35:00 |  | 19:53:00 | 08:40:00 |  | 09:00:00 | 09:50:00
 | [NAME]
06/10/2018 | [NAME] |  | Walmart | 05:42 PM | 18:19:00 | 0:00:00 |  |  |  | 10:05:00 | 10:25 AM | 0:00:00 |  | 56
06/11/2018 | [NAME] |  | Walmart | 06:01 PM | 18:15:00 |  | 10:40:00 | 06:59:00 |  | 07:05:00 | 07:22 AM
06/12/2018 | [NAME] |  | Walmart | 05:07 PM | 17:12:00 |  | 18:00:00 | 07:17:00 |  | 07:25:00 | 07:31 AM
06/13/2018 | [NAME] |  | Walmart | 05:03 PM | 17:09:00 |  | 17:17:00 | 06:18:00 |  | 06:25:00 | 06:37 AM
06/14/2018 | [NAME] |  | Walmart | 05:09 PM | 17:12:00 |  | 17:20:00 | 18:04:00 |  | 18:29:00 | 06:21 PM | 0:00:00
06/14/2018 | [NAME] |  | Walmart | 07:15 PM | 19:04:00 | 0:00:00 | 19:14:00 | 04:47:00 |  | 10:15:00 | 10:48 AM
 | Brandon Total
06/11/2018 | Dwayne |  | [NAME] | 05:37 AM | 06:32:00 |  | 12:09:00 | 14:34:00 |  |  |  |  |  | 4.5
06/11/2018 | Dwayne |  | Gatherings |  |  |  | 07:06:00 | 07:33:00 | 15:13:00 | 15:13:00 | 04:19 PM |  |  | 2.5
06/12/2018 | Dwayne |  | [NAME] | 05:34 AM | 06:56:00 |  | 08:12:00 | 14:42:00 |  | 15:09:00 | 03:14 PM |  |  | 8
06/13/2018 | Dwayne |  | Econ | 05:39 AM | 06:21:00 |  | 07:20:00 | 15:19:00 |  | 15:40:00 | 03:50 PM |  |  | 6
06/14/2018 | Dwayne |  | Old Audobon | 05:39 AM | 07:07:00 |  | 08:09:00 | 12:31:00 | 13:08:00 | 13:08:00 | 01:30 PM |  |  | 8
06/15/2018 | Dwayne |  | Bartram Trail | 05:43 AM | 06:28:00 |  | 09:00:00 | 15:33:00 |  | 17:51:00 | 06:04 PM |  |  | 5
 | [NAME]
06/10/2018 | Edgar |  | [NAME] | 05:02 PM | 18:15:00 |  | 18:59:00 | 04:44:00 |  | 05:16:00 | 05:24 AM |  |  | 8
06/12/2018 | Edgar |  | Old Audobon | 05:58 AM | 07:04:00 |  | 08:22:00 | 15:07:00 |  | 15:44:00 | 04:00 PM |  |  | 6
06/13/2018 | Edgar |  | Old Audobon | 06:02 AM | 06:07:00 |  | 06:56:00 | 13:16:00 |  | 13:54:00 | 02:25 PM |  |  | 5
06/14/2018 | Edgar |  | [NAME] | 06:02 AM | 06:41:00 |  | 07:59:00 | 14:51:00 |  | 15:27:00 | 03:35 PM |  |  | 6
06/15/2018 | Edgar |  | ASR | 05:56 AM | 06:59:00 |  | 09:35:00 | 13:25:00 |  | 15:33:00 | 04:48 PM | 0:00:00 |  | 6
 | [NAME]
06/10/2018 | Efrain |  | Walmart | 09:05 PM | 18:11:00 | 0:00:00 | 20:18:00 | 05:42:00 |  | 07:42:00 | 07:09 AM | 0:00:00
06/11/2018 | Efrain |  | Walmart | 07:50 PM | 19:11:00 | 0:00:00 | 21:57:00 | 05:21:00 |  | 06:48:00 | 06:15 AM | 0:00:00 |  | 48
06/12/2018 | Efrain |  | Walmart | 07:35 PM | 18:13:00 | 0:00:00 | 21:48:00 | 06:50:00 |  | 08:51:00 | 08:16 AM | 0:00:00
06/13/2018 | Efrain |  | Walmart | 09:26 PM | 18:29:00 | 0:00:00 | 21:48:00 | 06:50:00 |  | 08:51:00 | 08:21 AM | 0:00:00
06/14/2018 | Efrain |  | Walmart | 07:32 PM | 20:26:00 |  | 23:22:00 | 06:59:00 |  | 07:18:00 | 07:27 AM
 | Efrain Total
06/11/2018 | [NAME] |  |  | 04:30 AM |  | 0:00:00 |  |  |  |  | 05:00 PM | 0:00:00
06/12/2018 | [NAME] |  |  | 06:00 AM |  | 0:00:00 |  |  |  |  | 05:00 PM | 0:00:00
06/13/2018 | [NAME] |  | Econ | 06:22 AM | 06:54:00 |  | 07:26:00 | 14:54:00 |  | 15:01:00 | 08:23 PM | 0:00:00 |  | 8
06/15/2018 | [NAME] |  | Bartram Trail | 07:15 AM | 07:43:00 |  | 08:35:00 | 15:30:00 |  | 16:21:00 | 05:19 PM |  |  | 5
 | [NAME]
06/11/2018 | [NAME] |  | CDBG | 06:03 AM | 06:42:00 |  | 07:05:00 | 17:24:00 |  | 18:54:00 | 07:06 PM |  |  | 7
06/12/2018 | [NAME] |  | [NAME] | 06:23 AM | 07:40:00 |  | 08:33:00 | 14:11:00 |  | 14:49:00 | 04:39 PM | 0:00:00 |  | 8
06/13/2018 | [NAME] |  | [NAME] | 06:20 AM | 06:42:00 |  | 08:20:00 | 12:23:00 |  |  |  |  |  | 3
06/13/2018 | [NAME] |  | Econ |  |  |  | 12:44:00 | 14:20:00 |  | 14:43:00 | 04:43 PM | 0:00:00 |  | 2.5
06/14/2018 | [NAME] |  | Disney | 06:13 AM | 06:43:00 |  | 09:44:00 | 14:58:00 |  | 15:37:00 | 04:37 PM | 0:00:00 |  | 5
06/15/2018 | [NAME] |  | [NAME] | 06:21 AM | 06:32:00 |  | 08:57:00 | 16:19:00 |  | 16:56:00 | 05:01 PM |  |  | 6
 | [NAME]
06/10/2018 | Logan |  | Walmart | 05:32 PM | 18:11:00 |  | 20:18:00 | 05:42:00 |  | 07:42:00 | 08:30 AM |  |  | 48
06/11/2018 | Logan |  | Walmart | 06:20 PM | 19:11:00 |  | 21:57:00 | 05:21:00 |  | 06:48:00 | 08:00 AM
06/12/2018 | Logan |  | Walmart | 06:04 PM | 18:13:00 |  | 21:48:00 | 06:50:00 |  | 08:51:00 | 08:17 AM | 0:00:00
06/13/2018 | Logan |  | Walmart | 06:48 PM | 18:29:00 | 0:00:00 | 21:48:00 | 06:50:00 |  | 08:51:00 | 09:17 AM
06/14/2018 | Logan |  | Walmart | 06:12 PM | 20:26:00 |  | 23:22:00 | 06:59:00 |  | 07:18:00 | 07:20 AM
 | Logan Total
06/10/2018 | Nick |  | [NAME] | 17:14:00 | 18:15:00 |  | 18:59:00 | 04:44:00 |  | 05:16:00 | 05:22:00 |  |  | 8
06/12/2018 | Nick |  | Old Audobon | 05:53:00 | 07:04:00 |  | 08:22:00 | 15:07:00 |  | 15:44:00 | 15:56:00 |  |  | 6
06/13/2018 | Nick |  | Old Audobon | 05:53:00 | 06:07:00 |  | 06:56:00 | 13:16:00 |  | 13:54:00 | 14:10:00 |  |  | 5
06/14/2018 | Nick |  | [NAME] | 05:53:00 | 06:41:00 |  | 07:59:00 | 14:51:00 |  | 15:27:00 | 15:32:00 |  |  | 6
 | Nick Total
06/11/2018 | [NAME] |  | [NAME] | 05:55 AM | 06:23:00 |  | 07:10:00 | 14:22:00 |  | 14:54:00 | 04:19 PM |  |  | 8
06/12/2018 | [NAME] |  | [NAME] | 06:03 AM | 08:11:00 | 0:00:00 | 09:07:00 | 14:41:00 |  | 15:13:00 | 04:39 PM | 0:00:00 |  | 8
06/13/2018 | [NAME] |  | Orlando Health | 05:52 AM | 06:48:00 |  | 07:55:00 | 14:00:00 |  | 15:11:00 | 04:29 PM |  |  | 8
06/14/2018 | [NAME] |  | [NAME] | 06:14 AM | 06:48:00 |  | 07:35:00 | 13:30:00 |  | 13:55:00 | 04:26 PM |  |  | 4
06/15/2018 | [NAME] |  | ASR | 05:55 AM | 06:59:00 |  | 09:35:00 | 13:25:00 |  | 15:33:00 | 04:47 PM | 0:00:00 |  | 6
 | Patrick Total
06/10/2018 | [NAME] |  | Walmart | 05:42 PM | 18:19:00 | 0:00:00 |  |  |  | 10:05:00 | 10:25 AM | 0:00:00 |  | 56
06/11/2018 | [NAME] |  | Walmart | 06:01 PM | 18:15:00 |  | 10:40:00 | 06:59:00 |  | 07:05:00 | 07:22 AM
06/12/2018 | [NAME] |  | Walmart | 05:07 PM | 17:12:00 |  | 18:00:00 | 07:17:00 |  | 07:25:00 | 07:30 AM
06/13/2018 | [NAME] |  | Walmart | 05:04 PM | 17:09:00 |  | 17:17:00 | 06:18:00 |  | 06:25:00 | 06:37 AM
06/14/2018 | [NAME] |  | Walmart | 05:09 PM | 17:12:00 |  | 17:20:00 | 18:04:00 |  | 18:29:00 | 06:20 PM | 0:00:00
06/14/2018 | [NAME] |  | Walmart | 07:15 PM | 19:04:00 | 0:00:00 | 19:14:00 | 04:47:00 |  | 10:15:00 | 10:49 AM
 | Rocco Total
06/11/2018 | [NAME] |  | [NAME] | 06:02 AM | 06:23:00 |  | 07:10:00 | 14:22:00 |  | 14:54:00 | 03:58 PM |  |  | 8
06/12/2018 | [NAME] |  | [NAME] | 06:05 AM | 08:11:00 | 0:00:00 | 09:07:00 | 14:41:00 |  | 15:13:00 | 03:33 PM |  |  | 8
06/13/2018 | [NAME] |  | Orlando Health | 06:04 AM | 08:11:00 | 0:00:00 | 09:07:00 | 14:41:00 |  | 15:13:00 | 03:23 PM |  |  | 8
06/14/2018 | [NAME] |  | Old Audobon | 06:13 AM | 07:20:00 |  | 07:59:00 | 12:41:00 |  | 13:10:00 | 01:42 PM |  |  | 8
06/15/2018 | [NAME] |  | BAm | 06:00 AM | 06:59:00 |  | 09:35:00 | 13:25:00 |  | 15:33:00 | 03:48 PM |  |  | 5
 | Ryan Total
06/11/2018 | [NAME] |  | Walmart | 03:45 PM |  | 0:00:00 |  |  |  |  | 12:26 PM | 0:00:00 |  | 74
06/12/2018 | [NAME] |  | Walmart | 05:46 PM |  | 0:00:00 |  |  |  |  | 09:46 AM | 0:00:00
06/13/2018 | [NAME] |  | Walmart | 03:08 PM |  | 0:00:00 | 16:55:00 | 07:55:00 |  | 08:26:00 | 09:06 AM
06/14/2018 | [NAME] |  | Walmart | 05:05 PM | 17:34:00 |  | 19:04:00 | 08:22:00 |  | 09:01:00 | 09:47 AM
06/15/2018 | [NAME] |  | Walmart | 05:38 PM | 18:09:00 |  | 20:39:00 | 08:41:00 |  | 09:00:00 | 09:34:00
06/15/2018 | [NAME] |  | Walmart | 15:55:00 |  | 0:00:00 |  |  |  |  | 17:30:00 | 0:00:00
2018-06-16 00:00:00 | [NAME] |  | Walmart | 19:22:00 | 18:09:00 | 0:00:00 | 20:39:00 | 08:41:00 |  | 09:00:00 | 09:34:00
 | [NAME]
06/12/2018 | Terrance |  | [NAME] | 06:13 AM | 08:11:00 | 0:00:00 | 09:07:00 | 14:41:00 | 5:34:00 | 15:13:00 | 04:45 PM |  |  | 8 | 1
06/13/2018 | Terrance |  | Orlando Health | 05:52 AM | 06:48:00 | 0:34:00 | 07:35:00 | 13:30:00 | 5:55:00 | 13:55:00 | 05:05 PM |  |  | 8
06/14/2018 | Terrance |  | Old Audobon | 05:56 AM | 07:20:00 |  | 07:59:00 | 12:41:00 |  | 13:10:00 | 01:47 PM |  |  | 8
06/15/2018 | Terrance |  | [NAME] | 06:40 AM | 06:48:00 |  | 07:35:00 | 13:30:00 |  | 13:55:00 | 02:16 PM |  |  | 6
 | Terrance Total
06/11/2018 | [NAME] |  | Walmart | 05:29 PM |  | 0:00:00 |  |  |  |  | 12:24 PM | 0:00:00 |  | 74
06/12/2018 | [NAME] |  | Walmart | 05:28 PM |  | 0:00:00 |  |  |  |  | 09:46 AM | 0:00:00 | 1
06/13/2018 | [NAME] |  | Walmart | 03:02 PM |  | 0:00:00 | 16:55:00 | 07:55:00 |  | 08:26:00 | 09:06 AM
06/14/2018 | [NAME] |  | Walmart | 05:06 PM | 17:34:00 |  | 19:04:00 | 08:22:00 |  | 09:01:00 | 09:43 AM
06/15/2018 | [NAME] |  | Walmart | 05:22 PM | 18:09:00 |  | 20:39:00 | 08:41:00 |  | 09:00:00 | 09:34:00
2018-06-16 00:00:00 | [NAME] |  | Walmart | 14:59:00 |  | 0:00:00 |  |  |  |  | 17:30:00 | 0:00:00
2018-06-16 00:00:00 | [NAME] |  | Walmart | 20:38:00 | 19:35:00 | 0:00:00 | 19:53:00 | 08:40:00 |  | 09:00:00 | 10:01:00
 | [NAME]
06/11/2018 | [NAME] |  | [NAME] | 06:00 AM | 09:48:00 |  | 10:39:00 | 14:22:00 |  | 15:39:00 | 03:45 PM |  |  | 8
06/12/2018 | [NAME] |  | [NAME] | 06:00 AM | 06:18:00 |  | 07:11:00 | 14:22:00 |  | 15:26:00 | 03:45 PM |  |  | 8
06/13/2018 | [NAME] |  | [NAME] | 06:00 AM | 06:14:00 |  | 07:01:00 | 17:12:00 |  | 17:21:00 | 06:00 PM |  |  | 8
06/14/2018 | [NAME] |  | [NAME] | 06:00 AM | 06:14:00 |  | 06:54:00 | 17:11:00 |  | 17:55:00 | 06:00 PM |  |  | 6
06/15/2018 | [NAME] |  | [NAME] | 06:00 AM | 06:15:00 |  | 07:57:00 | 13:43:00 |  | 14:22:00 | 02:30 PM |  |  | 6
 | Willie S Total
06/12/2018 | Willie |  | [NAME] | 05:57 AM | 06:18:00 |  | 07:11:00 | 15:22:00 |  | 15:36:00 | 03:10 PM | 0:00:00 |  | 8 | 1
06/13/2018 | Willie |  | Econ | 06:01 AM | 06:21:00 |  | 07:20:00 | 15:19:00 |  | 15:40:00 | 03:18 PM | 0:00:00 |  | 6
06/14/2018 | Willie |  | Disney | 05:51 AM | 07:02:00 |  | 08:13:00 | 14:36:00 |  | 15:23:00 | 03:28 PM |  |  | 2
06/15/2018 | Willie |  | [NAME] | 06:40 AM | 06:48:00 |  | 07:35:00 | 13:30:00 |  | 13:55:00 | 02:15 PM |  |  | 6
 | Willie Total
06/10/2018 | Zachary |  | [NAME] | 05:32 PM | 18:15:00 |  | 18:59:00 | 04:44:00 |  | 05:16:00 | 05:18 AM |  |  | 8
06/12/2018 | Zachary |  | Old Audobon | 05:54 AM | 07:04:00 |  | 08:22:00 | 15:07:00 |  | 15:44:00 | 03:56 PM |  |  | 8
06/13/2018 | Zachary |  | Old Audobon | 05:54 AM | 06:07:00 |  | 06:56:00 | 13:16:00 |  | 13:54:00 | 02:10 PM |  |  | 5
06/14/2018 | Zachary |  | [NAME] | 05:53 AM | 06:41:00 |  | 07:59:00 | 14:51:00 |  | 15:27:00 | 03:34 PM |  |  | 6
06/15/2018 | Zachary |  | Bam | 05:53 AM | 06:59:00 |  | 09:35:00 | 13:25:00 |  | 15:33:00 | 04:07 PM |  |  | 5
 | Zachary Total
 | Grand Total