Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 06032018-06092018

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
06/05/2018 | [NAME] |  | Champions | 06:01 AM | 06:41:00 |  | 09:49:00 | 15:47:00 |  | 17:14:00 | 05:30 PM |  |  | 2.5
06/06/2018 | [NAME] |  | Hyatt | 05:46 AM | 06:41:00 |  | 08:12:00 | 13:47:00 |  | 14:33:00 | 02:36 PM |  |  | 4
06/07/2018 | [NAME] |  | Champions | 05:43 AM | 07:00:00 | 0:00:00 | 08:24:00 | 09:58:00 |  |  |  |  |  | 2.5 | 1
06/07/2018 | [NAME] |  | Hyatt |  |  |  | 10:37:00 | 12:32:00 |  |  |  |  |  | 2.5
06/07/2018 | [NAME] |  | The Gatherings |  |  |  | 13:50:00 | 16:11:00 |  | 16:49:00 | 05:03 PM |  |  | 1
06/08/2018 | [NAME] |  | Racetrac | 05:49 AM | 06:55:00 |  | 09:13:00 | 10:16:00 |  |  | 01:28 PM | 0:00:00
 | Allen Total
06/04/2018 | [NAME] |  | [NAME] | 07:16 AM | 07:53:00 |  | 08:51:00 | 16:12:00 |  | 16:30:00 | 05:03 PM |  |  | 6
06/05/2018 | [NAME] |  | [NAME] | 06:40 AM | 07:01:00 |  | 07:50:00 | 15:17:00 |  | 15:42:00 | 03:52 PM |  |  | 6
06/06/2018 | [NAME] |  | [NAME] | 06:46 AM | 07:36:00 |  | 08:21:00 | 12:22:00 |  | 13:13:00 | 01:58 PM |  |  | 6
06/07/2018 | [NAME] |  | [NAME] | 03:29 AM | 03:36:00 |  | 10:30:00 | 15:37:00 |  | 16:16:00 | 04:38 PM |  |  | 6
06/08/2018 | [NAME] |  | [NAME] | 07:23 AM | 07:29:00 |  | 08:23:00 | 13:44:00 |  | 14:18:00 | 03:10 PM |  |  | 2
 | [NAME]
06/04/2018 | [NAME] |  | Adventist | 06:01:00 | 07:06:00 |  | 08:13:00 | 13:30:00 |  |  |  |  |  | 6
06/04/2018 | [NAME] |  | Adventist 2 |  |  |  | 13:56:00 | 14:22:00 |  | 16:20:00 | 16:48:00 |  |  | 2
06/05/2018 | [NAME] |  | [NAME] | 06:00:00 | 06:47:00 |  | 09:24:00 | 14:51:00 |  | 15:18:00 | 16:50:00 | 0:00:00 |  | 5
06/06/2018 | [NAME] |  | Shop | 08:50:00 |  | 0:00:00 |  |  |  |  | 15:44:00 | 0:00:00 |  |  | 1
06/08/2018 | [NAME] |  | Racetrac | 06:01:00 | 06:55:00 |  | 09:13:00 | 10:16:00 |  |  |  |  |  | 2.5
06/08/2018 | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 8
06/08/2018 | [NAME] |  | Hindu |  |  |  |  |  |  |  | 15:34:00 | 0:00:00 |  | 8
 | [NAME]
06/06/2018 | [NAME] |  | Champions | 06:06 AM | 06:53:00 |  | 08:49:00 | 10:08:00 |  |  |  |  |  | 8
06/06/2018 | [NAME] |  | Hyatt |  |  |  | 11:19:00 | 12:39:00 |  | 13:23:00 | 01:29 PM |  |  | 4
06/07/2018 | [NAME] |  | Hindu | 06:30 AM | 06:50:00 |  | 07:26:00 | 09:34:00 |  |  |  |  |  | 4
06/07/2018 | [NAME] |  | [NAME] |  |  |  | 10:35:00 | 14:22:00 |  | 14:30:00 | 02:52 PM |  |  | 4
06/08/2018 | [NAME] |  | Racetrac | 06:11 AM | 06:48:00 |  | 07:32:00 | 09:13:00 |  | 12:57:00 | 02:30 PM | 0:00:00 |  | 8
 | Benjamin Total
