Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 03182018-03242018

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-03-19 00:00:00 | [NAME] | 1 | Lake Florence | 05:44:00 | 06:30:00 |  | 07:07:00 | 09:59:00 |  | 10:56:00 | 12:19:00 | 00:00:00 |  | 2.5
2018-03-20 00:00:00 | [NAME] |  |  | 05:49:00 |  | 00:00:00 |  |  |  |  | 16:22:00 | 00:00:00
2018-03-21 00:00:00 | [NAME] |  | Costco-Harmony | 05:40:00 | 06:34:00 |  | 09:04:00 | 13:15:00 |  | 15:52:00 | 16:01:00 |  |  | 8
2018-03-22 00:00:00 | [NAME] |  | [NAME] | 05:48:00 | 06:22:00 |  | 07:43:00 | 09:08:00 |  |  |  |  |  | 1.5
2018-03-22 00:00:00 | [NAME] |  | AIPO 9 |  |  |  | 10:14:00 | 13:16:00 |  |  |  |  |  | 1.5
2018-03-22 00:00:00 | [NAME] |  | Yates |  |  |  | 13:37:00 | 13:54:00 |  | 14:30:00 | 14:53:00 |  |  | 1.5
2018-03-23 00:00:00 | [NAME] |  | Bainbridge | 05:46:00 | 06:43:00 |  | 07:34:00 | 15:39:00 |  | 16:14:00 | 16:18:00 |  |  | 6
 | Allen Total
2018-03-19 00:00:00 | [NAME] |  | I-295 | 09:20:00 | 09:36:00 |  | 10:34:00 | 13:14:00 |  | 13:25:00 | 14:10:00 |  |  | 8
2018-03-20 00:00:00 | [NAME] |  | I-295 | 07:30:00 | 08:26:00 |  | 09:00:00 | 15:35:00 |  | 15:55:00 | 16:29:00 |  |  | 8
2018-03-21 00:00:00 | [NAME] |  | I-295 | 07:29:00 | 07:41:00 |  | 07:50:00 | 15:33:00 |  | 15:53:00 | 16:31:00 |  |  | 8
2018-03-22 00:00:00 | [NAME] |  | I-295 | 08:13:00 | 08:42:00 |  | 09:07:00 | 11:53:00 |  | 12:12:00 |  |  |  | 8
2018-03-22 00:00:00 | [NAME] |  | I-295 |  |  |  | 18:34:00 | 07:25:00 |  | 07:35:00 | 07:40:00
2018-03-23 00:00:00 | [NAME] |  | I-295 | 14:11:00 |  | 00:00:00 |  |  |  |  | 15:14:00 | 00:00:00 |  | 8
 | [NAME]
2018-03-19 00:00:00 | [NAME] | 4 | [NAME]. Paint | 07:51:00 | 12:23:00 | 00:00:00 | 12:54:00 | 18:30:00 |  | 18:59:00 | 19:05:00 |  |  | 3.5
2018-03-20 00:00:00 | [NAME] | 4 | Lake Drawdy | 05:56:00 | 06:41:00 |  | 07:32:00 | 11:06:00 |  |  |  |  |  | 2.5
2018-03-20 00:00:00 | [NAME] | 4 | Ashton Station |  |  |  | 12:19:00 | 13:50:00 |  | 14:24:00 | 15:05:00
2018-03-21 00:00:00 | [NAME] |  | Ashton Station | 05:57:00 | 06:53:00 |  | 07:57:00 | 08:49:00 |  |  |  |  |  | 3
2018-03-21 00:00:00 | [NAME] |  | Silver Star/Taft Ave |  |  |  | 10:36:00 | 18:26:00 |  | 19:02:00 | 19:04:00 |  |  | 8
2018-03-22 00:00:00 | [NAME] |  | Shop | 05:57:00 |  |  |  |  |  |  | 16:22:00 | 00:00:00
2018-03-23 00:00:00 | [NAME] |  | Bainbridge | 05:57:00 | 06:37:00 |  | 07:35:00 | 15:40:00 |  | 16:44:00 | 17:04:00 |  |  | 6
 | [NAME]
