Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 08122018-08182018

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
08/13/2018 | [NAME] | 6 | [NAME] | 05:51 AM | 07:01:00 |  | 10:25:00 | 15:25:00 |  | 16:08:00 | 04:09 PM |  |  | 5
08/14/2018 | [NAME] |  | The crossing | 05:50 AM | 07:00:00 |  | 08:13:00 | 12:08:00 |  | 15:13:00 | 03:50 PM |  |  | 6 | 1
08/16/2018 | [NAME] |  | [NAME] | 05:50 AM | 06:28:00 |  | 07:32:00 | 09:57:00 |  |  |  |  |  | 4
08/16/2018 | [NAME] |  | Vera |  |  |  | 13:26:00 | 15:15:00 |  | 15:28:00 | 03:30 PM |  |  | 3
08/17/2018 | [NAME] |  | Champions | 05:54 AM |  | 0:00:00 |  |  |  |  |  |  |  | 1.5
08/17/2018 | [NAME] |  | East Airfield |  |  |  |  |  |  |  | 03:28 PM | 0:00:00 |  | 6
 | Allen Total
08/13/2018 | [NAME] |  | [NAME] | 12:33 PM |  | 0:00:00 |  |  |  |  | 03:21 PM | 0:00:00
08/16/2018 | [NAME] |  |  | 06:35 AM | 07:13:00 |  | 08:19:00 | 15:34:00 |  | 16:10:00 | 04:27 PM
08/17/2018 | [NAME] |  |  | 06:59 AM | 07:35:00 |  | 08:47:00 | 15:18:00 |  | 16:41:00 | 04:46 PM
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 15
08/13/2018 | [NAME] | 1 | Lake lucerne | 06:07 AM | 06:48:00 |  | 08:52:00 | 11:20:00 |  |  |  |  |  | 3
08/13/2018 | [NAME] |  | [NAME] |  |  |  | 13:25:00 | 15:26:00 |  | 16:12:00 | 04:17 PM |  |  | 3
08/14/2018 | [NAME] |  | Retreat | 06:01 AM | 06:51:00 |  | 08:16:00 | 09:37:00 |  |  |  |  |  | 2
08/14/2018 | [NAME] |  | [NAME] |  |  |  | 11:06:00 | 15:13:00 |  | 15:58:00 | 05:23 PM |  |  | 4
08/15/2018 | [NAME] |  | LS 8 | 06:05 AM | 06:42:00 |  | 07:31:00 | 09:22:00 |  |  |  |  |  | 1 | 1
08/15/2018 | [NAME] |  | Grand lakes |  |  |  | 11:37:00 | 12:31:00 |  |  |  |  |  | 3
08/15/2018 | [NAME] |  | Vera |  |  |  | 14:09:00 | 16:05:00 |  | 16:43:00 | 05:00 PM |  |  | 4
08/17/2018 | [NAME] |  | East Airfield | 06:11 AM | 06:48:00 |  | 09:05:00 | 10:39:00 |  |  |  |  |  | 8
08/17/2018 | [NAME] |  | Old Lockwood |  |  |  | 14:44:00 | 15:07:00 |  | 15:23:00 | 03:57 PM
2018-08-18 00:00:00 | [NAME] |  | [NAME] | 07:00:00 | 07:03:00 |  | 08:07:00 | 13:00:00 |  | 13:45:00 | 13:55:00 |  |  | 5
 | Benjamin Total
08/13/2018 | [NAME] |  |  | 08:16 PM |  | 0:00:00 |  |  |  |  | 20:47:00 | 0:00:00
08/14/2018 | [NAME] |  | Walmart | 06:52 PM | 19:13:00 |  | 12:17:00 | 05:41:00 |  | 06:53:00 | 07:25 AM |  |  | 48
08/15/2018 | [NAME] |  |  | 05:58 PM | 18:01:00 |  | 18:19:00 | 06:43:00 |  | 07:08:00 | 07:00 AM | 0:00:00
08/16/2018 | [NAME] |  |  | 07:16 PM | 19:13:00 | 0:00:00 | 19:28:00 | 01:16:00 |  | 02:37:00 | 02:51 AM
08/17/2018 | [NAME] |  |  | 08:20 PM | 20:19:00 | 0:00:00 | 20:40:00 | 05:00:00 |  | 05:25:00 | 05:30 AM
 | Brandon Total