[NAME] | [NAME] |  | Walmart | 05:37 PM | 18:25:00 |  | 22:06:00 | 07:02:00 |  | 07:41:00 | 07:55 AM |  |  | 72
06/04/2018 | [NAME] |  | Walmart | 05:01 PM | 17:06:00 |  | 18:14:00 | 05:45:00 |  | 06:21:00 | 06:30 AM
06/05/2018 | [NAME] |  | Walmart | 04:13 PM | 16:25:00 |  | 17:36:00 | 06:59:00 |  | 07:19:00 | 07:39 AM
06/06/2018 | [NAME] |  | Walmart | 05:01 PM | 17:19:00 |  | 18:41:00 | 06:39:00 |  | 07:08:00 | 07:15 AM
06/07/2018 | [NAME] |  | Walmart | 05:33 PM | 17:38:00 |  | 18:35:00 | 07:05:00 |  | 08:24:00 | 09:01 AM
 | Brandon Total
06/04/2018 | Dwayne |  | 7 eleven | 05:36 AM | 06:15:00 |  | 06:50:00 | 13:27:00 |  | 14:30:00 | 02:39 PM |  | x | 6
06/05/2018 | Dwayne |  | Champions | 05:39 AM | 06:41:00 |  | 09:49:00 | 15:47:00 |  | 17:14:00 | 05:22 PM |  |  | 2.5
06/06/2018 | Dwayne |  | Hyatt | 05:47 AM | 06:41:00 |  | 08:12:00 | 13:47:00 |  | 14:33:00 | 03:40 PM | 0:00:00 |  | 4
06/07/2018 | Dwayne |  | Champions | 07:04 AM | 07:00:00 | 0:00:00 | 08:24:00 | 09:58:00 |  |  |  |  |  | 2.5 | 1
06/07/2018 | Dwayne |  | Hyatt |  |  |  | 10:37:00 | 12:32:00 |  |  |  |  |  | 2.5
06/07/2018 | Dwayne |  | The Gatherings |  |  |  | 13:50:00 | 16:11:00 |  | 16:49:00 | 04:51 PM |  |  | 1
 | [NAME]
[NAME] | Edgar |  | [NAME] | 04:42 PM | 17:38:00 |  | 17:57:00 | 04:58:00 |  | 05:30:00 | 05:41 AM |  |  | 40
06/04/2018 | Edgar |  | [NAME] | 05:22 PM | 17:29:00 |  | 18:13:00 | 01:09:00 |  | 01:29:00 | 01:35 AM
06/05/2018 | Edgar |  | [NAME] | 05:58 PM | 18:10:00 |  | 18:50:00 | 05:06:00 |  | 05:26:00 | 05:31 AM
06/06/2018 | Edgar |  | [NAME] | 05:20 PM | 17:59:00 |  | 19:09:00 | 05:14:00 |  | 05:35:00 | 05:39 AM
06/07/2018 | Edgar |  | [NAME] | 05:36 PM | 18:17:00 |  | 18:58:00 | 05:57:00 |  | 06:20:00 | 06:43 AM
 | [NAME]
[NAME] | Efrain |  | Walmart | 10:56 PM | 18:45:00 | 0:00:00 | 19:43:00 | 04:59:00 |  | 06:08:00 | 05:40 AM | 0:00:00
06/04/2018 | Efrain |  | Walmart | 07:30 PM | 18:29:00 | 0:00:00 | 20:34:00 | 05:42:00 |  | 07:00:00 | 06:28 AM | 0:00:00
06/05/2018 | Efrain |  | Walmart | 07:01 PM | 17:53:00 | 0:00:00 | 20:18:00 | 05:55:00 |  | 07:11:00 | 06:41 AM | 0:00:00
06/06/2018 | Efrain |  | Walmart | 07:00 PM | 18:09:00 | 0:00:00 | 20:10:00 | 05:20:00 |  | 05:55:00 | 05:27 AM | 0:00:00
06/07/2018 | Efrain |  | Walmart | 06:25 PM | 17:08:00 | 0:00:00 | 20:09:00 | 06:28:00 |  | 08:23:00 | 10:35 AM | 0:00:00
 | Efrain Total
