Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 07082018-07142018

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
07/09/2018 | [NAME] |  | The Gatherings | 05:38 AM | 07:38:00 |  | 08:23:00 | 11:16:00 |  |  |  |  |  | 2
07/09/2018 | [NAME] |  | Alexan |  |  |  | 12:21:00 | 12:59:00 |  |  |  |  |  | 1
07/09/2018 | [NAME] |  | Hindu |  |  |  | 13:36:00 | 15:54:00 |  | 16:52:00 | 04:54 PM |  |  | 3
07/11/2018 | [NAME] |  | Gateway | 05:41 AM | 06:13:00 |  | 08:25:00 | 15:45:00 |  | 17:32:00 | 05:32 PM |  |  | 6
07/12/2018 | [NAME] |  | [NAME] | 05:35 AM | 06:25:00 |  | 07:06:00 | 08:39:00 |  |  |  |  |  | 1.5
07/12/2018 | [NAME] |  | Exchange |  |  |  | 09:15:00 | 12:03:00 |  | 12:49:00 | 01:20 PM |  |  | 3.5
07/13/2018 | [NAME] |  | SSC | 05:39 AM | 06:24:00 |  | 07:20:00 | 09:09:00 |  |  |  |  |  | 1.5
07/13/2018 | [NAME] |  | Laureate |  |  |  | 10:19:00 | 12:21:00 |  |  |  |  |  | 3
07/13/2018 | [NAME] |  | Lake |  |  |  | 13:43:00 | 18:03:00 |  | 18:57:00 | 07:20 PM |  |  | 3
 | Allen Total
07/09/2018 | [NAME] |  | [NAME] | 07:14 AM | 09:10:00 |  | 10:44:00 | 16:34:00 |  | 16:45:00 | 05:12 PM
07/10/2018 | [NAME] |  | [NAME] | 06:53 AM | 07:48:00 |  | 10:07:00 | 15:41:00 |  | 16:16:00 | 04:40 PM |  |  | 32
07/11/2018 | [NAME] |  | [NAME] | 05:05 AM | 04:35:00 | 0:00:00 | 04:44:00 | 18:02:00 |  | 18:19:00 | 06:26 PM
07/12/2018 | [NAME] |  | Gateway | 06:51 AM | 07:38:00 |  | 08:31:00 | 19:23:00 |  | 19:54:00 | 07:59 PM |  |  | 8
07/13/2018 | [NAME] |  | [NAME] | 07:10 AM | 10:58:00 |  | 11:06:00 | 15:03:00 |  | 15:17:00 | 06:35 PM
 | [NAME]
07/09/2018 | [NAME] |  | Bainbridge | 06:02 AM | 07:01:00 |  | 07:49:00 | 09:21:00 |  |  |  |  |  | 1.5
07/09/2018 | [NAME] |  | UCF |  |  |  | 10:08:00 | 13:32:00 |  | 13:52:00 | 05:49 PM | 0:00:00 |  | 4
07/10/2018 | [NAME] |  | Old Audobon | 06:07 AM | 06:52:00 |  | 07:41:00 | 17:03:00 |  | 17:48:00 | 06:01 PM |  |  | 6
07/11/2018 | [NAME] |  | Gateway | 06:00 AM | 07:13:00 |  | 09:27:00 | 18:04:00 |  | 19:49:00 | 07:56 PM |  |  | 6
07/12/2018 | [NAME] |  | Old Audobon | 06:02 AM | 06:46:00 |  | 08:24:00 | 17:13:00 |  | 17:55:00 | 05:57 PM |  |  | 7
07/13/2018 | [NAME] |  | Old Audobon | 06:00 AM | 07:00:00 |  | 08:05:00 | 15:15:00 |  | 15:48:00 | 04:10 PM |  |  | 3
 | Benjamin Total
