Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 02192018-02242018

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
2018-02-19 00:00:00 | [NAME] |  |  | 05:48:00 | 07:12:00 |  | 07:35:00 | 09:33:00
2018-02-19 00:00:00 | [NAME] |  |  |  |  |  | 11:15:00 | 13:12:00 |  | 14:39:00 | 15:01:00
2018-02-20 00:00:00 | [NAME] |  |  | 05:48:00 | 06:33:00 |  | 08:04:00 | 14:28:00 |  |  | 15:10:00 | 00:00:00
2018-02-21 00:00:00 | [NAME] |  | Yates | 05:50:00 | 06:35:00 |  | 07:13:00 | 09:17:00
2018-02-21 00:00:00 | [NAME] |  | Corando |  |  |  | 10:55:00 | 12:02:00 |  | 13:05:00 | 18:58:00
2018-02-22 00:00:00 | [NAME] |  |  | 05:51:00 | 07:24:00 |  | 08:25:00 | 14:46:00 |  | 15:24:00 | 15:27:00
2018-02-23 00:00:00 | [NAME] |  |  | 05:50:00 | 06:50:00 |  | 08:16:00 | 13:07:00 |  | 13:58:00 | 14:05:00
 | Allen Total
2018-02-20 00:00:00 | [NAME] |  | I-295 | 07:12:00 | 09:00:00 |  | 09:57:00 | 15:19:00 |  | 15:40:00 | 15:47:00
2018-02-21 00:00:00 | [NAME] |  | I-295 | 07:12:00 | 08:06:00 |  | 08:51:00 | 13:39:00 |  | 15:49:00 | 16:06:00
2018-02-22 00:00:00 | [NAME] |  |  | 07:30:00 | 08:13:00 |  | 08:24:00 | 16:22:00 |  | 16:35:00 | 16:54:00
2018-02-23 00:00:00 | [NAME] |  | I-295 | 07:13:00 | 08:17:00 |  | 08:55:00 | 15:57:00 |  | 16:04:00 | 16:40:00
 | [NAME]
2018-02-19 00:00:00 | [NAME] |  | Ridgewood Lake | 05:58:00 | 06:27:00 |  | 08:44:00 | 12:27:00 |  | 13:37:00 | 15:46:00
2018-02-20 00:00:00 | [NAME] |  | Drive Shack | 06:01:00 | 06:37:00 |  | 07:50:00 | 14:19:00 |  | 14:49:00 | 16:00:00
2018-02-21 00:00:00 | [NAME] |  | Jehovah | 05:58:00 | 06:38:00 |  | 08:19:00 | 12:39:00 |  | 13:58:00 | 16:33:00
2018-02-22 00:00:00 | [NAME] | 2 | Firestation 62 | 05:56:00 | 07:24:00 |  | 08:25:00 | 14:46:00 |  | 15:24:00 | 15:44:00
2018-02-23 00:00:00 | [NAME] | 2 | Easy Foods | 05:58:00 | 06:50:00 |  | 08:16:00 | 13:07:00 |  | 13:58:00 | 15:48:00
 | [NAME]
2018-02-19 00:00:00 | [NAME] |  | Shop | 05:57:00 |  |  |  |  |  |  | 14:53:00 | 00:00:00
2018-02-20 00:00:00 | [NAME] |  |  | 05:50:00 |  |  |  |  |  |  | 14:57:00
2018-02-21 00:00:00 | [NAME] | 4 | Firestation 62 | 05:59:00 | 06:50:00 |  | 08:37:00 | 12:31:00 |  | 13:01:00 | 15:56:00
2018-02-22 00:00:00 | [NAME] |  | I-295 | 06:01:00 | 07:04:00 |  | 10:02:00 | 14:03:00 |  | 16:30:00 | 16:35:00
2018-02-23 00:00:00 | [NAME] |  | Easy Foods | 05:55:00 | 06:50:00 |  | 07:05:00 | 13:07:00 |  | 13:58:00 | 15:13:00
 | Anthony Total