06/04/2018 | [NAME] |  | [NAME] | 07:11 AM | 07:53:00 |  | 08:51:00 | 16:12:00 |  | 16:30:00 | 04:57 PM |  |  | 6
06/05/2018 | [NAME] |  | [NAME] | 06:42 AM | 07:01:00 |  | 07:50:00 | 15:17:00 |  | 15:42:00 | 01:36 PM | 0:00:00 |  | 6
06/06/2018 | [NAME] |  | [NAME] | 07:41 AM | 07:36:00 | 0:00:00 | 08:21:00 | 12:22:00 |  | 13:13:00 | 01:13 PM |  |  | 6
06/07/2018 | [NAME] |  | Hindu | 05:51 AM | 06:55:00 |  | 10:35:00 | 12:35:00 |  |  |  |  |  | 8
06/07/2018 | [NAME] |  | Maitland |  |  |  |  |  |  |  | 06:23 PM | 0:00:00 |  | 3
06/08/2018 | [NAME] |  | fish | 05:43 AM |  | 0:00:00 |  |  |  |  | 05:00 PM | 0:00:00 |  | 2
 | [NAME]
06/04/2018 | [NAME] |  | Adventist | 06:27 AM | 07:06:00 |  | 08:13:00 | 13:30:00 |  |  |  |  |  | 6
06/04/2018 | [NAME] |  | Adventist 2 |  |  |  | 13:56:00 | 14:22:00 |  | 16:20:00 | 04:23 PM |  |  | 2
06/05/2018 | [NAME] |  | [NAME] | 06:04 AM | 06:47:00 |  | 09:24:00 | 14:51:00 |  | 15:18:00 | 04:00 PM |  |  | 5
06/06/2018 | [NAME] |  | Champions | 06:28 AM | 06:53:00 |  | 08:49:00 | 10:08:00 |  |  |  |  |  | 8
06/06/2018 | [NAME] |  | Hyatt |  |  |  | 11:19:00 | 12:39:00 |  | 13:23:00 | 01:26 PM |  |  | 4
06/07/2018 | [NAME] |  | Hindu | 06:08 AM | 06:50:00 |  | 07:26:00 | 09:34:00 |  |  |  |  |  | 4
06/07/2018 | [NAME] |  | [NAME] |  |  |  | 10:35:00 | 14:22:00 |  | 14:30:00 | 02:52 PM |  |  | 4
06/08/2018 | [NAME] |  | Racetrac | 06:11 AM | 06:48:00 |  | 07:32:00 | 09:13:00 |  | 12:57:00 | 01:15 PM |  |  | 8
 | [NAME]
06/04/2018 | [NAME] |  | Walmart | 06:00 PM | 18:25:00 |  | 22:06:00 | 07:02:00 |  | 07:41:00 | 07:30 AM | 0:00:00 |  | 72
 | Kenneth Total
[NAME] | Logan |  | Walmart | 05:44 PM | 18:45:00 |  | 19:43:00 | 04:59:00 |  | 06:08:00 | 06:49 AM
06/04/2018 | Logan |  | Walmart | 06:10 PM | 18:29:00 |  | 20:34:00 | 05:42:00 |  | 07:00:00 | 06:00 AM | 0:00:00 |  | 72
06/05/2018 | Logan |  | Walmart | 06:05 PM | 17:53:00 | 0:00:00 | 20:18:00 | 05:55:00 |  | 07:11:00 | 07:15 AM
06/06/2018 | Logan |  | Walmart | 06:00 PM | 18:09:00 |  | 20:10:00 | 05:20:00 |  | 05:55:00 | 06:00 AM
06/07/2018 | Logan |  | Walmart | 04:35 PM | 17:08:00 |  | 20:09:00 | 06:28:00 |  | 08:23:00 | 10:35 AM | 0:00:00
 | Logan Total
[NAME] | Nick |  | [NAME] | 17:00:00 | 17:38:00 |  | 17:57:00 | 04:58:00 |  | 05:30:00 | 05:41:00 |  |  | 40
06/04/2018 | Nick |  | [NAME] | 17:05:00 | 17:29:00 |  | 18:13:00 | 01:09:00 |  | 01:29:00 | 01:43:00
06/05/2018 | Nick |  | [NAME] | 17:44:00 | 18:10:00 |  | 18:50:00 | 05:06:00 |  | 05:26:00 | 05:31:00
06/06/2018 | Nick |  | [NAME] | 17:40:00 | 17:59:00 |  | 19:09:00 | 05:14:00 |  | 05:35:00 | 05:38:00
06/07/2018 | Nick |  | [NAME] | 17:36:00 | 18:17:00 |  | 18:58:00 | 05:57:00 |  | 06:20:00 | 06:43:00
 | Nick Total