07/08/2018 | [NAME] |  | Walmart | 05:53 PM | 18:19:00 |  | 19:41:00 | 06:43:00 |  | 08:17:00 | 08:50 AM
07/09/2018 | [NAME] |  | Walmart | 06:08 PM | 18:28:00 |  | 20:54:00 | 06:01:00 |  | 07:07:00 | 07:12 AM |  |  | 56
07/10/2018 | [NAME] |  | Walmart | 05:35 PM | 18:16:00 |  | 20:08:00 | 07:59:00 |  | 09:25:00 | 09:32 AM
07/11/2018 | [NAME] |  | Walmart | 05:26 PM | 18:13:00 |  | 21:01:00 | 07:25:00 |  | 08:29:00 | 08:33 AM
07/12/2018 | [NAME] |  | Walmart | 05:52 PM | 18:56:00 |  | 19:41:00 | 08:00:00 |  | 08:38:00 | 08:45 AM
07/13/2018 | [NAME] |  | Walmart | 07:01 PM | 20:03:00 |  | 21:01:00 | 09:30:00 |  | 10:06:00 | 10:12:00
 | [NAME]
07/09/2018 | [NAME] |  | Walmart | 06:04 PM | 18:40:00 |  | 22:28:00 | 05:17:00 |  | 08:20:00 | 08:38 AM
07/10/2018 | [NAME] |  | Walmart | 06:19 PM | 18:29:00 |  | 23:01:00 | 04:24:00 |  | 07:16:00 | 07:59 AM |  |  | 56
07/11/2018 | [NAME] |  | Walmart | 06:06 PM | 19:11:00 |  | 22:32:00 | 05:07:00 |  | 08:07:00 | 08:30 AM
07/12/2018 | [NAME] |  | Walmart | 06:07 PM | 18:49:00 |  | 21:58:00 | 02:54:00 |  | 04:54:00 | 04:58 AM
 | Brandon Total
07/10/2018 | Dwayne |  | Fl Hsptl | 05:44 AM | 06:35:00 |  | 08:01:00 | 09:57:00 |  |  |  |  |  | 1.5
07/10/2018 | Dwayne |  | [NAME] |  |  |  | 11:26:00 | 15:21:00 |  | 16:08:00 | 04:25 PM |  |  | 4
07/11/2018 | Dwayne |  | Gateway | 05:43 AM | 06:13:00 |  | 08:25:00 | 15:45:00 |  | 17:32:00 | 05:33 PM |  |  | 6 | 1
07/12/2018 | Dwayne |  | [NAME] | 05:45 AM | 06:25:00 |  | 07:06:00 | 08:39:00 |  |  |  |  |  | 1.5
07/12/2018 | Dwayne |  | Exchange |  |  |  | 09:15:00 | 12:03:00 |  | 12:49:00 | 02:26 PM | 0:00:00 |  | 3.5
07/13/2018 | Dwayne |  | SSC | 05:46 AM | 06:24:00 |  | 07:20:00 | 09:09:00 |  |  |  |  |  | 1.5
07/13/2018 | Dwayne |  | Laureate |  |  |  | 10:19:00 | 12:21:00 |  |  |  |  |  | 3
07/13/2018 | Dwayne |  | Lake |  |  |  | 13:43:00 | 18:03:00 |  | 18:57:00 | 07:02 PM |  |  | 3
 | [NAME]
07/09/2018 | Edgar |  | The Greater | 06:03 AM | 06:18:00 |  | 10:24:00 | 11:08:00 |  |  |  |  |  | 3
07/09/2018 | Edgar |  | Old Audobon |  |  |  | 11:34:00 | 15:18:00 |  | 16:08:00 | 04:12 PM |  |  | 4
07/11/2018 | Edgar |  | Gateway | 05:59 AM | 06:13:00 |  | 08:25:00 | 15:45:00 |  | 17:32:00 | 05:49 PM |  |  | 6 | 1
07/12/2018 | Edgar |  | Exchange | 06:00 AM | 06:23:00 |  | 07:25:00 | 12:09:00 |  | 12:51:00 | 02:10 PM | 0:00:00 |  | 6
07/13/2018 | Edgar |  | [NAME] | 05:55 AM | 06:32:00 |  | 08:01:00 | 09:02:00 |  |  |  |  |  | 3
07/13/2018 | Edgar |  | Lake |  |  |  | 10:22:00 | 18:18:00 |  | 19:09:00 | 07:14 PM |  |  | 3
 | [NAME]