08/13/2018 | Dwayne | 2 | [NAME] | 05:51 AM | 06:28:00 |  | 08:52:00 | 13:54:00 |  | 15:50:00 | 03:57 PM |  |  | 8
08/14/2018 | Dwayne | 10 | [NAME] | 05:51 AM | 06:44:00 |  | 07:30:00 | 14:29:00 |  | 15:00:00 | 04:02 PM |  |  | 5
08/15/2018 | Dwayne |  | Grand lakes | 05:54 AM | 06:29:00 |  | 07:52:00 | 17:26:00 |  | 18:04:00 | 06:08 PM |  |  | 6 | 1
08/16/2018 | Dwayne |  | [NAME] | 05:54 AM | 06:28:00 |  | 07:32:00 | 09:57:00 |  |  |  |  |  | 4
08/16/2018 | Dwayne |  | Vera |  |  |  | 13:26:00 | 15:15:00 |  | 15:28:00 | 03:34 PM |  |  | 3
 | [NAME]
08/13/2018 | Edgar | 8 | UCF | 05:56 AM | 06:32:00 |  | 12:11:00 | 13:12:00 |  |  |  |  |  | 1.5
08/13/2018 | Edgar |  | Walgreen |  |  |  | 07:52:00 | 08:45:00 |  |  |  |  |  | 2
08/13/2018 | Edgar |  | Old Lockwood |  |  |  | 09:27:00 | 11:20:00 |  | 14:37:00 | 02:48 PM |  |  | 1.5
08/14/2018 | Edgar |  | OIA | 06:00 AM | 06:33:00 |  | 07:40:00 | 13:36:00 |  | 14:27:00 | 05:28 PM | 0:00:00 |  | 4
08/15/2018 | Edgar |  | [NAME] | 05:59 AM | 06:27:00 |  | 09:01:00 | 15:02:00 |  | 17:03:00 | 05:15 PM |  |  | 7
08/16/2018 | Edgar |  | Vera | 06:00 AM | 06:30:00 |  | 07:34:00 | 14:57:00 |  | 15:23:00 | 03:31 PM |  |  | 6
08/17/2018 | Edgar |  | East Airfield | 05:59 AM | 06:16:00 |  | 07:20:00 | 14:58:00 |  | 15:30:00 | 04:10 PM |  |  | 8
 | [NAME]
08/12/2018 | Efrain |  |  | 05:36 PM |  | 0:00:00 |  |  |  |  | 06:31 PM | 0:00:00
08/13/2018 | Efrain |  | walmart | 05:24 PM | 17:34:00 |  | 12:34:00 | 06:40:00 |  | 08:36:00 | 08:40 AM |  |  | 48
08/14/2018 | Efrain |  |  | 05:00 PM | 17:06:00 |  | 17:35:00 | 05:45:00 |  | 07:20:00 | 08:49 AM
08/15/2018 | Efrain |  |  | 03:06 PM | 15:31:00 |  | 16:00:00 | 05:10:00 |  | 07:54:00 | 08:14 AM
08/16/2018 | Efrain |  |  | 05:01 PM | 17:09:00 |  | 17:31:00 | 07:14:00 |  | 07:18:00 | 07:39 AM
08/17/2018 | Efrain |  |  | 04:42 PM | 16:45:00 |  | 17:19:00 | 05:15:00 |  | 05:50:00 | 05:58 AM
 | Efrain Total
08/13/2018 | [NAME] | 7 | Bridge | 05:33 AM | 07:29:00 |  | 09:44:00 | 12:08:00 |  |  |  |  |  | 4
08/13/2018 | [NAME] |  | Rolling Oaks |  |  |  | 12:35:00 | 12:59:00 |  | 13:49:00 | 04:28 PM | 0:00:00 |  | 4
08/14/2018 | [NAME] |  | Avalon | 06:02 AM | 06:13:00 |  | 06:53:00 | 07:06:00 |  | 07:43:00 | 05:00 PM | 0:00:00 |  | 4
08/15/2018 | [NAME] |  | Lake Dexter | 06:15 AM | 08:57:00 | 0:00:00 | 09:17:00 | 14:50:00 |  | 14:50:00 | 05:00 PM | 0:00:00 |  | 5
 | [NAME]
