Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 05062018-05122018

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
[NAME] | [NAME] |  | The Strand | 05:43 AM | 06:58:00 |  | 07:08:00 | 15:03:00 |  | 15:14:00 | 03:32 PM |  |  | 8
05/08/2018 | [NAME] |  | Heritage Hills | 05:41 AM | 05:52:00 |  | 10:12:00 | 15:39:00 |  | 16:44:00 | 04:46 PM |  |  | 8
05/08/2018 | [NAME] |  | [NAME] |  |  |  | 06:10:00 | 09:22:00 |  |  |  |  |  | 3
05/09/2018 | [NAME] |  | Heritage Hills | 05:39 AM | 07:18:00 |  | 10:39:00 | 15:59:00 |  | 17:09:00 | 05:12 PM |  |  | 8
05/10/2018 | [NAME] |  | Shop | 06:01 AM |  | 0:00:00 |  |  |  |  | 03:13 PM | 0:00:00
05/11/2018 | [NAME] |  | Neptune Road | 05:37 AM | 06:46:00 |  | 08:04:00 | 11:28:00 |  |  |  |  |  | 4
05/11/2018 | [NAME] |  | Heritage Hills |  |  |  | 12:51:00 | 14:54:00 |  | 16:05:00 | 16:20:00 |  |  | 8
 | [NAME]
05/06/2018 | [NAME] |  | GA | 04:44 AM |  | 0:00:00 |  |  |  |  | 10:03 AM | 0:00:00
[NAME] | [NAME] |  | I-295 | 06:32 PM | 19:06:00 |  | 19:33:00 | 03:40:00 |  | 03:51:00 | 03:59 AM |  |  | 8 | 1
05/09/2018 | [NAME] |  | Walmart Durbin | 06:39 AM | 06:57:00 |  | 08:06:00 | 15:03:00 |  | 15:49:00 | 04:09 PM |  |  | 8
05/10/2018 | [NAME] |  | Walmart Durbin | 07:09 AM | 07:38:00 |  | 08:49:00 | 13:04:00 |  | 13:50:00 | 02:16 PM |  |  | 8
 | [NAME]
[NAME] | [NAME] |  | The Strand | 06:05 AM | 06:58:00 |  | 07:08:00 | 15:03:00 |  | 15:14:00 | 04:40 PM | 0:00:00 |  | 8
05/08/2018 | [NAME] |  | Heritage Hills | 05:31 AM | 05:52:00 |  | 10:12:00 | 15:39:00 |  | 16:44:00 | 06:20 PM | 0:00:00 |  | 8
05/08/2018 | [NAME] |  | [NAME] |  |  |  | 06:10:00 | 09:22:00 |  |  |  |  |  | 3
05/09/2018 | [NAME] |  | Heritage Hills | 07:00 AM | 07:18:00 |  | 10:39:00 | 15:59:00 |  | 17:09:00 | 05:16 PM |  |  | 8
05/10/2018 | [NAME] |  | Shop | 05:58 AM |  | 0:00:00 |  |  |  |  | 04:53 PM | 0:00:00
05/11/2018 | [NAME] |  | Neptune Road | 05:58 AM | 06:46:00 |  | 08:04:00 | 11:28:00 |  |  |  |  |  | 4
05/11/2018 | [NAME] |  | Heritage Hills |  |  |  | 12:51:00 | 14:54:00 |  | 16:05:00 | 16:05:00 |  |  | 8
 | Benjamin Total
[NAME] | [NAME] |  | Walmart | 06:03 PM | 18:29:00 |  | 21:10:00 | 04:41:00 |  | 06:55:00 | 07:02 AM |  |  | 36
05/08/2018 | [NAME] |  | Walmart | 06:13 PM | 19:18:00 |  | 21:41:00 | 06:18:00 |  | 07:55:00 | 08:02 AM
05/09/2018 | [NAME] |  | Walmart | 08:06 PM | 20:25:00 |  | 22:52:00 | 05:06:00 |  | 07:02:00 | 07:29 AM
05/10/2018 | [NAME] |  | Walmart | 06:05 PM | 18:30:00 |  | 20:57:00 | 05:41:00 |  | 07:20:00 | 08:00 AM
 | Brandon Total