2018-03-19 00:00:00 | [NAME] | 10 | Bayou Pass | 05:47:00 | 06:21:00 |  | 08:46:00 | 12:09:00 |  | 14:06:00 | 14:35:00 |  |  | 2 | 1
2018-03-20 00:00:00 | [NAME] | 6 | [NAME] | 05:55:00 | 06:43:00 |  | 07:52:00 | 10:40:00 |  | 11:22:00 | 11:48:00
2018-03-21 00:00:00 | [NAME] |  | Park Ave | 05:57:00 | 06:25:00 |  | 07:36:00 | 09:12:00
2018-03-21 00:00:00 | [NAME] |  | Kids R Kids |  |  |  | 09:42:00 | 12:08:00 |  | 12:58:00 | 14:35:00
2018-03-23 00:00:00 | [NAME] |  | Maitland City | 05:55:00 | 06:59:00 |  | 08:24:00 | 15:49:00 |  | 16:21:00 | 16:44:00 |  |  | 5
 | Anthony Total
2018-03-19 00:00:00 | [NAME] | 1 | Lake Florence | 06:04:00 | 06:30:00 |  | 07:07:00 | 09:59:00 |  | 10:56:00 | 12:39:00 | 00:00:00 |  | 2.5
2018-03-20 00:00:00 | [NAME] |  |  | 06:06:00 |  | 00:00:00 |  |  |  |  | 14:19:00 | 00:00:00
2018-03-21 00:00:00 | [NAME] |  | Costco-Harmony | 06:03:00 | 06:34:00 |  | 09:04:00 | 13:15:00 |  | 15:52:00 | 16:07:00 |  |  | 8
2018-03-22 00:00:00 | [NAME] |  | [NAME] | 05:53:00 | 06:22:00 |  | 07:43:00 | 09:08:00 |  |  |  |  |  | 1.5
2018-03-22 00:00:00 | [NAME] |  | AIPO 9 |  |  |  | 10:14:00 | 13:16:00 |  |  |  |  |  | 1.5
2018-03-22 00:00:00 | [NAME] |  | Yates |  |  |  | 13:37:00 | 13:54:00 |  | 14:30:00 | 14:54:00 |  |  | 1.5
2018-03-23 00:00:00 | [NAME] |  | Bainbridge | 05:58:00 | 06:43:00 |  | 07:34:00 | 15:39:00 |  | 16:14:00 | 16:49:00 |  |  | 6
 | [NAME]
2018-03-19 00:00:00 | [NAME] |  | Walmart | 18:09:00 | 18:19:00 |  | 18:42:00 | 23:39:00 |  | 00:30:00 | 00:35:00 |  |  | 36
2018-03-21 00:00:00 | [NAME] |  | Walmart | 18:13:00 | 18:33:00 |  | 21:22:00 | 06:50:00 |  | 08:49:00 | 08:57:00
2018-03-22 00:00:00 | [NAME] |  | Walmart | 18:12:00 | 18:53:00 |  | 20:52:00 | 12:17:00
2018-03-22 00:00:00 | [NAME] |  | Walmart 2 | 18:12:00 |  |  | 01:48:00 | 05:44:00 |  | 06:18:00 | 06:30:00
 | Brandon Total
2018-03-20 00:00:00 | Dwayne | 10 | Keator | 05:44:00 | 07:13:00 |  | 09:13:00 | 12:48:00 |  | 14:00:00 | 14:19:00 |  |  | 2 | 1
2018-03-21 00:00:00 | Dwayne |  | [NAME] | 05:44:00 | 06:36:00 |  | 07:42:00 | 16:14:00 |  | 17:18:00 | 17:25:00 |  |  | 4
2018-03-22 00:00:00 | Dwayne |  | [NAME] | 05:46:00 | 06:33:00 |  | 07:39:00 | 10:43:00 |  | 11:16:00 | 12:36:00 | 00:00:00 |  | 5
2018-03-23 00:00:00 | Dwayne |  | Keator | 05:48:00 | 06:12:00 |  | 07:19:00 | 08:38:00 |  |  |  |  |  | 1
2018-03-23 00:00:00 | Dwayne |  | Bainbridge |  |  |  | 09:34:00 | 13:05:00 |  | 13:44:00 | 14:05:00 |  |  | 6
 | [NAME]
2018-03-19 00:00:00 | Edgar | 8 | [NAME] | 06:02:00 | 13:18:00 | 00:00:00 | 14:05:00 | 16:55:00 |  |  |  |  |  | 3.5
2018-03-19 00:00:00 | Edgar | 8 | [NAME]. Paint |  |  |  | 17:11:00 | 18:29:00 |  | 19:05:00 | 19:10:00
2018-03-20 00:00:00 | Edgar | 8 | CKS Masonry | 06:02:00 | 06:45:00 |  | 07:49:00 | 13:15:00 |  | 13:49:00 | 14:39:00 |  |  | 2
2018-03-21 00:00:00 | Edgar |  | Metro Church | 06:03:00 | 06:31:00 |  | 07:11:00 | 16:35:00 |  | 16:45:00 | 17:04:00 |  |  | 5
2018-03-22 00:00:00 | Edgar |  | Metro Church | 05:59:00 | 06:31:00 |  | 07:07:00 | 11:27:00 |  | 11:58:00 | 14:04:00 | 00:00:00 |  | 5
2018-03-23 00:00:00 | Edgar |  | Maitland City | 06:02:00 | 06:33:00 |  | 07:31:00 | 14:23:00 |  | 15:00:00 | 15:22:00 |  |  | 5
 | [NAME]
