Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 04152018-04212018

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
2018-04-16 00:00:00 | [NAME] |  | Longwood Septic | 05:48:00 | 07:00:00 |  | 08:05:00 | 15:24:00 |  | 15:55:00 | 15:59:00 |  |  | 5
2018-04-17 00:00:00 | [NAME] |  | Bainbridge | 05:40:00 | 07:17:00 |  |  |  |  |  |  |  |  | 4
2018-04-17 00:00:00 | [NAME] |  | AFCO |  |  |  | 14:31:00 | 17:03:00 |  | 18:10:00 | 18:18:00 |  |  | 6
2018-04-18 00:00:00 | [NAME] |  | ABC | 05:51:00 | 06:31:00 |  | 07:40:00 | 16:09:00 |  | 17:03:00 | 17:04:00 |  |  | 4
2018-04-19 00:00:00 | [NAME] |  | Silver Start | 05:45:00 | 07:18:00 |  | 10:50:00 | 12:58:00 |  | 13:32:00 | 13:46:00 |  |  | 3
2018-04-20 00:00:00 | [NAME] |  | Shop | 05:36:00 |  | 00:00:00 |  |  |  |  | 13:47:00 | 00:00:00
 | Allen Total
2018-04-16 00:00:00 | [NAME] |  | Shop | 07:25:00 |  |  |  |  |  |  | 13:17:00 | 00:00:00 |  | 24
2018-04-17 00:00:00 | [NAME] |  | [NAME] | 10:19:00 |  | 00:00:00 |  |  |  |  | 15:58:00 | 00:00:00
2018-04-18 00:00:00 | [NAME] |  | [NAME] | 06:55:00 | 07:26:00 |  | 09:35:00 | 18:13:00 |  | 18:48:00 | 18:54:00 |  |  | 8
2018-04-19 00:00:00 | [NAME] |  | I 295 | 19:21:00 | 19:52:00 |  | 20:22:00 | 03:36:00 |  | 03:42:00 | 04:19:00
 | [NAME]
2018-04-16 00:00:00 | [NAME] |  | Adventist Health | 05:57:00 |  |  |  |  |  |  | 16:32:00 | 00:00:00 |  | 8
2018-04-17 00:00:00 | [NAME] |  | Maitland | 06:02:00 | 07:33:00 |  | 08:46:00 | 15:09:00 |  | 15:38:00 | 16:37:00 |  |  | 6
2018-04-18 00:00:00 | [NAME] |  | ABC | 05:56:00 | 06:51:00 |  | 07:30:00 | 16:07:00 |  | 16:52:00 | 16:55:00
2018-04-19 00:00:00 | [NAME] |  | Silver Start | 06:01:00 | 07:18:00 |  | 10:50:00 | 12:58:00 |  | 13:32:00 | 16:28:00 | 00:00:00 |  | 3
2018-04-20 00:00:00 | [NAME] |  |  | 06:07:00 |  | 00:00:00 |  |  |  |  | 10:07:00 | 00:00:00
 | [NAME]
2018-04-16 00:00:00 | [NAME] |  | Longwood Septic | 06:01:00 | 07:00:00 |  | 08:05:00 | 15:24:00 |  | 15:55:00 | 16:28:00 |  |  | 5
2018-04-17 00:00:00 | [NAME] |  | Bainbridge | 06:04:00 | 07:17:00 |  | 08:32:00 | 14:06:00 |  |  |  |  |  | 4
2018-04-17 00:00:00 | [NAME] |  | AFCO |  |  |  | 14:31:00 | 17:03:00 |  | 18:10:00 | 20:13:00 | 00:00:00 |  | 6
2018-04-18 00:00:00 | [NAME] |  | Alligator | 03:20:00 | 04:11:00 |  | 08:54:00 | 17:47:00 |  | 18:13:00 | 18:31:00 |  |  | 8
2018-04-19 00:00:00 | [NAME] |  | Alligator | 06:21:00 | 07:02:00 |  | 07:40:00 | 16:01:00 |  | 21:01:00 | 21:11:00 |  |  | 8
2018-04-20 00:00:00 | [NAME] |  | Shop | 05:57:00 |  | 00:00:00 |  |  |  |  | 17:30:00 | 00:00:00
 | [NAME]
2018-04-17 00:00:00 | [NAME] |  | Walmart | 18:06:00 | 18:29:00 |  | 21:20:00 | 04:48:00 |  | 06:55:00 | 07:26:00
2018-04-18 00:00:00 | [NAME] |  | Walmart | 18:10:00 | 18:33:00 |  | 21:11:00 | 04:48:00 |  | 06:55:00 | 09:26:00 | 00:00:00
2018-04-19 00:00:00 | [NAME] |  | Walmart | 18:07:00 | 18:15:00 |  | 21:33:00 | 06:09:00 |  | 08:18:00 | 08:40:00
 | Brandon Total