05/06/2018 | Dwayne | 10 | [NAME] | 05:58 PM | 19:01:00 |  | 20:03:00 | 07:09:00 |  | 07:39:00 | 07:48 AM |  |  | 40
[NAME] | Dwayne |  | [NAME] | 06:44 PM | 19:01:00 |  | 19:42:00 | 18:14:00 |  | 06:46:00 | 06:52 AM |  |  | 8
05/08/2018 | Dwayne |  | [NAME] | 05:54 PM | 18:43:00 |  | 20:09:00 | 02:54:00 |  | 03:20:00 | 03:23 AM |  |  | 8
05/09/2018 | Dwayne |  | [NAME] | 05:48 PM | 18:48:00 |  | 19:30:00 | 02:04:00 |  | 02:30:00 | 02:34 AM |  |  | 8 | 1
 | [NAME]
[NAME] | Edgar |  | The Strand | 05:57 AM | 06:58:00 |  | 07:08:00 | 15:03:00 |  | 15:14:00 | 03:41 PM |  |  | 8
05/08/2018 | Edgar |  | Blue Water | 05:58 AM | 06:50:00 |  | 08:00:00 | 13:38:00 |  |  |  |  |  | 3
05/08/2018 | Edgar |  | Adventist |  |  |  | 14:25:00 | 16:23:00 |  | 17:10:00 | 05:25 PM |  |  | 3
05/09/2018 | Edgar |  | Champions Vue | 05:56 AM | 06:17:00 |  | 07:24:00 | 07:45:00 |  |  | 04:32 PM | 0:00:00 |  | 1
2018-05-09 00:00:00 | Edgar |  | Vera |  |  |  | 09:33:00 | 15:54:00 |  | 16:24:00 | 04:32 PM |  |  | 8
05/10/2018 | Edgar |  | Blue Water | 05:56 AM | 06:17:00 |  | 07:17:00 | 09:13:00 |  |  |  |  |  | 3
05/10/2018 | Edgar |  | Bainbridge |  |  |  | 13:20:00 | 14:02:00 |  | 14:37:00 | 02:51 PM
05/11/2018 | Edgar |  | Starflyer | 05:58 AM | 06:38:00 |  | 07:41:00 | 14:26:00 |  | 15:18:00 | 03:38 PM |  |  | 4
 | [NAME]
05/09/2018 | Efrain |  | Walmart | 07:42 PM | 07:42 PM |  | 07:42 PM | 07:12:00 |  | 07:20:00 | 08:05 AM |  |  | 48
05/10/2018 | Efrain |  | Walmart | 04:56 PM | 17:12:00 |  | 17:24:00 | 04:11:00 |  | 07:27 PM | 07:27 PM |  |  |  | 2
 | Efrain Total
05/06/2018 | [NAME] | 10 | [NAME] | 07:00 PM | 19:01:00 |  | 20:03:00 | 07:09:00 |  | 07:39:00 | 07:46 AM |  |  | 40
[NAME] | [NAME] |  | [NAME] | 06:45 PM | 19:01:00 |  | 19:42:00 | 18:14:00 |  | 06:46:00 | 06:51 AM |  |  | 8
05/08/2018 | [NAME] |  | [NAME] | 06:26 PM | 18:43:00 |  | 20:09:00 | 02:54:00 |  | 03:20:00 | 03:23 AM |  |  | 8
05/09/2018 | [NAME] |  | [NAME] | 06:47 PM | 18:48:00 |  | 19:30:00 | 02:04:00 |  | 02:30:00 | 02:31 AM |  |  | 8
05/10/2018 | [NAME] |  | [NAME] | 07:25 PM | 20:19:00 |  | 20:42:00 | 21:20:00 |  | 21:51:00 | 09:54 PM |  |  | 8
 | [NAME]
