Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 05132018-05192018

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
05/14/2018 | [NAME] |  | The Strand | 05:40 AM |  | 0:00:00 |  |  |  |  | 04:00 PM | 0:00:00 |  | 4
05/15/2018 | [NAME] |  | Eber | 05:39 AM | 06:42:00 |  | 08:29:00 | 14:34:00 |  | 16:18:00 | 04:20 PM |  |  | 8
05/16/2018 | [NAME] |  | Sunrise | 05:46 AM | 06:58:00 |  | 08:02:00 | 08:58:00 |  |  |  |  |  | 2
05/16/2018 | [NAME] |  | Bainbridge |  |  |  | 09:27:00 | 14:01:00 |  | 14:30:00 | 02:34 PM |  |  | 3
05/17/2018 | [NAME] |  | Cubesmart | 05:59 AM | 06:27:00 |  | 07:14:00 | 09:26:00 |  |  |  |  |  | 4
05/17/2018 | [NAME] |  | Bainbridge |  |  |  | 09:50:00 | 11:58:00 |  | 12:26:00 | 12:31 PM |  |  | 6
05/18/2018 | [NAME] |  | Eber | 05:46 AM | 06:36:00 |  | 08:06:00 | 12:59:00 |  | 14:13:00 | 02:16 PM |  |  | 4
 | Allen Total
05/14/2018 | [NAME] |  | Badging | 01:00 PM | 13:12:00 |  | 13:23:00 | 13:45:00 |  | 13:54:00 | 01:58 PM |  |  | 8
05/15/2018 | [NAME] |  | Azalea Ridge | 07:40 AM |  | 0:00:00 |  |  |  |  | 10:46 AM | 0:00:00 |  | 8
05/16/2018 | [NAME] |  | Walmart Durbin | 06:45 AM | 08:30:00 |  | 09:05:00 | 14:11:00 |  | 14:46:00 | 02:59 PM
05/17/2018 | [NAME] |  | Steel Creek | 06:43 AM | 07:40:00 |  | 08:44:00 | 14:05:00 |  | 14:22:00 | 02:28 PM |  | 1 | 6
05/18/2018 | [NAME] |  |  | 04:40 AM |  | 0:00:00 |  |  |  |  | 08:05 PM | 0:00:00
 | [NAME]
05/14/2018 | [NAME] |  | The Strand | 06:05 AM |  | 0:00:00 | 08:33:00 |  | 0:00:00 |  | 04:34 PM | 0:00:00 |  | 4
05/15/2018 | [NAME] |  | Eber | 05:57 AM | 06:42:00 |  | 08:29:00 | 14:34:00 |  | 16:18:00 | 04:23 PM |  |  | 8
05/16/2018 | [NAME] |  | Sunrise | 06:02 AM | 06:58:00 |  | 08:02:00 | 08:58:00 |  |  |  |  |  | 2
05/16/2018 | [NAME] |  | Bainbridge |  |  |  | 09:27:00 | 14:01:00 |  | 14:30:00 | 03:42 PM | 0:00:00 |  | 3
05/17/2018 | [NAME] |  | Cubesmart | 06:09 AM | 06:27:00 |  | 07:14:00 | 09:26:00 |  |  |  |  |  | 4
05/17/2018 | [NAME] |  | Bainbridge |  |  |  | 09:50:00 | 11:58:00 |  | 12:26:00 | 12:53 PM |  |  | 6
05/18/2018 | [NAME] |  | Eber | 06:04 AM | 06:36:00 |  | 08:06:00 | 12:59:00 |  | 14:13:00 | 03:17 PM | 0:00:00 |  | 4
 | Benjamin Total
05/13/2018 | [NAME] |  | Walmart | 05:01 PM | 17:48:00 |  | 04:59:00 | 07:52:00 |  | 07:59:00 | 08:28 AM
05/14/2018 | [NAME] |  | Walmart | 06:59 PM | 19:10:00 |  | 19:22:00 | 07:33:00 |  | 07:44:00 | 08:02 AM |  |  | 56
05/15/2018 | [NAME] |  | walmart | 05:47 PM | 17:52:00 |  | 19:32:00 | 21:47:00 |  | 21:54:00 | 10:00 PM
05/16/2018 | [NAME] |  | walmart | 11:00 PM | 23:04:00 |  | 23:13:00 | 09:00:00 |  | 09:08:00 | 09:22 AM
05/17/2018 | [NAME] |  | Walmart 2 | 04:51 PM | 17:06:00 |  | 18:36:00 | 07:22:00 |  | 18:31:00 | 06:39 PM
 | Brandon Total