07/08/2018 | Efrain |  | Walmart | 07:51 PM | 18:40:00 | 0:00:00 | 22:19:00 | 07:05:00 |  | 09:31:00 | 09:02 AM | 0:00:00
07/09/2018 | Efrain |  | Walmart | 07:46 PM | 18:40:00 | 0:00:00 | 22:28:00 | 05:17:00 |  | 08:20:00 | 07:41 AM | 0:00:00 |  | 56
07/10/2018 | Efrain |  | Walmart | 07:32 PM | 18:29:00 | 0:00:00 | 23:01:00 | 04:24:00 |  | 07:16:00 | 06:42 AM | 0:00:00
07/11/2018 | Efrain |  | Walmart | 07:57 PM | 19:11:00 | 0:00:00 | 22:32:00 | 05:07:00 |  | 08:07:00 | 07:47 AM | 0:00:00
 | Efrain Total
07/09/2018 | [NAME] |  | The Gatherings | 06:00 AM | 07:38:00 |  | 08:23:00 | 11:16:00 |  |  |  |  |  | 2
07/09/2018 | [NAME] |  | Alexan |  |  |  | 12:21:00 | 12:59:00 |  |  |  |  |  | 1
07/09/2018 | [NAME] |  | Hindu |  |  |  | 13:36:00 | 15:54:00 |  | 16:52:00 | 05:00 PM |  |  | 3
07/10/2018 | [NAME] |  | Moody | 06:02 AM |  | 0:00:00 |  |  | 0:00:00 |  | 05:00 PM | 0:00:00 |  | 8
07/12/2018 | [NAME] |  | Gateway | 06:48 AM | 06:38:00 | 0:00:00 | 08:35:00 | 19:18:00 |  | 19:59:00 | 08:04 PM |  |  | 8
07/13/2018 | [NAME] |  | Gateway | 07:03 AM | 07:39:00 |  | 08:44:00 | 17:28:00 |  | 18:18:00 | 06:42 PM |  |  | 8
 | [NAME]
07/09/2018 | [NAME] |  | Bainbridge | 06:06 AM | 07:01:00 |  | 07:49:00 | 09:21:00 |  |  |  |  |  | 1.5
07/09/2018 | [NAME] |  | UCF |  |  |  | 10:08:00 | 13:32:00 |  | 13:52:00 | 04:11 PM | 0:00:00 |  | 4
07/10/2018 | [NAME] |  | Old Audobon | 06:24 AM | 06:52:00 |  | 07:41:00 | 17:03:00 |  | 17:48:00 | 06:01 PM |  |  | 6
07/11/2018 | [NAME] |  | Gateway | 05:40 AM | 07:13:00 |  | 09:27:00 | 18:04:00 |  | 19:49:00 | 07:56 PM |  |  | 6
07/12/2018 | [NAME] |  | Old Audobon | 06:24 AM | 06:46:00 |  | 08:24:00 | 17:13:00 |  | 17:55:00 | 06:03 PM |  |  | 7
07/13/2018 | [NAME] |  | Old Audobon | 05:43 AM | 07:00:00 |  | 08:05:00 | 15:15:00 |  | 15:48:00 | 04:08 PM |  |  | 3
 | [NAME]
07/08/2018 | Logan |  | Walmart | 06:05 PM | 18:40:00 |  | 22:19:00 | 07:05:00 |  | 09:31:00 | 09:45 AM
07/09/2018 | Logan |  | Walmart | 06:03 PM | 18:40:00 |  | 22:28:00 | 05:17:00 |  | 08:20:00 | 08:38 AM |  |  | 56
07/10/2018 | Logan |  | Walmart | 06:18 PM | 18:29:00 |  | 23:01:00 | 04:24:00 |  | 07:16:00 | 07:59 AM
07/12/2018 | Logan |  | Walmart | 06:05 PM | 18:49:00 |  | 21:58:00 | 02:54:00 |  | 04:54:00 | 05:20 AM
 | Logan Total