2018-02-19 00:00:00 | [NAME] |  | Lake Sylvan | 06:03:00 | 07:12:00 |  | 07:35:00 | 09:33:00
2018-02-19 00:00:00 | [NAME] |  | Firestation 62 |  |  |  | 11:15:00 | 13:12:00 |  | 14:39:00 | 15:43:00
2018-02-20 00:00:00 | [NAME] |  | B52 | 06:01:00 | 06:33:00 |  | 08:04:00 | 14:28:00 |  | 15:07:00 | 15:15:00
 | [NAME]
2018-02-19 00:00:00 | [NAME] |  |  | 18:02:00 | 18:35:00 |  | 19:37:00 | 03:51:00 |  | 04:36:00 | 04:41:00
2018-02-20 00:00:00 | [NAME] |  | Walmart | 18:00:00 | 18:30:00 |  | 19:39:00 | 06:32:00 |  | 07:17:00 | 07:27:00
2018-02-21 00:00:00 | [NAME] |  | Walmart | 18:12:00 | 19:06:00 |  | 20:28:00 | 03:41:00 |  | 06:47:00 | 07:22:00
2018-02-22 00:00:00 | [NAME] |  | Walmart | 18:05:00 | 18:26:00 |  | 20:02:00 | 06:32:00 |  | 07:28:00 | 07:43:00
 | Brandon Total
2018-02-19 00:00:00 | Dwayne |  | Sadler Plaza | 05:46:00 | 07:25:00 |  | 10:54:00 | 17:09:00 |  | 18:48:00 | 18:56:00
2018-02-20 00:00:00 | Dwayne |  | Sadler Plaza | 04:49:00 | 05:06:00 |  | 08:29:00 | 14:47:00 |  | 17:43:00 | 17:49:00
2018-02-21 00:00:00 | Dwayne |  | Lucaya Lake | 05:50:00 | 06:36:00 |  | 09:27:00 | 12:03:00 |  | 13:14:00 | 13:24:00
 | [NAME]
2018-02-19 00:00:00 | Edgar |  |  | 06:00:00 | 07:25:00 |  | 10:54:00 | 17:09:00 |  | 18:48:00 | 18:54:00
2018-02-20 00:00:00 | Edgar |  |  | 06:00:00 | 06:43:00 |  | 08:04:00 | 16:42:00 |  | 17:22:00 | 17:41:00
2018-02-21 00:00:00 | Edgar |  |  | 06:00:00 | 06:36:00 |  | 07:52:00 | 11:43:00 |  | 12:37:00 | 13:59:00
2018-02-22 00:00:00 | Edgar | 8 |  | 06:02:00 | 06:42:00 |  | 08:07:00 | 17:06:00 |  | 19:25:00 | 19:28:00
2018-02-23 00:00:00 | Edgar | 8 |  | 05:58:00 | 06:59:00 |  | 08:27:00 | 13:46:00 |  | 14:45:00 | 15:53:00
 | [NAME]
2018-02-19 00:00:00 | Efrain |  |  | 17:51:00 | 18:14:00 |  | 20:04:00 | 06:03:00 |  | 06:44:00 | 06:50:00
2018-02-20 00:00:00 | Efrain |  | Walmart | 18:09:00 | 18:39:00 |  | 20:01:00 | 06:03:00 |  | 07:44:00 | 08:32:00
2018-02-21 00:00:00 | Efrain |  | Walmart | 17:56:00 | 18:20:00 |  | 18:50:00 | 06:02:00 |  | 06:29:00 | 07:15:00
2018-02-22 00:00:00 | Efrain |  | Walmart | 18:29:00 | 18:36:00 |  | 19:39:00 | 06:58:00 |  | 07:29:00 | 07:47:00
 | Efrain Total