05/14/2018 | Dwayne |  | Adventist | 05:39 AM | 06:40:00 |  | 08:40:00 | 10:27:00 |  | 11:02:00 | 01:00 PM | 0:00:00 |  | 3
05/15/2018 | Dwayne |  | Longwood | 05:38 AM | 06:32:00 |  | 07:45:00 | 15:14:00 |  | 15:43:00 | 04:07 PM |  |  | 3 | 2
05/18/2018 | Dwayne |  | Bainbridge | 05:40 AM | 06:41:00 |  | 10:41:00 | 13:35:00 |  | 13:51:00 | 02:30 PM |  |  | 2
 | [NAME]
05/16/2018 | Edgar |  |  | 05:22 PM |  | 0:00:00 |  |  |  |  | 06:35 PM | 0:00:00
 | [NAME]
05/14/2018 | [NAME] |  | Badging | 07:59 AM | 08:09:00 |  | 10:48:00 | 13:26:00 |  | 14:03:00 | 02:02 PM | 0:00:00 |  | 8
05/15/2018 | [NAME] |  | Steel Creek | 07:00 AM | 08:39:00 |  | 09:08:00 | 11:00:00 |  | 11:00:00 | 11:00 AM |  |  | 8
05/16/2018 | [NAME] |  | Walmart Durbin | 08:04 AM | 09:10:00 |  | 09:25:00 | 14:09:00 |  | 14:48:00 | 03:59 PM |  | 1
05/17/2018 | [NAME] |  | Steel Creek | 07:04 AM | 07:40:00 |  | 08:44:00 | 14:05:00 |  | 14:22:00 | 02:27 PM |  |  | 6
05/18/2018 | [NAME] |  |  | 04:50 AM |  | 0:00:00 |  |  |  |  | 05:00 PM | 0:00:00
 | [NAME]
05/14/2018 | [NAME] |  | The Strand | 06:43 AM |  | 0:00:00 |  |  |  |  | 04:36 PM | 0:00:00 |  | 4
05/15/2018 | [NAME] |  | Longwood | 06:19 AM | 06:32:00 |  | 07:45:00 | 15:14:00 |  | 15:43:00 | 04:00 PM |  |  | 3
05/16/2018 | [NAME] |  | Adventist | 05:45 AM | 06:32:00 |  | 08:02:00 | 16:17:00 |  | 16:55:00 | 05:36 PM |  |  | 5
05/17/2018 | [NAME] |  | Shop | 06:00 AM |  | 0:00:00 |  |  |  |  | 12:53 PM | 0:00:00
05/18/2018 | [NAME] |  | Bainbridge | 06:41 AM | 06:41:00 |  | 10:41:00 | 13:35:00 |  | 12:17:00 | 12:22 PM |  |  | 2
 | [NAME]
05/14/2018 | [NAME] |  | Heritage at Plant | 05:47 AM | 07:31:00 |  | 09:47:00 | 14:48:00 |  | 15:27:00 | 04:41 PM | 0:00:00 |  | 8
05/16/2018 | [NAME] |  | Bainbridge | 06:00 AM | 07:36:00 |  | 08:34:00 | 16:35:00 |  | 17:25:00 | 06:30 PM |  |  | 5
05/17/2018 | [NAME] |  | Eber | 06:00 AM | 07:14:00 |  | 09:14:00 | 14:25:00 |  | 15:45:00 | 03:59 PM |  |  | 4 | 1
05/18/2018 | [NAME] |  | Bainbridge | 05:55 AM | 06:41:00 |  | 10:41:00 | 11:50:00 |  | 12:17:00 | 03:23 PM | 0:00:00 |  | 4
 | Kenneth Total