2018-04-16 00:00:00 | Dwayne |  | Adventist Health | 05:46:00 | 06:30:00 |  | 09:18:00 | 10:39:00 |  | 13:01:00 | 13:10:00 |  |  | 8
2018-04-17 00:00:00 | Dwayne |  | Maitland | 05:46:00 | 06:33:00 |  | 07:49:00 | 15:08:00 |  | 15:38:00 | 15:54:00 |  |  | 5
2018-04-18 00:00:00 | Dwayne |  | ABC | 05:43:00 | 06:31:00 |  | 07:40:00 | 16:09:00 |  | 17:03:00 | 17:12:00 |  |  | 4
2018-04-19 00:00:00 | Dwayne |  | Maitland | 05:48:00 | 06:51:00 |  | 07:42:00 | 14:04:00 |  | 14:35:00 | 17:12:00 | 00:00:00 |  | 5
2018-04-20 00:00:00 | Dwayne |  | Champions | 05:43:00 | 06:36:00 |  | 08:09:00 | 13:30:00 |  | 14:20:00 | 15:31:00 | 00:00:00 |  | 4 | 1
 | [NAME]
2018-04-16 00:00:00 | Edgar |  | Narcoossee Warehouse | 05:59:00 | 06:33:00 |  | 07:48:00 | 09:41:00 |  |  |  |  |  | 1
2018-04-16 00:00:00 | Edgar |  | Retreat at Lake Brantley |  |  |  | 10:22:00 | 10:28:00 |  | 11:05:00 | 15:07:00 | 00:00:00 |  | 8
2018-04-17 00:00:00 | Edgar |  | AFCO | 06:03:00 | 06:43:00 |  | 08:06:00 | 16:29:00 |  | 17:31:00 | 17:37:00 |  |  | 6
2018-04-18 00:00:00 | Edgar |  | [NAME] | 05:54:00 | 06:17:00 |  | 09:10:00 | 15:08:00 |  | 17:10:00 | 17:21:00 |  |  | 6
2018-04-19 00:00:00 | Edgar |  | Maitland | 05:57:00 | 06:53:00 |  | 07:42:00 | 14:02:00 |  | 14:27:00 | 14:44:00 |  |  | 5
2018-04-20 00:00:00 | Edgar |  | [NAME] | 05:57:00 | 06:56:00 |  | 08:00:00 | 10:32:00 |  |  |  |  |  | 2.5
2018-04-20 00:00:00 | Edgar |  | Champions |  |  |  | 11:10:00 | 13:59:00 |  | 15:07:00 | 15:36:00 |  |  | 4
 | [NAME]
2018-04-16 00:00:00 | Efrain |  | Walmart | 20:27:00 | 18:30:00 | 00:00:00 | 22:38:00 | 07:15:00 |  | 10:02:00 | 10:05:00 |  |  | 36
2018-04-17 00:00:00 | Efrain |  | Walmart | 18:26:00 | 19:45:00 |  | 22:27:00 | 06:09:00 |  | 08:44:00 | 08:47:00
2018-04-18 00:00:00 | Efrain |  | Walmart | 18:15:00 | 18:53:00 |  | 22:18:00 | 04:31:00 |  | 06:23:00 | 06:54:00
2018-04-19 00:00:00 | Efrain |  | Walmart | 18:15:00 | 19:14:00 |  | 20:40:00 | 05:14:00 |  | 05:43:00 | 06:01:00
 | Efrain Total
2018-04-17 00:00:00 | Javarious |  | Bainbridge | 06:00:00 | 07:17:00 |  | 08:32:00 | 14:06:00 |  |  |  |  |  | 6
2018-04-17 00:00:00 | Javarious |  | AFCO |  |  |  | 14:31:00 | 17:03:00 |  | 18:10:00 | 18:15:00
2018-04-18 00:00:00 | Javarious |  | Fish | 06:00:00 | 07:24:00 |  | 07:57:00 | 12:06:00 |  | 12:48:00 | 14:00:00 | 00:00:00 |  | 1
2018-04-19 00:00:00 | Javarious |  | Maitland City | 06:09:00 | 06:29:00 |  | 07:10:00 | 10:46:00 |  | 11:16:00 | 15:35:00 | 00:00:00 |  | 8
2018-04-20 00:00:00 | Javarious |  | Champions | 06:08:00 | 06:44:00 |  | 08:19:00 | 10:22:00 |  | 11:12:00 | 14:01:00 | 00:00:00 |  | 4 | 1
 | Javarious Total