2018-02-19 00:00:00 | [NAME] |  |  | 07:08:00 | 10:48:00 |  | 11:42:00 | 14:46:00 |  | 14:53:00 | 14:53:00
2018-02-20 00:00:00 | [NAME] |  |  | 05:43:00 | 07:42:00 |  | 09:36:00 | 11:39:00 |  | 12:51:00 | 18:38:00
2018-02-21 00:00:00 | [NAME] |  | Corando | 06:00:00 | 06:35:00 |  | 07:13:00 | 09:17:00
2018-02-21 00:00:00 | [NAME] |  | Yates | 06:00:00 |  |  | 10:55:00 | 12:02:00 |  | 14:10:00 | 18:58:00
2018-02-22 00:00:00 | [NAME] | 1 | [NAME] | 06:06:00 | 06:52:00 |  | 09:29:00 | 13:07:00 |  | 15:24:00 | 17:40:00
2018-02-23 00:00:00 | [NAME] |  | 21 West Jersey | 06:00:00 | 06:40:00 |  | 07:01:00 | 11:32:00
2018-02-23 00:00:00 | [NAME] |  | Easy Foods |  |  |  | 12:01:00 | 12:50:00 |  | 14:02:00 | 14:35:00
 | [NAME]
2018-02-20 00:00:00 | Lindsey |  |  | 04:59:00 | 05:06:00 |  | 08:29:00 | 14:47:00 |  | 17:43:00 | 17:48:00
2018-02-21 00:00:00 | Lindsey |  |  | 05:50:00 | 06:36:00 |  | 09:27:00 | 12:03:00 |  | 13:14:00 | 14:45:00
2018-02-22 00:00:00 | Lindsey | 2 |  | 05:51:00 | 07:24:00 |  | 08:25:00 | 14:46:00 |  | 15:24:00 | 15:44:00
2018-02-23 00:00:00 | Lindsey | 5 |  | 05:50:00 | 06:27:00 |  | 07:41:00 | 11:33:00 |  | 12:02:00 | 12:10:00
 | Lindsey Total
2018-02-19 00:00:00 | Logan |  |  | 06:12:00 | 06:48:00 |  | 07:14:00 | 14:09:00 |  | 14:43:00 | 15:59:00
2018-02-20 00:00:00 | Logan |  |  | 06:02:00 | 06:44:00 |  | 08:18:00 | 14:22:00 |  | 15:18:00 | 16:02:00
2018-02-21 00:00:00 | Logan |  |  | 06:05:00 | 06:22:00 |  | 07:24:00 | 11:56:00 |  | 12:19:00 | 13:26:00
2018-02-22 00:00:00 | Logan | 5 |  | 06:03:00 | 07:03:00 |  | 08:28:00 | 12:56:00
2018-02-22 00:00:00 | Logan | 5 |  |  |  |  | 13:06:00 | 13:27:00 |  | 13:40:00 | 14:40:00
2018-02-23 00:00:00 | Logan | 5 |  | 06:06:00 | 06:27:00 |  | 07:41:00 | 11:33:00 |  | 12:02:00 | 12:06:00
2018-02-24 00:00:00 | Logan |  |  | 08:06:00 | 08:25:00 |  | 09:16:00 | 14:28:00 |  | 15:09:00 | 15:58:00
 | Logan Total
2018-02-19 00:00:00 | Nick |  |  | 05:59:00 | 07:25:00 |  | 10:54:00 | 17:09:00 |  | 18:48:00 | 14:19:00 | 00:00:00
2018-02-20 00:00:00 | Nick |  | Drive Shack | 05:56:00 | 06:43:00 |  | 08:04:00 | 16:42:00 |  | 17:22:00 | 17:41:00
2018-02-21 00:00:00 | Nick |  | Firestation 62 | 06:19:00 | 06:36:00 |  | 07:52:00 | 11:43:00 |  | 12:37:00 | 13:57:00
2018-02-22 00:00:00 | Nick | 8 | Lucaya Lake | 06:00:00 | 06:42:00 |  | 08:07:00 | 17:06:00 |  | 19:25:00 | 19:27:00
2018-02-23 00:00:00 | Nick | 8 | Easy Foods | 05:57:00 | 06:59:00 |  | 08:27:00 | 13:46:00 |  | 14:45:00 | 15:52:00
 | Nick Total