08/13/2018 | [NAME] | 1 | Lake lucerne | 06:48 AM | 06:48:00 |  | 08:52:00 | 11:20:00 |  |  |  |  |  | 3
08/13/2018 | [NAME] |  | [NAME] |  |  |  | 13:25:00 | 15:26:00 |  | 16:12:00 | 04:16 PM |  |  | 3
08/14/2018 | [NAME] |  | Retreat | 07:16 AM | 06:51:00 | 0:00:00 | 08:16:00 | 09:37:00 |  |  |  |  |  | 2
08/14/2018 | [NAME] |  |  |  |  |  | 11:06:00 | 15:13:00 |  | 15:58:00 | 03:55 PM | 0:00:00 |  | 4
08/15/2018 | [NAME] |  | LS 8 | 06:11 AM | 06:42:00 |  | 07:31:00 | 09:22:00 |  |  |  |  |  | 1
08/15/2018 | [NAME] |  | Grand lakes |  |  |  | 11:37:00 | 12:31:00 |  |  |  |  |  | 3
08/15/2018 | [NAME] |  | Vera |  |  |  | 14:09:00 | 16:05:00 |  | 16:43:00 | 04:57 PM |  |  | 4
08/16/2018 | [NAME] |  | Grand lakes | 06:48 AM | 06:56:00 |  | 08:52:00 | 12:30:00 |  | 16:34:00 | 01:35 PM | 0:00:00 |  | 5
08/17/2018 | [NAME] |  | East Airfield | 06:26 AM | 06:48:00 |  | 09:05:00 | 10:39:00 |  |  |  |  |  | 8
08/17/2018 | [NAME] |  | East Airfield |  |  |  | 14:44:00 | 15:07:00 |  | 15:23:00 | 03:57 PM |  |  | 8
 | [NAME]
08/13/2018 | Logan |  |  | 08:15 PM |  | 0:00:00 |  |  |  |  | 08:47 PM | 0:00:00
08/14/2018 | Logan |  | walmart | 06:52 PM | 19:13:00 |  | 12:17:00 | 05:41:00 |  | 06:53:00 | 07:26 AM |  |  | 48
08/15/2018 | Logan |  |  | 05:58 PM | 18:01:00 |  | 18:19:00 | 06:43:00 |  | 07:08:00 | 07:30 AM
08/16/2018 | Logan |  |  | 07:06 PM | 19:13:00 | 0:00:00 | 19:28:00 | 01:16:00 |  | 02:37:00 | 02:51 AM
08/17/2018 | Logan |  |  | 08:21 PM | 20:19:00 | 0:00:00 | 20:40:00 | 05:00:00 |  | 05:25:00 | 06:00 AM
 | Logan Total
08/13/2018 | [NAME] | 7 | Bridge | 06:04 AM | 07:29:00 |  | 09:44:00 | 11:40:00 |  |  |  |  |  | 4
08/13/2018 | [NAME] |  | Rolling Oaks |  |  |  | 12:36:00 | 12:56:00 |  | 13:49:00 | 02:50 PM | 0:00:00 |  | 4
08/14/2018 | [NAME] |  | CVS | 06:05 AM | 08:58:00 |  | 09:04:00 | 09:27:00 |  |  |  |  |  | 1
08/14/2018 | [NAME] |  | [NAME] |  |  |  | 18:32:00 | 19:37:00 |  |  |  |  |  | 2
08/14/2018 | [NAME] |  | Adventist |  |  |  | 09:57:00 | 10:56:00 |  |  |  |  |  | 1
08/14/2018 | [NAME] |  | Avalon |  |  |  | 12:32:00 | 17:35:00 |  | 20:05:00 | 08:24 PM |  |  | 3
08/15/2018 | [NAME] |  | Storeylake Tract | 05:58 AM | 06:46:00 |  | 08:41:00 | 09:30:00 |  |  |  |  |  | 1
08/15/2018 | [NAME] |  | Renaissance |  |  |  | 11:12:00 | 14:39:00 |  | 15:37:00 | 04:30 PM |  |  | 3
08/16/2018 | [NAME] |  | Grand lakes | 06:18 AM | 06:56:00 |  | 08:52:00 | 12:30:00 |  | 16:34:00 | 04:53 PM |  |  | 5
08/17/2018 | [NAME] |  | CVS 2 | 06:04 AM | 06:35:00 |  | 07:35:00 | 09:17:00 |  |  |  |  |  | 2
08/17/2018 | [NAME] |  | East Airfield |  |  |  | 10:10:00 | 14:29:00 |  | 15:13:00 | 04:24 PM |  |  | 5
2018-08-18 00:00:00 | [NAME] |  | [NAME] | 06:43:00 | 07:03:00 |  | 07:30:00 | 11:45:00 |  | 12:00:00 | 12:07:00 |  |  | 5
 | Patrick Total