2018-03-18 00:00:00 | Efrain |  | Walmart | 17:53:00 | 19:31:00 |  | 19:56:00 | 08:23:00 |  | 08:49:00 | 09:09:00 |  |  | 36
2018-03-19 00:00:00 | Efrain |  | Walmart | 18:01:00 | 18:14:00 |  | 20:44:00 | 08:23:00 |  | 09:54:00 | 10:04:00
2018-03-20 00:00:00 | Efrain |  | Walmart | 17:42:00 | 18:04:00 |  | 20:38:00 | 05:12:00 |  | 07:48:00 | 07:54:00
2018-03-22 00:00:00 | Efrain |  | Walmart | 18:00:00 | 19:11:00 |  | 21:32:00 | 01:46:00 |  | 03:51:00 | 04:00:00
 | Efrain Total
2018-03-20 00:00:00 | [NAME] |  | I-295 | 08:29:00 | 08:29:00 |  | 08:55:00 | 16:09:00 |  | 16:23:00 | 16:49:00 |  |  | 8
2018-03-21 00:00:00 | [NAME] |  | I-295 | 07:20:00 | 07:41:00 |  | 07:50:00 | 15:33:00 |  | 15:53:00 | 16:49:00 |  |  | 8
2018-03-22 00:00:00 | [NAME] |  | I-295 | 08:12:00 | 08:40:00 |  | 09:07:00 | 12:58:00 |  |  |  |  |  | 8
2018-03-23 00:00:00 | [NAME] |  | I-295 |  |  |  |  |  |  |  | 10:51:00 | 00:00:00 |  | 8
 | [NAME]
2018-03-19 00:00:00 | Lindsey |  | Shop | 05:50:00 |  | 00:00:00 |  |  |  |  | 14:31:00 | 00:00:00
2018-03-20 00:00:00 | Lindsey | 10 | Keator | 05:50:00 | 07:13:00 |  | 09:13:00 | 12:48:00 |  | 14:00:00 | 14:30:00 |  |  | 2
2018-03-21 00:00:00 | Lindsey |  | [NAME] | 05:50:00 | 06:36:00 |  | 07:42:00 | 16:14:00 |  | 17:18:00 | 17:30:00 |  |  | 4
2018-03-22 00:00:00 | Lindsey |  | [NAME] | 05:50:00 | 06:33:00 |  | 07:39:00 | 10:43:00 |  | 11:16:00 | 14:32:00 | 00:00:00 |  | 5
2018-03-23 00:00:00 | Lindsey |  | Keator | 05:50:00 | 06:12:00 |  | 07:19:00 | 08:38:00 |  |  |  |  |  | 1
2018-03-23 00:00:00 | Lindsey |  | Bainbridge |  |  |  | 09:34:00 | 13:05:00 |  | 13:44:00 | 14:12:00 |  |  | 6
 | Lindsey Total
2018-03-20 00:00:00 | Logan |  | ? | 06:09:00 | 07:57:00 |  | 08:59:00 | 13:26:00 |  | 14:40:00 | 14:44:00 |  |  |  | 3
2018-03-21 00:00:00 | Logan |  | Shop | 06:11:00 |  | 00:00:00 |  |  |  |  | 15:15:00 | 00:00:00
 | Logan Total
2018-03-19 00:00:00 | Marion | 4 | [NAME]. Paint | 05:49:00 | 12:23:00 | 00:00:00 | 12:54:00 | 18:30:00 |  | 18:59:00 | 18:30:00 | 00:00:00 |  | 3.5 | 1
2018-03-21 00:00:00 | Marion |  | Metro Church | 06:00:00 | 06:31:00 |  | 07:11:00 | 16:35:00 |  | 16:45:00 | 15:00:00 | 00:00:00 |  | 5
2018-03-22 00:00:00 | Marion |  | Metro Church | 06:00:00 | 06:31:00 |  | 07:07:00 | 11:27:00 |  | 11:58:00 | 14:20:00 | 00:00:00 |  | 5
2018-03-23 00:00:00 | Marion |  | Maitland City | 06:00:00 | 06:33:00 |  | 07:31:00 | 14:23:00 |  | 15:00:00 | 15:00:00 |  |  | 5
 | Marion Total