[NAME] | [NAME] |  | USPS | 05:48 AM | 06:31:00 |  | 08:35:00 | 13:30:00 |  | 14:41:00 | 04:22 PM | 0:00:00 |  | 4
05/08/2018 | [NAME] |  | Bluewater | 05:42 AM | 07:20:00 |  | 08:21:00 | 13:47:00 |  | 14:23:00 | 02:57 PM |  |  | 3
05/09/2018 | [NAME] |  | The Strand | 05:55 AM | 06:59:00 |  | 07:36:00 | 13:57:00 |  | 14:01:00 | 03:07 PM |  |  | 8
2018-05-10 00:00:00 | [NAME] |  | The Strand | 05:48 AM | 06:52:00 |  | 07:22:00 | 07:47:00
05/10/2018 | [NAME] |  | Fountain Park |  |  |  | 10:18:00 | 12:16:00 |  | 13:23:00 | 03:13 PM |  |  | 5
05/11/2018 | [NAME] |  | Samoy | 05:46 AM | 07:25:00 |  | 09:18:00 | 15:56:00 |  | 16:44:00 | 06:00 PM |  |  | 5
 | Kenneth Total
05/08/2018 | Logan |  | Walmart | 06:13 PM | 19:18:00 |  | 21:41:00 | 06:18:00 |  | 07:55:00 | 09:33 AM |  |  | 24 | 1
05/09/2018 | Logan |  | Walmart | 08:14 PM | 20:59:00 |  | 23:48:00 | 09:06:00 |  | 11:24:00 | 11:51 AM
05/10/2018 | Logan |  | Walmart | 09:51 PM | 22:02:00 |  | 00:13:00 | 10:35:00 |  | 12:56:00 | 01:05 PM
05/11/2018 | Logan |  | Walmart | 04:19 PM | 16:20:00 |  | 18:43:00 | 12:35:00 |  | 15:07:00 | 15:15:00
 | Logan Total
[NAME] | [NAME] |  | The Strand | 06:03 AM | 06:57:00 |  | 08:00:00 | 15:15:00 |  | 15:20:00 | 04:22 PM |  |  | 8
05/08/2018 | [NAME] |  | The Strand | 06:04 AM | 07:15:00 |  | 07:27:00 | 09:33:00 |  |  |  |  |  | 2
05/08/2018 | [NAME] |  | AFCO | 06:04 AM |  | 0:00:00 | 12:05:00 | 13:23:00 |  | 13:49:00 | 04:40 PM | 0:00:00 |  | 8
05/09/2018 | [NAME] |  | The Strand | 06:06 AM | 06:59:00 |  | 07:36:00 | 13:57:00 |  | 14:01:00 | 04:47 PM | 0:00:00 |  | 5
05/10/2018 | [NAME] |  | Fountain Park | 06:05 AM | 06:52:00 |  | 10:18:00 | 12:16:00 |  | 13:23:00 | 04:40 PM | 0:00:00 |  | 8
05/11/2018 | [NAME] |  | BVL | 06:04 AM | 07:25:00 |  | 09:18:00 | 15:56:00 |  | 16:44:00 | 04:08 PM | 0:00:00 |  | 8
 | Patrick Total
05/06/2018 | [NAME] |  | Walmart | 06:02 PM | 18:21:00 |  | 21:07:00 | 02:08:00 |  | 04:14:00 | 04:18 AM |  |  | 48
[NAME] | [NAME] |  | Walmart | 06:03 PM | 18:29:00 |  | 21:10:00 | 04:41:00 |  | 06:55:00 | 07:01 AM
05/08/2018 | [NAME] |  | Walmart | 06:13 PM | 19:18:00 |  | 21:41:00 | 06:18:00 |  | 07:55:00 | 08:02 AM
05/09/2018 | [NAME] |  | Walmart | 08:06 PM | 20:25:00 |  | 22:52:00 | 05:06:00 |  | 07:02:00 | 07:23 AM
05/10/2018 | [NAME] |  | Walmart | 06:05 PM | 18:30:00 |  | 20:57:00 | 05:41:00 |  | 07:20:00 | 08:01 AM
 | Rocco Total