2018-04-16 00:00:00 | [NAME] |  | Shop | 08:22:00 |  |  |  |  |  |  | 19:31:00 | 00:00:00
2018-04-17 00:00:00 | [NAME] |  | Shop | 06:14:00 |  | 00:00:00 |  |  |  |  | 19:02:00 | 00:00:00
2018-04-18 00:00:00 | [NAME] |  | Fish | 06:01:00 | 07:24:00 |  | 07:57:00 | 12:06:00 |  | 12:48:00 | 13:23:00 |  |  | 1
2018-04-19 00:00:00 | [NAME] |  | I 295 | 19:53:00 | 19:52:00 | 00:00:00 | 20:22:00 | 03:36:00 |  | 03:42:00 | 04:32:00
 | [NAME]
2018-04-16 00:00:00 | [NAME] |  | Narcoossee Warehouse | 05:45:00 | 06:33:00 |  | 07:48:00 | 09:41:00 |  |  |  |  |  | 1
2018-04-16 00:00:00 | [NAME] |  | Retreat at Lake Brantley |  |  |  | 10:22:00 | 10:28:00 |  | 11:05:00 | 16:25:00 | 00:00:00 |  | 8
2018-04-17 00:00:00 | [NAME] |  | Bainbridge | 05:46:00 | 07:17:00 |  |  |  |  |  |  |  |  | 4
2018-04-17 00:00:00 | [NAME] |  | AFCO |  |  |  | 14:31:00 | 17:03:00 |  | 18:10:00 | 20:11:00 | 00:00:00 |  | 6
2018-04-18 00:00:00 | [NAME] |  | Alligator | 03:29:00 | 04:11:00 |  | 08:54:00 | 17:47:00 |  | 18:13:00 | 18:31:00 |  |  | 8
2018-04-19 00:00:00 | [NAME] |  | Alligator | 06:20:00 | 07:02:00 |  | 07:40:00 | 16:01:00 |  | 21:01:00 | 21:10:00 |  |  | 8
2018-04-20 00:00:00 | [NAME] |  | Champions | 06:02:00 | 06:36:00 |  | 08:09:00 | 13:30:00 |  | 14:20:00 | 17:01:00 | 00:00:00 |  | 4
 | [NAME]
2018-04-16 00:00:00 | [NAME] |  | USPS Davenport | 05:57:00 | 07:20:00 |  | 09:29:00 | 15:54:00 |  | 17:12:00 | 17:16:00 |  |  | 8
2018-04-17 00:00:00 | [NAME] |  | USPS Davenport | 05:53:00 | 07:25:00 |  | 09:15:00 | 12:07:00 |  | 19:10:00 | 19:28:00 |  |  | 6
2018-04-18 00:00:00 | [NAME] |  | Shop | 15:06:00 |  | 00:00:00 |  |  |  |  | 16:46:00 | 00:00:00
2018-04-19 00:00:00 | [NAME] |  | USPS Davenport | 04:00:00 | 05:00:00 |  | 06:39:00 | 13:33:00 |  | 15:13:00 | 15:23:00 |  |  | 7
2018-04-20 00:00:00 | [NAME] |  | Shop | 05:54:00 |  | 00:00:00 |  |  |  |  | 17:30:00 | 00:00:00
 | [NAME]
2018-04-16 00:00:00 | Lindsey |  | Adventist Health | 05:50:00 | 06:30:00 |  | 09:18:00 | 10:39:00 |  | 13:01:00 | 13:35:00 |  |  | 8
2018-04-17 00:00:00 | Lindsey |  | Maitland | 05:50:00 | 06:33:00 |  | 07:49:00 | 15:08:00 |  | 15:38:00 | 16:01:00 |  |  | 5
 | Lindsey Total
2018-04-16 00:00:00 | Logan |  | Walmart Deland | 18:25:00 | 19:03:00 |  | 20:33:00 | 23:19:00 |  |  |  |  |  | 2
2018-04-16 00:00:00 | Logan |  | Walmart | 18:25:00 | 19:07:00 |  | 21:57:00 | 04:54:00 |  | 07:03:00 | 07:30:00 |  |  | 36
2018-04-17 00:00:00 | Logan |  | Walmart | 19:06:00 | 20:01:00 |  | 22:50:00 | 07:51:00 |  | 09:40:00 | 09:46:00
2018-04-18 00:00:00 | Logan |  | Walmart | 18:18:00 | 19:39:00 |  | 21:56:00 | 05:41:00 |  | 07:42:00 | 07:48:00
2018-04-19 00:00:00 | Logan |  | Walmart | 17:22:00 | 18:11:00 |  | 21:16:00 | 03:09:00 |  | 04:57:00 | 05:14:00
 | Logan Total