08/16/2018 | [NAME] |  |  | 06:10 AM |  | 0:00:00 |  |  |  |  | 05:00 PM | 0:00:00
08/17/2018 | [NAME] |  | CVS 2 | 06:08 AM | 06:35:00 |  | 07:35:00 | 09:17:00 |  |  |  |  |  | 2
08/17/2018 | [NAME] |  | East Airfield |  |  |  | 10:10:00 | 14:29:00 |  | 15:13:00 | 04:04 PM |  |  | 5
2018-08-18 00:00:00 | [NAME] |  | [NAME] | 07:17:00 |  |  |  |  |  |  | 13:55:00 |  |  | 5
 | [NAME]
08/13/2018 | [NAME] |  |  | 05:24 PM | 17:34:00 |  | 12:34:00 | 06:40:00 |  | 08:36:00 | 08:40 AM
08/14/2018 | [NAME] |  | Walmart | 05:01 PM | 17:06:00 |  | 17:35:00 | 05:45:00 |  | 07:20:00 | 08:49 AM |  |  | 48
08/15/2018 | [NAME] |  |  | 03:06 PM | 15:31:00 |  | 16:00:00 | 05:10:00 |  | 07:54:00 | 08:11 AM
08/16/2018 | [NAME] |  |  | 05:01 PM | 17:09:00 |  | 17:31:00 | 07:14:00 |  | 07:18:00 | 07:38 AM
08/17/2018 | [NAME] |  |  | 04:42 PM | 16:45:00 |  | 17:19:00 | 05:15:00 |  | 05:50:00 | 06:00 AM
 | Rocco Total
08/13/2018 | [NAME] | 15 | Old Lockwood | 06:00 AM | 07:07:00 |  | 07:59:00 | 10:25:00 |  | 10:41:00 | 12:23 PM |  |  | 3
08/14/2018 | [NAME] |  | Kirkman | 05:59 AM |  | 0:00:00 | 09:00:00 | 14:00:00 |  | 14:30:00 | 02:40 PM |  |  | 7
08/15/2018 | [NAME] |  | Kirkman | 06:00 AM |  | 0:00:00 | 09:00:00 | 15:30:00 |  | 16:00:00 | 04:17 PM |  |  | 8
08/16/2018 | [NAME] |  | Kirkman | 06:01 AM |  | 0:00:00 | 09:00:00 | 16:00:00 |  | 16:30:00 | 04:45 PM |  |  | 7
08/17/2018 | [NAME] |  | Kirkman | 06:00 AM |  | 0:00:00 | 09:00:00 | 16:45:00 |  | 17:00:00 | 05:15 PM |  |  | 8
 | Ryan Total