07/09/2018 | [NAME] |  | West Livingston | 05:58 AM | 06:58:00 |  | 08:21:00 | 08:53:00 |  |  |  |  |  | 3
07/09/2018 | [NAME] |  | Hindu |  |  |  | 09:45:00 | 15:54:00 |  | 16:40:00 | 04:58 PM |  |  | 3
07/10/2018 | [NAME] |  | OC Library | 06:05 AM | 06:53:00 |  | 09:04:00 | 09:34:00 |  |  |  |  |  | 1
07/10/2018 | [NAME] |  | Hindu |  |  |  | 10:23:00 | 13:47:00 |  |  |  |  |  | 3
07/10/2018 | [NAME] |  | Old Audobon |  |  |  | 14:58:00 | 16:10:00 |  | 16:36:00 | 04:50 PM |  |  | 2
07/11/2018 | [NAME] |  | Gateway | 07:03 AM | 07:13:00 |  | 09:27:00 | 18:04:00 |  | 19:49:00 | 07:56 PM |  |  | 6
07/12/2018 | [NAME] |  | Exchange | 06:05 AM | 07:27:00 |  | 09:06:00 | 12:09:00 |  |  |  |  |  | 1.5
07/12/2018 | [NAME] |  | Innovation |  |  |  | 13:06:00 | 13:50:00 |  | 14:22:00 | 04:06 PM | 0:00:00 |  | 2
07/13/2018 | [NAME] |  | [NAME] | 06:04 AM | 07:15:00 |  | 10:16:00 | 12:21:00 |  | 12:56:00 | 03:38 PM | 0:00:00 |  | 3
 | Patrick Total
07/08/2018 | [NAME] |  | Walmart | 06:06 PM | 18:40:00 |  | 22:19:00 | 07:05:00 |  | 09:31:00 | 09:45 AM |  |  | 56
07/09/2018 | [NAME] |  | Walmart | 06:04 PM | 18:40:00 |  | 22:28:00 | 05:17:00 |  | 08:20:00 | 08:38 AM
07/10/2018 | [NAME] |  | Walmart | 06:19 PM | 18:29:00 |  | 23:01:00 | 04:24:00 |  | 07:16:00 | 07:59 AM
07/11/2018 | [NAME] |  | Walmart | 06:06 PM | 19:11:00 |  | 22:32:00 | 05:07:00 |  | 08:07:00 | 08:42 AM
07/12/2018 | [NAME] |  | Walmart | 06:08 PM | 18:49:00 |  | 21:58:00 | 02:54:00 |  | 04:54:00 | 04:58 AM
 | Rocco Total
07/09/2018 | [NAME] |  | [NAME] | 06:01 AM | 07:14:00 |  | 07:55:00 | 14:00:00 |  |  |  |  |  | 2
07/09/2018 | [NAME] |  | Old Audobon |  |  |  | 15:15:00 | 16:04:00 |  | 16:38:00 | 04:47 PM |  |  | 4
07/10/2018 | [NAME] |  | Fl Hsptl | 06:00 AM | 05:44 AM | 0:00:00 | 08:01:00 | 09:57:00 |  |  |  |  |  | 1.5
07/10/2018 | [NAME] |  | The Greater |  |  |  | 11:26:00 | 15:21:00 |  | 15:55:00 | 16:08:00 |  |  | 4
07/11/2018 | [NAME] |  | Gateway | 06:02 AM | 07:13:00 |  | 09:27:00 | 18:04:00 |  | 19:49:00 | 07:57 PM |  |  | 6 | 1
07/12/2018 | [NAME] |  | UNF | 06:01 AM |  | 0:00:00 |  |  | 0:00:00 |  | 09:29 PM | 0:00:00 |  | 4
 | Ryan Total