2018-02-20 00:00:00 | [NAME] |  | Dollar General Friar Cove | 06:10:00 | 06:40:00 |  | 07:08:00 | 13:47:00 |  | 14:34:00 | 16:01:00
2018-02-21 00:00:00 | [NAME] |  |  | 06:03:00 | 06:49:00 |  | 08:05:00 | 09:39:00 |  | 11:54:00 | 12:59:00
2018-02-19 00:00:00 | [NAME] |  | Shop | 06:05:00 | 07:11:00 |  | 08:36:00 | 09:29:00 |  | 09:49:00 | 14:57:00 | 00:00:00
 | [NAME]
2018-02-19 00:00:00 | Ricky |  | Firestation 62 | 06:08:00 | 06:48:00 |  | 07:14:00 | 14:09:00 |  | 14:43:00 | 15:59:00
2018-02-20 00:00:00 | Ricky |  | Dollar General Friar Cove | 06:09:00 | 06:44:00 |  | 08:18:00 | 14:22:00 |  | 15:18:00 | 16:02:00
2018-02-21 00:00:00 | Ricky |  | UCF | 06:05:00 | 06:22:00 |  | 07:24:00 | 11:56:00 |  | 12:19:00 | 13:26:00
2018-02-22 00:00:00 | Ricky | 5 | Dollar General Babcock | 06:03:00 | 07:03:00 |  | 08:28:00 | 12:56:00
2018-02-22 00:00:00 | Ricky | 5 | Science one Ph II |  |  |  | 13:06:00 | 13:27:00 |  | 13:40:00 | 14:40:00
2018-02-23 00:00:00 | Ricky | 5 | Bainbridge | 06:06:00 | 06:27:00 |  | 07:41:00 | 11:33:00 |  | 12:02:00 | 12:04:00
2018-02-24 00:00:00 | Ricky |  | Bainbridge | 08:06:00 | 08:25:00 |  | 09:16:00 | 14:28:00 |  | 15:09:00 | 15:58:00
 | Ricky Total
2018-02-19 00:00:00 | [NAME] |  | Walmart | 18:02:00 | 18:35:00 |  | 19:37:00 | 03:51:00 |  | 04:36:00 | 04:41:00
2018-02-20 00:00:00 | [NAME] |  |  | 18:00:00 | 18:30:00 |  | 19:39:00 | 06:32:00 |  | 07:17:00 | 07:26:00
2018-02-21 00:00:00 | [NAME] |  |  | 18:12:00 | 19:06:00 |  | 20:28:00 | 03:41:00 |  | 06:47:00 | 07:22:00
2018-02-22 00:00:00 | [NAME] |  |  | 18:06:00 | 18:26:00 |  | 20:02:00 | 06:32:00 |  | 07:28:00 | 07:43:00
 | Rocco Total
2018-02-19 00:00:00 | Sergio |  | [NAME] | 06:00:00 | 07:07:00 |  | 08:56:00 | 13:13:00 |  | 14:39:00 | 15:27:00
2018-02-20 00:00:00 | Sergio |  | Drive Shack | 06:08:00 |  |  |  |  |  |  | 15:53:00
2018-02-21 00:00:00 | Sergio |  |  | 06:03:00 | 06:51:00 |  | 09:59:00 | 12:31:00
2018-02-21 00:00:00 | Sergio |  |  |  |  |  | 12:55:00 | 16:03:00 |  | 16:49:00 | 16:49:00
2018-02-22 00:00:00 | Sergio | 15 |  | 07:39:00 | 11:11:00 |  | 11:11:00 | 14:02:00
2018-02-22 00:00:00 | Sergio | 15 |  |  |  |  | 14:42:00 | 16:02:00 |  | 17:05:00 | 17:16:00
2018-02-23 00:00:00 | Sergio | 6 | Orchard Park | 06:18:00 | 07:13:00 |  | 08:32:00 | 11:29:00
2018-02-23 00:00:00 | Sergio | 6 | Silver Spurs |  |  |  | 12:57:00 | 15:28:00 |  | 16:02:00 | 17:00:00
 | Sergio Total