05/06/2018 | [NAME] |  | Walmart | 12:04 PM | 12:40:00 |  | 18:42:00 | 08:59:00 |  | 09:04:00 | 09:35 AM |  |  | 48
[NAME] | [NAME] |  | Walmart | 05:31 PM | 17:45:00 |  | 18:05:00 | 10:37:00 |  | 10:45:00 | 10:46 AM
05/08/2018 | [NAME] |  | Walmart | 04:26 PM | 16:40:00 |  | 16:45:00 | 08:30:00 |  | 10:59:00 | 11:06 AM
05/09/2018 | [NAME] |  | Walmart | 04:58 PM | 17:19:00 |  | 17:34:00 | 07:12:00 |  | 07:20:00 | 08:07 AM
05/10/2018 | [NAME] |  | Walmart | 04:56 PM | 17:12:00 |  | 17:24:00 | 04:11:00 |  | 09:10:00 | 09:28 AM
 | [NAME]
[NAME] | Terrance |  | USPS | 06:13 AM | 06:31:00 |  | 08:35:00 | 13:30:00 |  | 14:41:00 | 05:27 PM | 0:00:00 |  | 4
05/08/2018 | Terrance |  | Bluewater | 05:56 AM | 07:20:00 |  | 08:21:00 | 13:47:00 |  | 14:23:00 | 03:11 PM |  |  | 3
05/09/2018 | Terrance |  | The Strand | 06:02 AM | 06:59:00 |  | 07:36:00 | 13:57:00 |  | 14:01:00 | 06:30 PM | 0:00:00 |  | 8 | 1
05/11/2018 | Terrance |  | Samoy | 06:07 AM | 07:25:00 |  | 09:18:00 | 15:56:00 |  | 16:44:00 | 06:00 PM |  |  | 5
 | Terrance Total
05/06/2018 | [NAME] |  | Walmart | 12:04 PM | 12:40:00 |  | 18:42:00 | 08:59:00 |  | 09:04:00 | 09:36 AM |  |  | 48
[NAME] | [NAME] |  | Walmart | 05:35 PM | 17:45:00 |  | 18:05:00 | 10:37:00 |  | 10:45:00 | 10:40 AM | 0:00:00
05/08/2018 | [NAME] |  | Walmart | 04:27 PM | 16:40:00 |  | 16:45:00 | 08:30:00 |  | 10:59:00 | 11:05 AM
05/09/2018 | [NAME] |  | Walmart | 04:59 PM | 17:19:00 |  | 17:34:00 | 07:12:00 |  | 07:20:00 | 08:07 AM
05/10/2018 | [NAME] |  | Walmart | 04:57 PM | 17:12:00 |  | 17:24:00 | 04:11:00 |  | 09:10:00 | 09:26 AM
 | [NAME]
[NAME] | [NAME] |  | USPS | 06:00 AM | 06:31:00 |  | 08:35:00 | 13:30:00 |  | 14:41:00 | 04:00 PM | 0:00:00 |  | 4
05/08/2018 | [NAME] |  | Adventist Health | 06:00 AM | 07:04:00 |  | 09:57:00 | 14:28:00 |  | 15:20:00 | 03:30 PM |  |  | 3
05/09/2018 | [NAME] |  | Vera | 07:00 AM | 07:13:00 |  | 11:17:00 | 14:46:00 |  | 15:10:00 | 03:30 PM |  |  | 8 | 1
05/10/2018 | [NAME] |  | Hyatt House |  |  |  | 10:53:00 | 13:46:00 |  | 14:21:00 | 04:00 PM | 0:00:00 |  | 1
05/10/2018 | [NAME] |  | Bluewater | 06:45 AM | 06:40:00 | 0:00:00 | 07:55:00 | 09:16:00 |  |  |  |  |  | 3
 | Willie S Total
[NAME] | Willie |  | 55 West Gore | 05:54 AM | 06:51:00 |  | 08:10:00 | 10:46:00 |  |  |  |  |  | 4
[NAME] | Willie |  | Champions Vue |  |  |  | 11:24:00 | 13:09:00 |  | 15:51:00 | 03:54 PM |  |  | 4
05/08/2018 | Willie |  | Heritage Hills | 05:55 AM | 06:53:00 |  | 08:12:00 | 13:43:00 |  | 15:00:00 | 03:11 PM |  |  | 8
05/09/2018 | Willie |  | Vera | 06:01 AM | 07:48:00 |  | 08:23:00 | 15:02:00 |  | 16:37:00 | 04:40 PM |  |  | 3
05/10/2018 | Willie |  | Shop | 06:00 AM |  | 0:00:00 |  |  |  |  | 12:01 PM | 0:00:00 |  | 8
05/11/2018 | Willie |  | Adventist Health | 06:01 AM | 06:27:00 |  | 07:39:00 | 11:30:00 |  |  |  |  |  | 8
05/11/2018 | Willie |  | Storeylake 1B-1 |  |  |  | 12:28:00 | 14:56:00 |  | 15:49:00 | 03:48 PM | 0:00:00 |  | 2
 | Willie Total