07/08/2018 | [NAME] |  | Walmart | 05:53 PM | 18:19:00 |  | 19:41:00 | 06:43:00 |  | 08:17:00 | 08:50 AM |  |  | 56
07/09/2018 | [NAME] |  | Walmart | 06:08 PM | 18:28:00 |  | 20:54:00 | 06:01:00 |  | 07:07:00 | 07:12 AM
07/10/2018 | [NAME] |  | Walmart | 05:35 PM | 18:16:00 |  | 20:08:00 | 07:59:00 |  | 09:25:00 | 09:32 AM
07/11/2018 | [NAME] |  | Walmart | 05:26 PM | 18:13:00 |  | 21:01:00 | 07:25:00 |  | 08:29:00 | 08:33 AM
07/12/2018 | [NAME] |  | Walmart | 05:52 PM | 18:56:00 |  | 19:41:00 | 08:00:00 |  | 08:38:00 | 08:44 AM
07/13/2018 | [NAME] |  | Walmart | 07:01 PM | 20:03:00 |  | 21:01:00 | 09:30:00 |  | 10:06:00 | 10:12:00
 | [NAME]
07/09/2018 | Terrance |  | [NAME] | 06:25 AM | 07:14:00 |  | 07:55:00 | 14:00:00 |  |  |  |  |  | 2
07/09/2018 | Terrance |  | Old Audobon |  |  |  | 15:15:00 | 16:04:00 |  | 16:38:00 | 04:53 PM |  |  | 4
07/10/2018 | Terrance |  | OC Library | 06:00 AM | 06:53:00 |  | 09:04:00 | 09:34:00 |  |  |  |  |  | 1
07/10/2018 | Terrance |  | Hindu |  |  |  | 10:23:00 | 13:47:00 |  |  |  |  |  | 3
07/12/2018 | Terrance |  | Exchange | 06:05 AM |  |  | 14:58:00 | 16:10:00 |  | 16:36:00 | 04:51 PM |  |  | 2 | 1
07/12/2018 | Terrance |  | Innovation |  |  |  |  |  |  |  |  |  |  | 2
07/13/2018 | Terrance |  | Exchange | 06:26 AM |  | 0:00:00 |  |  |  |  |  |  |  | 1.5
07/13/2018 | Terrance |  | Innovation |  |  |  |  |  |  |  | 05:00 PM | 0:00:00 |  | 2
 | Terrance Total
07/08/2018 | [NAME] |  | Walmart | 05:57 PM | 18:19:00 |  | 19:41:00 | 06:43:00 |  | 08:17:00 | 08:37 AM
07/09/2018 | [NAME] |  | Walmart | 06:10 PM | 18:28:00 |  | 20:54:00 | 06:01:00 |  | 07:07:00 | 07:26 AM |  |  | 56
07/10/2018 | [NAME] |  | Walmart | 05:52 PM | 18:16:00 |  | 20:08:00 | 07:59:00 |  | 09:25:00 | 09:35 AM
07/11/2018 | [NAME] |  | Walmart | 06:01 PM | 18:13:00 |  | 21:01:00 | 07:25:00 |  | 08:29:00 | 09:00 AM
07/12/2018 | [NAME] |  | Walmart | 05:35 PM | 18:56:00 |  | 19:41:00 | 08:00:00 |  | 08:38:00 | 09:04 AM
07/13/2018 | [NAME] |  | Walmart | 06:25 PM | 20:03:00 |  | 21:01:00 | 09:30:00 |  | 10:06:00 | 10:14:00
 | [NAME]
07/12/2018 | [NAME] |  | old Lockwood | 06:30 AM |  | 0:00:00 |  |  |  |  | 06:30 PM | 0:00:00 |  | 3
07/13/2018 | [NAME] |  | Exchange | 06:00 AM |  | 0:00:00 |  |  |  |  | 03:30 PM | 0:00:00 |  | 1 | 3
 | Willie S Total
07/09/2018 | Willie |  | the Strand | 05:57 AM | 07:06:00 |  | 08:08:00 | 09:36:00 |  |  |  |  |  | 1.5
07/09/2018 | Willie |  | UCF |  |  |  | 10:03:00 | 13:32:00 |  | 13:52:00 | 01:59 PM |  |  | 4
07/10/2018 | Willie |  | Crescent | 05:57 AM | 07:50:00 |  | 09:39:00 | 12:08:00 |  | 13:43:00 | 01:44 PM |  |  | 4
07/11/2018 | Willie |  | Dover | 05:59 AM | 09:09:00 |  | 13:43:00 | 15:32:00 |  | 16:06:00 | 04:06 PM |  |  | 1.5
07/11/2018 | Willie |  | Econ |  |  |  | 10:13:00 | 12:13:00 |  |  |  |  |  | 3
 | Willie Total