05/14/2018 | [NAME] |  | Starflyer | 08:09 AM | 08:32:00 |  | 09:33:00 | 10:54:00 |  | 11:44:00 | 11:50 AM |  |  | 2
05/15/2018 | [NAME] |  | Starflyer | 05:56 AM | 07:13:00 |  | 08:18:00 | 14:59:00 |  | 15:41:00 | 04:11 PM |  |  | 3
05/16/2018 | [NAME] |  | Adventist | 05:58 AM | 07:01:00 |  | 07:55:00 | 16:17:00 |  | 16:54:00 | 05:32 PM |  |  | 3
05/17/2018 | [NAME] |  | Cubesmart | 06:01 AM | 07:46:00 |  | 08:21:00 | 09:15:00 |  | 12:24:00 | 02:07 PM | 0:00:00 |  | 4
05/18/2018 | [NAME] |  | Bainbridge | 06:00 AM | 06:56:00 |  | 12:32:00 | 14:39:00 |  | 15:07:00 | 03:12 PM |  |  | 4
 | Patrick Total
05/13/2018 | [NAME] |  | Walmart | 05:01 PM | 17:48:00 |  | 04:59:00 | 07:52:00 |  | 07:59:00 | 08:28 AM
05/14/2018 | [NAME] |  | Walmart | 07:00 PM | 19:10:00 |  | 19:22:00 | 07:33:00 |  | 07:44:00 | 08:01 AM |  |  | 56
05/15/2018 | [NAME] |  | walmart | 05:46 PM | 17:52:00 |  | 19:32:00 | 21:47:00 |  | 21:54:00 | 09:58 PM
05/16/2018 | [NAME] |  | Walmart | 11:00 PM | 23:04:00 |  | 23:13:00 | 09:00:00 |  | 09:08:00 | 09:22 AM
05/17/2018 | [NAME] |  | Walmart 2 | 04:51 PM | 17:06:00 |  | 18:36:00 | 07:22:00 |  | 18:31:00 | 06:38 PM
 | Rocco Total
05/14/2018 | [NAME] |  | Walmart | 02:28 PM | 17:30:00 |  | 21:46:00 | 08:00:00 |  | 08:07:00 | 07:55 AM | 0:00:00 |  | 56
05/15/2018 | [NAME] |  | walmart | 05:00 PM | 19:01:00 |  | 21:49:00 | 02:38:00 |  | 04:50:00 | 05:04 AM
05/16/2018 | [NAME] |  | Walmart | 04:47 PM | 17:21:00 |  | 20:22:00 | 05:43:00 |  | 07:59:00 | 08:40 AM
05/17/2018 | [NAME] |  | Walmart 2 | 04:28 PM | 17:06:00 |  | 20:05:00 | 08:03:00 |  | 09:07:00 | 09:16 AM
05/18/2018 | [NAME] |  | Walmart 2 | 04:42 PM | 17:35:00 |  | 20:27:00 | 02:46:00 |  | 04:26:00 | 05:29:00 |  |  | 36
 | [NAME]
05/14/2018 | Terrance |  | Heritage at Plant | 06:03:00 | 07:31:00 |  | 09:47:00 | 14:48:00 |  | 15:27:00 | 16:42:00 | 0:00:00 |  | 8
05/15/2018 | Terrance |  | shop | 06:32:00 |  | 0:00:00 |  |  |  |  | 15:02:00 | 0:00:00
05/16/2018 | Terrance |  | Bainbridge | 06:09:00 | 07:36:00 |  | 08:34:00 | 16:35:00 |  | 17:25:00 | 18:30:00 |  |  | 5
05/17/2018 | Terrance |  | Eber | 06:31:00 | 07:14:00 |  | 09:14:00 | 14:25:00 |  | 15:45:00 | 16:00:00 |  |  | 4
05/18/2018 | Terrance |  | Bainbridge | 06:09:00 | 06:41:00 |  | 10:41:00 | 11:50:00 |  | 12:17:00 | 15:32:00 | 0:00:00 |  | 2.5
 | Terrance Total
05/14/2018 | [NAME] |  | Walmart | 13:32:00 | 17:30:00 |  | 21:46:00 | 08:00:00 |  | 08:07:00 | 09:54:00 | 0:00:00 |  | 56
05/15/2018 | [NAME] |  | Walmart | 06:37 PM | 19:01:00 |  | 21:49:00 | 02:38:00 |  | 04:50:00 | 04:40 AM | 0:00:00
05/16/2018 | [NAME] |  | walmart | 04:48 PM | 17:21:00 |  | 20:22:00 | 05:43:00 |  | 07:59:00 | 08:25 AM
05/17/2018 | [NAME] |  | Walmart 2 | 04:42 PM | 17:06:00 |  | 20:05:00 | 08:03:00 |  | 09:07:00 | 09:16 AM
05/18/2018 | [NAME] |  | Walmart 2 | 05:18 PM | 17:35:00 |  | 20:27:00 | 02:46:00 |  | 04:26:00 | 05:21:00 |  |  | 36
 | [NAME]