08/12/2018 | [NAME] |  |  | 06:12 PM | 18:13:00 |  | 19:38:00 | 08:09:00 |  | 08:42:00 | 09:34 AM
08/13/2018 | [NAME] |  |  | 05:14 PM | 19:07:00 |  | 21:50:00 | 09:31:00 |  | 10:24:00 | 10:43 AM
08/14/2018 | [NAME] |  | walmart | 05:52 PM | 18:18:00 |  | 19:07:00 | 08:12:00 |  | 08:37:00 | 09:00 AM |  |  | 48
08/15/2018 | [NAME] |  |  | 05:21 PM | 17:39:00 |  | 19:42:00 | 08:17:00 |  | 08:45:00 | 09:06 AM
08/16/2018 | [NAME] |  |  | 05:31 PM | 17:49:00 |  | 18:36:00 | 08:50:00 |  | 09:19:00 | 09:36 AM
08/17/2018 | [NAME] |  |  | 05:08 PM | 17:43:00 |  | 18:33:00 | 07:51:00 |  | 09:00:00 | 09:30:00
2018-08-18 00:00:00 | [NAME] |  |  | 17:42:00 | 18:05:00 |  | 18:45:00 | 08:50:00 |  | 09:00:00 | 09:10:00
 | [NAME]
08/13/2018 | Terrance | 6 | [NAME] | 05:56 AM | 07:01:00 |  | 10:25:00 | 15:25:00 |  | 16:08:00 | 05:15 PM |  |  | 5
08/15/2018 | Terrance |  | Kirkman | 06:00 AM |  | 0:00:00 | 10:00:00 | 15:45:00 |  | 16:17:00 | 04:17 PM |  |  | 8 | 1
08/16/2018 | Terrance |  | Lake Dexter | 06:00 AM | 07:40:00 |  | 09:00:00 | 15:27:00 |  | 16:51:00 | 03:30 PM | 0:00:00 |  | 6
08/17/2018 | Terrance |  | Kirkman | 05:57 AM |  | 0:00:00 | 09:00:00 | 16:45:00 |  | 17:00:00 | 05:40 PM |  |  | 8
2018-08-18 00:00:00 | Terrance |  | Vera | 08:57:00 | 10:02:00 |  | 12:32:00 | 17:00:00 |  | 18:26:00 | 18:30:00
 | Terrance Total
08/12/2018 | [NAME] |  |  | 05:41 PM | 18:13:00 |  | 19:38:00 | 08:09:00 |  | 08:42:00 | 08:55 AM
08/13/2018 | [NAME] |  | walmart | 06:45 PM | 19:07:00 |  | 21:50:00 | 09:31:00 |  | 10:24:00 | 10:43 AM |  |  | 48
08/14/2018 | [NAME] |  |  | 05:33 PM | 18:18:00 |  | 19:07:00 | 08:12:00 |  | 08:37:00 | 09:00 AM
08/15/2018 | [NAME] |  |  | 05:21 PM | 17:39:00 |  | 19:42:00 | 08:17:00 |  | 08:45:00 | 09:07 AM
08/16/2018 | [NAME] |  |  | 05:32 PM | 17:49:00 |  | 18:36:00 | 08:50:00 |  | 09:19:00 | 09:36 AM
08/17/2018 | [NAME] |  |  | 05:09 PM | 17:43:00 |  | 18:33:00 | 07:51:00 |  | 09:00:00 | 09:29:00
2018-08-18 00:00:00 | [NAME] |  |  | 17:36:00 | 18:05:00 |  | 18:45:00 | 08:50:00 |  | 09:00:00 | 09:09:00
 | [NAME]
08/14/2018 | Willie |  | [NAME] | 06:00 AM | 06:44:00 |  | 07:30:00 | 14:29:00 |  | 15:00:00 | 03:50 PM |  |  | 5
08/15/2018 | Willie |  | Renaissance | 06:00 AM | 06:16:00 |  | 07:02:00 | 09:37:00 |  |  |  |  |  | 4
08/15/2018 | Willie |  | Lake Dexter |  |  |  | 11:33:00 | 14:45:00 |  | 17:09:00 | 04:54 PM | 0:00:00 |  | 4
08/16/2018 | Willie |  | Renaissance | 06:36 AM | 07:03:00 |  | 08:15:00 | 14:39:00 |  | 16:07:00 | 16:07:00 |  |  | 3 | 1
08/16/2018 | Willie |  | Lake Dexter |  |  |  | 09:45:00 | 14:20:00 |  | 14:50:00 | 02:49 PM | 0:00:00 |  | 4
08/17/2018 | Willie |  | Vera | 05:50 AM | 07:33:00 |  | 09:45:00 | 14:20:00 |  | 14:50:00 | 02:49 PM | 0:00:00 |  | 3
2018-08-18 00:00:00 | Willie |  | [NAME] | 07:00:00 |  |  | 08:00:00 | 12:30:00 |  | 13:45:00 | 13:55:00 |  |  | 5
 | Willie Total