2018-03-19 00:00:00 | Nick | 8 | [NAME] | 05:58:00 | 13:18:00 | 00:00:00 | 14:05:00 | 16:55:00 |  |  |  |  |  | 3.5
2018-03-19 00:00:00 | Nick | 8 | [NAME]. Paint |  |  |  | 17:11:00 | 18:29:00 |  | 19:05:00 | 19:08:00
2018-03-20 00:00:00 | Nick | 8 | CKS Masonry | 06:04:00 | 06:45:00 |  | 07:49:00 | 13:15:00 |  | 13:49:00 | 14:24:00 |  |  | 2
2018-03-21 00:00:00 | Nick |  | Metro Church | 05:58:00 | 06:31:00 |  | 07:11:00 | 16:35:00 |  | 16:45:00 | 16:59:00 |  |  | 5
2018-03-22 00:00:00 | Nick |  | Metro Church | 06:02:00 | 06:31:00 |  | 07:07:00 | 11:27:00 |  | 11:58:00 | 13:58:00 | 00:00:00 |  | 5
2018-03-23 00:00:00 | Nick |  | Maitland City | 05:58:00 | 06:33:00 |  | 07:31:00 | 14:23:00 |  | 15:00:00 | 15:22:00 |  |  | 5
 | Nick Total
2018-03-19 00:00:00 | [NAME] | 6 | [NAME] | 06:00:00 | 06:32:00 |  | 07:36:00 | 11:33:00 |  | 12:17:00 | 12:46:00 |  |  | 5
2018-03-20 00:00:00 | [NAME] | 6 | [NAME] | 06:04:00 | 06:43:00 |  | 07:52:00 | 10:40:00 |  | 11:22:00 | 14:13:00 | 00:00:00
2018-03-21 00:00:00 | [NAME] |  | Park Ave | 06:05:00 | 06:25:00 |  | 07:36:00 | 09:12:00
2018-03-21 00:00:00 | [NAME] |  | Kids R Kids |  |  |  | 09:42:00 | 12:08:00 |  | 12:58:00 | 14:16:00
2018-03-22 00:00:00 | [NAME] |  | Shop | 06:06:00 |  |  |  |  |  |  | 16:05:00 | 00:00:00
2018-03-23 00:00:00 | [NAME] |  | Maitland City | 06:09:00 | 06:59:00 |  | 08:24:00 | 15:49:00 |  | 16:21:00 | 16:50:00 |  |  | 5
 | [NAME]
2018-03-20 00:00:00 | Ricky |  | ? | 06:07:00 | 07:57:00 |  | 08:59:00 | 13:26:00 |  | 14:40:00 | 14:46:00 |  |  |  | 3
2018-03-21 00:00:00 | Ricky |  | Shop | 06:11:00 |  | 00:00:00 |  |  |  |  | 15:15:00 | 00:00:00
 | Ricky Total
2018-03-19 00:00:00 | [NAME] |  | Walmart | 18:10:00 | 18:19:00 |  | 18:42:00 | 23:39:00 |  | 00:30:00 | 00:34:00 |  |  | 36
2018-03-21 00:00:00 | [NAME] |  | Walmart | 18:14:00 | 18:33:00 |  | 21:22:00 | 06:50:00 |  | 08:49:00 | 09:04:00
2018-03-22 00:00:00 | [NAME] |  | Walmart | 18:12:00 | 18:53:00 |  | 20:52:00 | 12:17:00
2018-03-22 00:00:00 | [NAME] |  | Walmart 2 | 18:12:00 |  |  | 01:48:00 | 05:44:00 |  | 06:18:00 | 06:30:00
 | Rocco Total
2018-03-19 00:00:00 | Sergio | 6 | [NAME] | 05:40:00 | 06:32:00 |  | 07:36:00 | 11:33:00 |  | 12:17:00 | 13:07:00 |  |  | 5 | 2
2018-03-20 00:00:00 | Sergio | 7 | CKS Masonry | 06:26:00 | 07:30:00 |  | 08:46:00 | 13:55:00 |  | 14:22:00 | 14:36:00 |  |  | 2
2018-03-22 00:00:00 | Sergio |  | [NAME] | 05:56:00 | 07:06:00 |  | 08:00:00 | 09:35:00 |  | 10:08:00 | 16:03:00 | 00:00:00 |  | 5
 | Sergio Total