2018-04-16 00:00:00 | Nick |  | Narcoossee Warehouse | 05:59:00 | 06:33:00 |  | 07:48:00 | 09:41:00 |  |  |  |  |  | 1
2018-04-16 00:00:00 | Nick |  | Retreat at Lake Brantley |  |  |  | 10:22:00 | 10:28:00 |  | 11:05:00 | 14:31:00 | 00:00:00 |  | 8
2018-04-17 00:00:00 | Nick |  | AFCO | 05:57:00 | 06:43:00 |  | 08:06:00 | 16:29:00 |  | 17:31:00 | 17:35:00 |  |  | 6
2018-04-18 00:00:00 | Nick |  | [NAME] | 06:01:00 | 06:17:00 |  | 09:10:00 | 15:08:00 |  | 17:10:00 | 17:16:00 |  |  | 6
2018-04-19 00:00:00 | Nick |  | Maitland | 06:14:00 | 06:53:00 |  | 07:42:00 | 14:02:00 |  | 14:27:00 | 14:31:00 |  |  | 5
2018-04-20 00:00:00 | Nick |  | [NAME] | 05:57:00 | 06:56:00 |  | 08:00:00 | 10:32:00 |  |  |  |  |  | 2.5
2018-04-20 00:00:00 | Nick |  | Champions |  |  |  | 11:10:00 | 13:59:00 |  | 15:07:00 | 15:35:00 |  |  | 4
 | Nick Total
2018-04-16 00:00:00 | [NAME] |  | Walmart Deland | 18:25:00 | 19:03:00 |  | 20:33:00 | 23:19:00 |  |  |  |  |  | 2
2018-04-16 00:00:00 | [NAME] |  | Winn Dixie |  |  |  | 13:20:00 | 07:43:00 |  | 09:36:00 | 10:28:00 |  |  | 36
2018-04-17 00:00:00 | [NAME] |  | Walmart | 19:07:00 | 20:01:00 |  | 22:50:00 | 07:51:00 |  | 09:40:00 | 09:46:00
2018-04-18 00:00:00 | [NAME] |  | Walmart | 18:18:00 | 19:39:00 |  | 21:56:00 | 05:41:00 |  | 07:42:00 | 07:53:00
2018-04-19 00:00:00 | [NAME] |  | Walmart | 17:22:00 | 18:11:00 |  | 21:16:00 | 03:09:00 |  | 04:57:00 | 05:15:00
 | [NAME]
2018-04-16 00:00:00 | [NAME] |  | Walmart | 18:10:00 | 19:07:00 |  | 21:57:00 | 04:54:00 |  | 07:03:00 | 07:28:00 |  |  | 36
2018-04-17 00:00:00 | [NAME] |  | Walmart | 18:06:00 | 18:29:00 |  | 21:20:00 | 04:48:00 |  | 06:55:00 | 07:25:00
2018-04-18 00:00:00 | [NAME] |  | Walmart | 18:11:00 | 18:33:00 |  | 21:11:00 | 04:48:00 |  | 06:55:00 | 09:27:00 | 00:00:00
2018-04-19 00:00:00 | [NAME] |  | Walmart | 18:08:00 | 18:15:00 |  | 21:33:00 | 06:09:00 |  | 08:18:00 | 08:39:00
 | Rocco Total
2018-04-17 00:00:00 | Sergio |  | AFCO | 05:59:00 | 08:02:00 |  | 09:15:00 | 12:07:00 |  |  |  | 00:00:00
2018-04-17 00:00:00 | Sergio |  | Ashton Station |  |  |  | 12:53:00 | 15:00:00 |  |  |  | 00:00:00
2018-04-17 00:00:00 | Sergio |  | AFCO |  |  |  | 15:27:00 | 17:00:00 |  | 18:09:00 | 19:22:00
2018-04-18 00:00:00 | Sergio |  | ABC | 05:57:00 | 07:46:00 |  | 09:34:00 | 16:27:00 |  | 17:07:00 | 18:06:00 |  |  | 4
2018-04-19 00:00:00 | Sergio |  | ABC | 06:01:00 | 07:15:00 |  | 07:47:00 | 09:58:00 |  |  |  |  |  | 2
2018-04-19 00:00:00 | Sergio |  | AFCO | 06:01:00 |  | 00:00:00 | 10:52:00 | 15:02:00 |  | 15:56:00 | 16:37:00 |  |  | 6
 | Sergio Total