2018-02-19 00:00:00 | [NAME] |  | Walmart | 17:51:00 | 18:14:00 |  | 20:04:00 | 06:03:00 |  | 06:44:00 | 06:50:00
2018-02-20 00:00:00 | [NAME] |  |  | 18:09:00 | 18:39:00 |  | 20:01:00 | 06:03:00 |  | 07:44:00 | 08:35:00
2018-02-21 00:00:00 | [NAME] |  |  | 17:56:00 | 18:20:00 |  | 18:50:00 | 06:02:00 |  | 06:29:00 | 07:15:00
2018-02-22 00:00:00 | [NAME] |  |  | 18:29:00 | 18:36:00 |  | 19:39:00 | 06:58:00 |  | 07:29:00 | 07:45:00
 | [NAME]
2018-02-19 00:00:00 | [NAME] |  |  | 06:14:00 | 06:48:00 |  | 07:14:00 | 14:09:00 |  | 14:43:00 | 15:28:00
2018-02-20 00:00:00 | [NAME] |  |  | 05:33:00 |  |  |  |  |  |  | 15:51:00
2018-02-21 00:00:00 | [NAME] |  |  | 06:05:00 | 06:22:00 |  | 07:24:00 | 11:56:00 |  | 12:19:00 | 13:26:00
2018-02-22 00:00:00 | [NAME] | 15 | [NAME] | 06:01:00 | 06:52:00 |  | 08:38:00 | 09:33:00
2018-02-22 00:00:00 | [NAME] | 15 | Firestation 62 |  |  |  | 11:11:00 | 14:02:00
2018-02-22 00:00:00 | [NAME] | 15 | Orchard Park |  |  |  | 14:42:00 | 16:02:00 |  | 17:05:00 | 17:08:00
2018-02-23 00:00:00 | [NAME] | 6 |  | 05:57:00 | 07:13:00 |  | 08:32:00 | 11:29:00
2018-02-23 00:00:00 | [NAME] | 6 |  |  |  |  | 12:57:00 | 15:28:00 |  | 16:02:00 | 16:40:00
 | [NAME]
2018-02-20 00:00:00 | TJ |  | Kids R Kids | 06:05:00 | 07:45:00 |  | 09:41:00 | 12:17:00 |  | 13:29:00 | 16:48:00
2018-02-21 00:00:00 | TJ |  | Kids R Kids | 06:29:00 | 06:51:00 |  | 09:59:00 | 12:31:00
2018-02-21 00:00:00 | TJ |  | Yates |  |  |  | 12:55:00 | 16:03:00 |  | 17:16:00 | 17:39:00
2018-02-23 00:00:00 | TJ |  |  | 06:13:00 | 06:50:00 |  | 07:05:00 | 13:07:00 |  | 13:58:00 | 15:12:00
 | TJ Total
2018-02-19 00:00:00 | Willie |  |  | 06:21:00 | 06:27:00 |  | 08:44:00 | 12:27:00 |  | 13:37:00 | 14:07:00
2018-02-20 00:00:00 | Willie |  |  | 06:01:00 | 06:37:00 |  | 07:50:00 | 14:19:00 |  | 14:49:00 | 14:56:00
2018-02-21 00:00:00 | Willie |  |  | 06:03:00 | 08:06:00 |  | 08:27:00 | 13:39:00 |  | 13:53:00 | 14:00:00
2018-02-23 00:00:00 | Willie | 2 |  | 06:03:00 | 06:50:00 |  | 08:16:00 | 13:07:00 |  | 13:58:00 | 14:00:00
 | Willie Total
2018-02-19 00:00:00 | [NAME] |  | Lake Florence | 06:00:00 | 06:07:00 |  | 06:55:00 | 07:35:00 |  | 08:30:00 | 08:30:00
2018-02-20 00:00:00 | [NAME] |  | Drive Shack | 06:00:00 |  |  |  |  |  |  | 13:03:00
 | Willie S Total
 | Grand Total