07/09/2018 | Zachary |  | The Greater | 05:53 AM | 06:18:00 |  | 10:24:00 | 11:08:00 |  |  |  |  |  | 3
07/09/2018 | Zachary |  | Old Audobon |  |  |  | 11:34:00 | 15:18:00 |  | 16:08:00 | 04:12 PM |  |  | 4
07/10/2018 | Zachary |  | The Greater | 05:56 AM | 06:05:00 |  | 06:53:00 | 13:39:00 |  | 13:59:00 | 02:11 PM |  |  | 6
07/11/2018 | Zachary |  | Gateway | 05:48 AM | 06:13:00 |  | 08:25:00 | 15:45:00 |  | 17:32:00 | 05:38 PM |  |  | 6
07/12/2018 | Zachary |  | dollar | 05:50 AM | 06:23:00 |  | 07:25:00 | 12:09:00 |  | 12:51:00 | 14:07:00 | 0:00:00 |  | 3
07/13/2018 | Zachary |  | [NAME] | 05:54 AM | 06:32:00 |  | 08:01:00 | 09:02:00 |  |  |  |  |  | 3
07/13/2018 | Zachary |  | Lake |  |  |  | 10:22:00 | 18:18:00 |  | 19:09:00 | 03:14 PM | 0:00:00 |  | 3
 | Zachary Total
07/09/2018 | Nick |  | The Greater | 05:59:00 | 06:18:00 |  | 10:24:00 | 11:08:00 |  |  |  |  |  | 3
07/09/2018 | Nick |  | Old Audobon |  |  |  | 11:34:00 | 15:18:00 |  | 16:08:00 | 16:14:00 |  |  | 4
07/10/2018 | Nick |  | The Greater | 06:04:00 | 06:05:00 |  | 06:53:00 | 13:39:00 |  | 13:59:00 | 14:17:00 |  |  | 6
07/12/2018 | Nick |  | Exchange | 05:57:00 | 06:23:00 |  | 07:25:00 | 12:09:00 |  | 12:51:00 | 14:07:00 | 0:00:00
07/13/2018 | Nick |  | [NAME] | 05:56:00 | 06:32:00 |  | 08:01:00 | 09:02:00
07/13/2018 | Nick |  | Lake |  |  |  | 10:22:00 | 18:18:00 |  | 19:09:00 | 19:25:00
 | Nick Total
07/09/2018 | [NAME] |  | the Strand | 05:55:00 | 07:06:00 |  | 08:08:00 | 09:36:00 |  |  |  |  |  | 1.5
07/09/2018 | [NAME] |  | UCF |  |  |  | 10:03:00 | 13:32:00 |  | 13:52:00 | 14:28:00 |  |  | 4
07/10/2018 | [NAME] |  | Crescent | 05:57:00 | 07:50:00 |  | 09:39:00 | 12:08:00 |  | 13:43:00 | 16:30:00 | 0:00:00 |  | 4
07/11/2018 | [NAME] |  | Dover | 08:58:00 | 09:09:00 |  | 13:43:00 | 15:32:00 |  | 16:06:00 | 16:15:00 |  |  | 1.5
07/11/2018 | [NAME] |  | Econ |  |  |  | 10:13:00 | 12:13:00 |  |  |  |  |  | 7
07/12/2018 | [NAME] |  | Dollar | 05:59:00 | 07:22:00 |  | 08:44:00 | 14:07:00 |  | 15:03:00 | 16:29:00 | 0:00:00 |  | 3
07/13/2018 | [NAME] |  | Lake |  |  |  | 11:39:00 | 13:00:00 |  |  |  |  |  | 4
07/13/2018 | [NAME] |  | Dollar | 06:01:00 | 06:44:00 |  | 07:52:00 | 11:13:00 |  | 13:40:00 | 15:43:00 | 0:00:00 |  | 2.5
 | [NAME]