2018-04-15 00:00:00 | [NAME] |  | Walmart | 18:41:00 | 19:22:00 |  | 22:40:00 | 03:54:00 |  | 05:58:00 | 06:08:00 |  |  | 36
2018-04-16 00:00:00 | [NAME] |  | Walmart | 18:15:00 | 18:30:00 |  | 22:38:00 | 07:15:00 |  | 10:02:00 | 10:06:00
2018-04-17 00:00:00 | [NAME] |  | Walmart | 18:26:00 | 19:45:00 |  | 22:27:00 | 06:09:00 |  | 08:44:00 | 08:49:00
2018-04-18 00:00:00 | [NAME] |  | Walmart | 18:15:00 | 18:53:00 |  | 22:18:00 | 04:31:00 |  | 06:23:00 | 07:54:00
2018-04-19 00:00:00 | [NAME] |  | Walmart | 18:15:00 | 19:14:00 |  | 20:40:00 | 05:14:00 |  | 05:43:00 | 06:05:00
 | [NAME]
2018-04-16 00:00:00 | TJ |  | USPS Davenport | 06:04:00 | 07:20:00 |  | 09:29:00 | 15:54:00 |  | 17:12:00 | 17:28:00 |  |  | 8
2018-04-17 00:00:00 | TJ |  | USPS Davenport | 06:56:00 | 07:25:00 |  | 10:56:00 | 18:22:00 |  | 19:10:00 | 19:29:00 |  |  | 6
2018-04-18 00:00:00 | TJ |  | Shop | 15:38:00 |  | 00:00:00 |  |  |  |  | 16:51:00 | 00:00:00
2018-04-19 00:00:00 | tj |  | USPS Davenport | 04:00:00 | 05:00:00 |  | 06:39:00 | 13:33:00 |  | 15:13:00 | 15:33:00 |  |  | 7
2018-04-20 00:00:00 | TJ |  | Shop | 06:07:00 |  | 00:00:00 |  |  |  |  | 18:08:00 | 00:00:00
 | TJ Total
2018-04-16 00:00:00 | [NAME] |  | Walmart Deland | 18:11:00 | 19:03:00 |  | 20:33:00 | 23:19:00 |  |  |  |  |  | 2
2018-04-16 00:00:00 | [NAME] |  | Winn Dixie |  |  |  | 13:20:00 | 07:43:00 |  | 09:36:00 | 09:45:00 |  |  | 36
2018-04-17 00:00:00 | [NAME] |  | Walmart | 18:29:00 | 20:01:00 |  | 22:50:00 | 07:51:00 |  | 09:40:00 | 09:51:00
2018-04-18 00:00:00 | [NAME] |  | Walmart | 18:01:00 | 19:39:00 |  | 21:56:00 | 05:41:00 |  | 07:42:00 | 07:47:00
2018-04-19 00:00:00 | [NAME] |  | Walmart | 17:24:00 | 18:11:00 |  | 21:16:00 | 03:09:00 |  | 04:57:00 | 05:15:00
 | [NAME]
2018-04-16 00:00:00 | Willie |  | Adventist Health | 06:14:00 |  |  |  |  |  |  | 12:39:00 | 00:00:00 |  | 8
2018-04-17 00:00:00 | Willie |  | AFCO | 05:48:00 | 06:43:00 |  | 08:06:00 | 16:29:00 |  | 17:31:00 | 17:28:00 | 00:00:00 |  | 6
2018-04-18 00:00:00 | Willie |  | ABC | 05:44:00 | 06:51:00 |  | 07:30:00 | 16:07:00 |  | 16:52:00 | 16:51:00 | 00:00:00
2018-04-19 00:00:00 | Willie |  | Silver Start | 05:44:00 | 07:18:00 |  | 10:50:00 | 12:58:00 |  | 13:32:00 | 13:38:00 |  |  | 3
2018-04-20 00:00:00 | Willie |  | Champions | 05:51:00 | 06:44:00 |  | 08:19:00 | 10:22:00 |  | 11:12:00 | 14:28:00 | 00:00:00 |  | 4
 | Willie Total
2018-04-16 00:00:00 | [NAME] |  | Adventist Health | 06:00:00 |  |  |  |  |  |  | 10:00:00 | 00:00:00 |  | 8
2018-04-20 00:00:00 | Willie s |  | Maitland City | 06:00:00 | 06:29:00 |  | 07:10:00 | 10:46:00 |  | 11:16:00 | 11:35:00 |  |  | 8 | 2
 | Willie S Total
 | Grand Total