08/14/2018 | Zachary |  | Kirkman | 05:48 AM | 06:30:00 |  | 09:00:00 | 16:00:00 |  | 17:30:00 | 05:36 PM |  |  | 7 | 1
08/15/2018 | Zachary |  | [NAME] | 05:53 AM | 06:27:00 |  | 09:01:00 | 15:02:00 |  | 17:03:00 | 06:09 PM |  |  | 7
08/16/2018 | Zachary |  | Lake Dexter | 05:52 AM | 07:40:00 |  | 09:00:00 | 15:27:00 |  | 16:51:00 | 04:57 PM |  |  | 6
08/17/2018 | Zachary |  | East Airfield | 05:54 AM | 06:16:00 |  | 07:20:00 | 14:58:00 |  | 15:30:00 | 04:09 PM |  |  | 8
 | Zachary Total
08/13/2018 | Nick | 8 | UCF | 05:56:00 | 06:32:00 |  | 12:11:00 | 13:12:00 |  |  |  |  |  | 1.5
08/13/2018 | Nick |  | Walgreen |  |  |  | 07:52:00 | 08:45:00 |  |  |  |  |  | 2
08/13/2018 | Nick |  | Old Lockwood |  |  |  | 09:27:00 | 11:20:00 |  | 14:37:00 | 14:47:00 |  |  | 1.5
08/14/2018 | Nick |  | OIA | 06:00:00 | 06:33:00 |  | 07:40:00 | 13:36:00 |  | 14:27:00 | 14:37:00 |  |  | 4
08/15/2018 | Nick |  | [NAME] | 06:03:00 | 06:27:00 |  | 09:01:00 | 15:02:00 |  | 17:03:00 | 17:35:00 |  |  | 7
08/16/2018 | Nick |  | Vera | 06:03:00 | 06:30:00 |  | 07:34:00 | 14:57:00 |  | 15:23:00 | 15:32:00 |  |  | 6
08/17/2018 | Nick |  | East Airfield | 06:04:00 | 06:16:00 |  | 07:20:00 | 14:58:00 |  | 15:30:00 | 16:05:00 |  |  | 8
 | Nick Total
08/13/2018 | [NAME] | 2 | [NAME] | 06:00:00 | 06:28:00 |  | 08:52:00 | 13:54:00 |  | 15:50:00 | 16:15:00 |  |  | 8
08/14/2018 | [NAME] |  | The crossing | 06:02:00 | 07:00:00 |  | 08:13:00 | 12:08:00 |  |  |  |  |  | 4
08/14/2018 | [NAME] |  | [NAME] |  |  |  | 13:49:00 | 14:29:00 |  | 15:13:00 | 16:40:00 |  |  | 5
08/15/2018 | [NAME] |  | Renaissance | 05:57:00 | 06:16:00 |  | 07:02:00 | 09:37:00 |  |  |  |  |  | 3
08/15/2018 | [NAME] |  | Lake Dexter |  |  |  | 11:33:00 | 14:45:00 |  | 17:09:00 | 17:01:00 | 0:00:00 |  | 4
08/16/2018 | [NAME] |  | Gateway | 06:00:00 | 07:03:00 |  | 08:15:00 | 14:39:00 |  | 16:07:00 | 16:00:00 | 0:00:00 |  | 3
08/17/2018 | [NAME] |  | vera | 05:58:00 | 07:33:00 |  | 09:45:00 | 14:20:00 |  | 14:50:00 | 16:23:00 | 0:00:00 |  | 4
2018-08-18 00:00:00 | [NAME] |  | [NAME] | 06:53:00 | 07:15:00 |  | 08:00:00 | 12:00:00 |  | 12:15:00 | 12:29:00 |  |  | 5
 | [NAME]