05/15/2018 | [NAME] |  | Oak Trail | 06:54 AM | 07:13:00 |  | 08:25:00 | 13:26:00 |  | 13:34:00 | 04:00 PM | 0:00:00 |  | 8
05/16/2018 | [NAME] |  | USPS | 06:00 AM | 06:21:00 |  | 07:35:00 | 09:31:00 |  |  | 03:30 PM |  |  | 1 | 1
05/16/2018 | [NAME] |  | Oak Trail |  |  |  | 09:39:00 | 12:56:00 |  | 14:13:00 | 03:30 PM |  |  | 8
05/17/2018 | [NAME] |  | Hollywood | 07:00 AM | 07:22:00 |  | 09:12:00 | 15:14:00 |  | 15:24:00 | 04:00 PM |  |  | 2
05/18/2018 | [NAME] |  | Adventist | 06:00 AM | 06:28:00 |  | 08:18:00 | 12:06:00 |  | 12:41:00 | 12:55 PM |  |  | 1.5
 | Willie S Total
05/14/2018 | Willie |  | Adventist | 05:58 AM | 06:40:00 |  | 08:40:00 | 10:27:00 |  | 11:02:00 | 11:12 AM |  |  | 3
05/15/2018 | Willie |  | Eber | 05:55 AM | 06:46:00 |  | 08:18:00 | 14:32:00 |  | 15:44:00 | 03:51 PM |  |  | 8
05/17/2018 | Willie |  | Cubesmart | 05:54 AM | 07:46:00 |  | 09:15:00 | 12:24:00 |  | 12:45:00 | 12:51 PM |  |  | 4 | 1
05/18/2018 | Willie |  | shop | 06:10 AM |  | 0:00:00 |  |  |  |  | 01:51 PM | 0:00:00 |  | 8
 | Willie Total
05/15/2018 | Zachary |  | Adventist | 05:55 AM | 06:28:00 |  | 08:18:00 | 12:06:00 |  | 12:41:00 | 04:17 PM | 0:00:00 |  | 3
05/15/2018 | Zachary |  | Starflyer |  |  |  |  |  |  |  |  |  |  | 8
05/16/2018 | Zachary |  | Adventist | 05:58 AM | 07:01:00 |  | 07:55:00 | 16:17:00 |  | 16:54:00 | 05:06 PM |  |  | 3
05/17/2018 | Zachary |  | Cubesmart | 05:57 AM | 07:46:00 |  | 08:21:00 | 09:15:00 |  | 12:24:00 | 12:55 PM |  |  | 4
05/18/2018 | Zachary |  | Oak Ridge | 05:54 AM | 06:56:00 |  | 07:55:00 | 11:25:00 |  |  |  |  |  | 2.5
05/18/2018 | Zachary |  | Bainbridge |  |  |  | 12:32:00 | 14:39:00 |  | 15:07:00 | 03:24 PM |  |  | 3
 | Zachary Total
2018-05-14 00:00:00 | [NAME] |  | Starflyer | 06:08:00 | 08:32:00 |  | 09:33:00 | 10:54:00 |  | 11:44:00 | 12:41:00 |  |  | 2
2018-05-15 00:00:00 | [NAME] |  | Eber | 05:57:00 | 06:46:00 |  | 08:18:00 | 14:32:00 |  | 15:44:00 | 16:11:00 |  |  | 8
2018-05-16 00:00:00 | [NAME] |  | Bainbridge | 06:04:00 | 07:33:00 |  | 08:34:00 | 16:37:00 |  | 16:25:00 | 17:35:00 |  |  | 5
2018-05-17 00:00:00 | [NAME] |  | Cubesmart | 06:05:00 | 07:46:00 |  | 09:15:00 | 12:24:00 |  | 12:45:00 | 14:07:00 |  |  | 4
2018-05-18 00:00:00 | [NAME] |  | shop | 06:05:00 |  | 0:00:00 |  |  |  |  | 14:04:00 | 0:00:00 |  | 8
 | [NAME]
 | Grand Total