06/04/2018 | [NAME] |  | The Strand | 06:30 AM | 07:57:00 |  | 08:21:00 | 09:53:00 |  |  |  |  |  | 2
2018-06-04 00:00:00 | [NAME] |  | Ashton |  |  |  | 10:19:00 | 11:11:00 |  | 12:22:00 | 03:38 PM | 0:00:00 |  | 4
06/05/2018 | [NAME] |  | Champions | 06:11 AM | 07:15:00 |  | 08:26:00 | 13:50:00 |  | 14:40:00 | 04:04 PM | 0:00:00 |  | 3
06/06/2018 | [NAME] |  | Maitland | 05:59 AM | 06:32:00 |  | 07:14:00 | 15:50:00 |  | 16:20:00 | 04:27 PM |  |  | 7
06/07/2018 | [NAME] |  | Maitland | 06:19 AM | 07:39:00 |  | 08:23:00 | 15:50:00 |  | 16:17:00 | 04:21 PM
06/07/2018 | [NAME] |  | Maitland |  |  |  |  |  |  |  | 04:26 PM | 0:00:00
06/08/2018 | [NAME] |  | AFCO | 05:57 AM | 06:55:00 |  | 07:24:00 | 07:30:00 |  |  | 15:35:00 | 0:00:00 |  | 1
06/08/2018 | [NAME] |  | Bainbridge |  |  |  |  |  |  |  |  |  |  | 8
06/08/2018 | [NAME] |  | Hindu |  |  |  |  |  |  |  |  |  |  | 8
06/08/2018 | [NAME] |  | Samoy |  |  |  |  |  |  |  | 03:35 PM | 0:00:00 |  | 0.1
 | Patrick Total
[NAME] | [NAME] |  | Walmart | 05:37 PM | 18:25:00 |  | 22:06:00 | 07:02:00 |  | 07:41:00 | 07:55 AM |  |  | 72
06/04/2018 | [NAME] |  | Walmart | 05:01 PM | 17:06:00 |  | 18:14:00 | 05:45:00 |  | 06:21:00 | 06:30 AM
06/05/2018 | [NAME] |  | Walmart | 04:13 PM | 16:25:00 |  | 17:36:00 | 06:59:00 |  | 07:19:00 | 07:39 AM
06/06/2018 | [NAME] |  | Walmart | 05:01 PM | 17:19:00 |  | 18:41:00 | 06:39:00 |  | 07:08:00 | 07:14 AM
06/07/2018 | [NAME] |  | Walmart | 05:32 PM | 17:38:00 |  | 18:35:00 | 07:05:00 |  | 08:24:00 | 09:02 AM
 | Rocco Total
06/04/2018 | [NAME] |  | [NAME] | 06:00 AM | 07:42:00 |  | 09:33:00 | 16:16:00 |  | 16:43:00 | 04:45 PM |  |  | 5
06/05/2018 | [NAME] |  | [NAME] | 06:00 AM | 07:40:00 |  | 08:25:00 | 15:32:00 |  | 16:07:00 | 04:50 PM |  |  | 8
06/06/2018 | [NAME] |  | Spring Hill | 06:02 AM | 07:51:00 |  | 08:53:00 | 09:10:00 |  |  |  |  |  | 4
06/06/2018 | [NAME] |  | [NAME] |  |  |  | 10:35:00 | 12:35:00 |  | 13:01:00 | 01:40 PM |  |  | 5
06/07/2018 | [NAME] |  | shop | 06:01 AM |  |  |  |  |  |  | 03:56 PM | 0:00:00
06/08/2018 | [NAME] |  | Oak Trail | 06:00 AM | 06:50:00 |  | 09:03:00 | 11:39:00 |  | 12:21:00 | 01:54 PM | 0:00:00 |  | 2
 | Ryan Total
[NAME] | [NAME] |  | Walmart | 04:47 PM | 17:13:00 |  | 18:22:00 | 05:42:00 |  | 05:50:00 | 06:00 AM |  |  | 72
06/04/2018 | [NAME] |  | Walmart | 04:42 PM | 17:10:00 |  | 18:04:00 | 12:30:00 |  | 00:34:00 | 12:44 AM
06/05/2018 | [NAME] |  | Walmart | 05:23 PM | 17:50:00 |  | 18:03:00 | 12:35:00 |  | 00:44:00 | 01:07 AM
06/06/2018 | [NAME] |  | Walmart | 04:54 PM | 17:09:00 |  | 17:14:00 | 09:05:00 |  | 09:15:00 | 09:24 AM
06/07/2018 | [NAME] |  | Walmart | 05:07 PM |  | 0:00:00 |  |  |  |  | 04:00 PM | 0:00:00
 | [NAME]