2018-05-08 00:00:00 | Nick |  | Blue Water | 06:01:00 | 06:50:00 |  | 08:00:00 | 13:38:00 |  |  |  |  |  | 3
2018-05-08 00:00:00 | Nick |  | Adventist |  |  |  | 14:25:00 | 16:23:00 |  | 17:10:00 | 18:19:00 |  |  | 3
2018-05-09 00:00:00 | Nick |  | Champions Vue | 05:57:00 | 06:17:00 |  | 07:24:00 | 07:45:00 |  |  | 16:28:00 | 0:00:00 |  | 1
2018-05-09 00:00:00 | Nick |  | Vera |  |  |  | 09:33:00 | 15:54:00 |  | 16:24:00 | 16:28:00 |  |  | 8
2018-05-10 00:00:00 | Nick |  | Blue Water | 05:56:00 | 06:17:00 |  | 07:17:00 | 09:13:00 |  |  |  |  |  | 3
2018-05-10 00:00:00 | Nick |  | Bainbridge |  |  |  | 13:20:00 | 14:02:00 |  | 14:37:00 | 14:47:00
2018-05-11 00:00:00 | Nick |  | Starflyer | 06:03:00 | 06:38:00 |  | 07:41:00 | 14:26:00 |  | 15:18:00 | 15:37:00 |  |  | 4
 | Nick Total
2018-05-07 00:00:00 | [NAME] |  | 55 West Gore | 06:03:00 | 06:51:00 |  | 08:10:00 | 10:46:00 |  |  |  |  |  | 4
2018-05-07 00:00:00 | [NAME] |  | Champions Vue |  |  |  | 11:24:00 | 13:09:00 |  | 15:51:00 | 16:21:00 |  |  | 4
2018-05-08 00:00:00 | [NAME] |  | Heritage Hills | 06:04:00 | 06:53:00 |  | 08:12:00 | 13:43:00 |  | 15:00:00 |  | 0:00:00 |  | 8
2018-05-09 00:00:00 | [NAME] |  | Vera | 06:06:00 | 07:48:00 |  | 08:23:00 | 15:02:00 |  | 16:37:00 | 16:50:00 |  |  | 3
2018-05-10 00:00:00 | [NAME] |  | Shop | 06:05:00 |  | 0:00:00 |  |  |  |  | 16:40:00 | 0:00:00 |  | 8
2018-05-11 00:00:00 | [NAME] |  | Adventist Health | 06:04:00 | 06:27:00 |  |  |  |  |  |  |  |  | 8
2018-05-11 00:00:00 | [NAME] |  | Storeylake 1B-1 |  |  |  | 12:28:00 | 14:56:00 |  | 15:49:00 | 16:08:00 |  |  | 2
 | [NAME]
2018-05-07 00:00:00 | [NAME] |  | I-295 | 18:55:00 | 19:06:00 |  | 19:33:00 | 03:40:00 |  | 03:51:00 | 03:53:00 |  |  | 8
2018-05-09 00:00:00 | [NAME] |  | Walmart Durbin | 06:39:00 | 06:57:00 |  | 08:06:00 | 15:03:00 |  | 15:49:00 | 16:45:00 |  |  | 8
2018-05-10 00:00:00 | [NAME] |  | Shop | 05:52:00 |  | 0:00:00 |  |  |  |  | 15:24:00 | 0:00:00
2018-05-10 00:00:00 | [NAME] |  | Shop | 18:51:00 |  | 0:00:00 |  |  |  |  | 22:28:00 | 0:00:00
 | [NAME]
 | Grand Total