2018-03-18 00:00:00 | [NAME] |  | Walmart | 17:52:00 | 19:31:00 |  | 19:56:00 | 08:23:00 |  | 08:49:00 | 09:05:00 |  |  | 36
2018-03-19 00:00:00 | [NAME] |  | Walmart | 18:00:00 | 18:14:00 |  | 20:44:00 | 08:23:00 |  | 09:54:00 | 10:03:00
2018-03-20 00:00:00 | [NAME] |  | Walmart | 17:41:00 | 18:04:00 |  | 20:38:00 | 05:12:00 |  | 07:48:00 | 07:55:00
2018-03-21 00:00:00 | [NAME] |  | Walmart | 17:56:00 | 18:57:00 |  | 21:54:00 | 05:19:00 |  | 07:18:00 | 07:49:00
2018-03-22 00:00:00 | [NAME] |  | Walmart | 17:59:00 | 19:11:00 |  | 21:32:00 | 01:46:00 |  | 03:51:00 | 04:00:00
 | [NAME]
2018-03-18 00:00:00 | [NAME] |  | Walmart | 17:20:00 | 19:31:00 |  | 19:56:00 | 08:23:00 |  | 08:49:00 | 08:58:00 |  |  | 36
2018-03-19 00:00:00 | [NAME] |  | Walmart | 17:29:00 | 18:14:00 |  | 20:44:00 | 08:23:00 |  | 09:54:00 | 10:07:00
2018-03-20 00:00:00 | [NAME] |  | Walmart | 18:00:00 | 18:04:00 |  | 20:38:00 | 05:12:00 |  | 07:48:00 | 08:04:00
2018-03-21 00:00:00 | [NAME] |  | Walmart | 17:45:00 | 18:57:00 |  | 21:54:00 | 05:19:00 |  | 07:18:00 | 07:32:00
2018-03-22 00:00:00 | [NAME] |  | Walmart | 18:10:00 | 19:11:00 |  | 21:32:00 | 01:46:00 |  | 03:51:00 | 04:00:00
 | [NAME]
2018-03-19 00:00:00 | TJ |  |  | 05:55:00 |  |  |  |  |  |  | 10:18:00 | 00:00:00
2018-03-20 00:00:00 | TJ |  |  | 06:11:00 |  | 00:00:00 |  |  |  |  | 14:35:00 | 00:00:00
2018-03-21 00:00:00 | TJ |  | Shop | 06:08:00 |  |  |  |  |  |  | 17:00:00 | 00:00:00
2018-03-22 00:00:00 | TJ |  | Shop | 06:15:00 |  |  |  |  |  |  | 16:46:00 | 00:00:00
2018-03-23 00:00:00 | TJ |  | The Strand | 06:36:00 | 08:12:00 |  | 08:38:00 | 12:37:00 |  |  |  |  |  | 8
2018-03-23 00:00:00 | TJ |  | AFCO GSE |  |  |  | 13:31:00 | 17:12:00 |  | 17:53:00 | 18:20:00
 | TJ Total
2018-03-19 00:00:00 | Willie | 4 | [NAME]. Paint | 05:49:00 | 12:23:00 | 00:00:00 | 12:54:00 | 18:30:00 |  | 18:59:00 | 18:30:00 | 00:00:00 |  | 3.5
2018-03-20 00:00:00 | Willie | 4 | Lake Drawdy | 05:50:00 | 06:41:00 |  | 07:32:00 | 11:06:00 |  |  |  |  |  | 2.5
2018-03-20 00:00:00 | Willie | 4 | Ashton Station |  |  |  | 12:19:00 | 13:50:00 |  | 14:24:00 | 14:25:00
2018-03-21 00:00:00 | Willie |  | Ashton Station | 06:12:00 | 06:53:00 |  | 07:57:00 | 08:49:00 |  |  |  |  |  | 3
2018-03-21 00:00:00 | Willie |  | Silver Star/Taft Ave |  |  |  | 10:36:00 | 18:26:00 |  | 19:02:00 | 19:02:00 |  |  | 8
2018-03-21 00:00:00 | Willie |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 4
2018-03-22 00:00:00 | Willie |  | Shop | 05:53:00 |  |  |  |  |  |  | 11:05:00 | 00:00:00
2018-03-23 00:00:00 | Willie |  | Bainbridge | 05:53:00 | 06:37:00 |  | 07:35:00 | 15:40:00 |  | 16:44:00 | 16:48:00 |  |  | 6
 | Willie Total
2018-03-19 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
2018-03-20 00:00:00 | [NAME]
2018-03-21 00:00:00 | [NAME]
2018-03-22 00:00:00 | [NAME]
2018-03-23 00:00:00 | [NAME]
 | Willie S Total
 | Grand Total