06/04/2018 | Terrance |  | [NAME] | 06:05 AM | 07:42:00 |  | 09:33:00 | 16:16:00 |  | 16:43:00 | 06:00 PM | 0:00:00 |  | 5
06/05/2018 | Terrance |  | [NAME] | 06:15 AM | 07:40:00 |  | 08:25:00 | 15:32:00 |  | 16:07:00 | 05:06 PM |  |  | 8
06/06/2018 | Terrance |  | Spring Hill | 07:35 AM | 07:51:00 |  | 08:53:00 | 09:10:00 |  |  |  |  |  | 4
06/06/2018 | Terrance |  | [NAME] |  |  |  | 10:35:00 | 12:35:00 |  | 13:01:00 | 03:17 PM | 0:00:00 |  | 5
06/07/2018 | Terrance |  | shop | 06:04 AM |  |  |  |  |  |  | 04:46 PM | 0:00:00
06/08/2018 | Terrance |  | Oak Trail | 06:04 AM | 06:50:00 |  | 09:03:00 | 11:39:00 |  | 12:21:00 | 05:55 PM | 0:00:00 |  | 2
 | Terrance Total
[NAME] | [NAME] |  | Walmart | 04:47 PM | 17:13:00 |  | 18:22:00 | 05:42:00 |  | 05:50:00 | 06:00 AM |  |  | 72
06/04/2018 | [NAME] |  | Walmart | 04:42 PM | 17:10:00 |  | 18:04:00 | 12:30:00 |  | 00:34:00 | 12:44 AM
06/05/2018 | [NAME] |  | Walmart | 05:23 PM | 17:50:00 |  | 18:03:00 | 12:35:00 |  | 00:44:00 | 01:07 AM
06/06/2018 | [NAME] |  | Walmart | 04:54 PM | 17:09:00 |  | 17:14:00 | 09:05:00 |  | 09:15:00 | 09:24 AM
06/07/2018 | [NAME] |  | Walmart | 05:07 PM |  | 0:00:00 |  |  |  |  | 03:36 PM | 0:00:00
 | [NAME]
06/04/2018 | Willie |  | 7 eleven | 05:59 AM | 06:15:00 |  | 06:50:00 | 13:27:00 |  | 14:30:00 | 02:37 PM |  |  | 6
06/05/2018 | Willie |  | Champions | 06:16 AM | 06:41:00 |  | 09:49:00 | 15:47:00 |  | 17:14:00 | 02:55 PM | 0:00:00
06/06/2018 | Willie |  | Maitland | 06:00 AM |  | 0:00:00 |  |  |  |  |  |  |  | 7
06/07/2018 | Willie |  | Hindu | 05:54 AM | 06:55:00 |  | 10:35:00 | 12:35:00 |  |  | 04:20 PM | 0:00:00 |  | 4
06/07/2018 | Willie |  | Maitland |  |  |  |  |  |  |  | 04:20 PM | 0:00:00 |  | 3
06/08/2018 | Willie |  | Racetrac | 06:01 AM | 06:55:00 |  | 09:13:00 | 10:16:00 |  |  |  |  |  | 2.5
06/08/2018 | Willie |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 8
06/08/2018 | Willie |  | Hindu |  |  |  |  |  |  |  | 11:35 AM | 0:00:00 |  | 8
 | Willie Total
[NAME] | Zachary |  | [NAME] | 05:02 PM | 17:38:00 |  | 17:57:00 | 04:58:00 |  | 05:30:00 | 05:40 AM |  |  | 40
06/04/2018 | Zachary |  | [NAME] | 05:07 PM | 17:29:00 |  | 18:13:00 | 01:09:00 |  | 01:29:00 | 01:34 AM
06/05/2018 | Zachary |  | [NAME] | 05:30 PM | 18:10:00 |  | 18:50:00 | 05:06:00 |  | 05:26:00 | 05:32 AM
06/06/2018 | Zachary |  | [NAME] | 05:26 PM | 17:59:00 |  | 19:09:00 | 05:14:00 |  | 05:35:00 | 05:39 AM
06/07/2018 | Zachary |  | [NAME] | 05:35 PM | 18:17:00 |  | 18:58:00 | 05:57:00 |  | 06:20:00 | 06:38 AM
 | Zachary Total