Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 11182018-11252018

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
11/19/2018 | [NAME] |  |  | 06:48 AM |  |  |  |  |  |  | 04:46 PM
11/20/2018 | [NAME] |  |  | 06:56 AM |  |  |  |  |  |  | 05:39 PM
11/21/2018 | [NAME] |  |  | 03:02 AM |  |  |  |  |  |  | 08:08 PM
11/18/2018 | Alonzo |  |  | 10:03 PM |  |  |  |  |  |  | 05:34 AM
11/18/2018 | [NAME] |  |  | 06:10 AM |  |  |  |  |  |  | 10:55 PM
11/19/2018 | [NAME] |  |  | 06:14 AM |  |  |  |  |  |  | 01:37 PM
11/20/2018 | [NAME] |  |  | 06:09 AM |  |  |  |  |  |  | 12:55 PM
11/21/2018 | [NAME] |  |  | 12:55 PM |  |  |  |  |  |  | 06:01 AM
11/19/2018 | [NAME] |  |  | 06:01 AM |  |  |  |  |  |  | 07:03 PM
11/20/2018 | [NAME] |  |  | 06:03 AM |  |  |  |  |  |  | 06:15 PM
11/21/2018 | [NAME] |  |  | 06:00 AM |  |  |  |  |  |  | 02:02 PM
11/23/2018 | [NAME] |  |  | 08:04 AM |  |  |  |  |  |  | 09:35 AM
11/19/2018 | [NAME] |  |  | 05:59 PM |  |  |  |  |  |  | 06:05 AM
11/20/2018 | [NAME] |  |  | 06:34 PM |  |  |  |  |  |  | 05:33 AM
11/20/2018 | [NAME] |  |  | 06:00 AM |  |  |  |  |  |  | 04:37 PM
11/21/2018 | [NAME] |  |  | 06:00 AM |  |  |  |  |  |  | 12:45 PM
11/19/2018 | Dwayne |  |  | 05:42 AM |  |  |  |  |  |  | 03:12 PM
11/20/2018 | Dwayne |  |  | 05:43 AM |  |  |  |  |  |  | 04:41 PM
11/18/2018 | Edgar |  |  | 06:12 AM |  |  |  |  |  |  | 10:54 AM
11/19/2018 | Edgar |  |  | 05:57 AM |  |  |  |  |  |  | 04:44 PM
11/20/2018 | Edgar |  |  | 05:54 AM |  |  |  |  |  |  | 04:06 PM
11/21/2018 | Edgar |  |  | 02:49 AM |  |  |  |  |  |  | 01:05 PM
11/18/2018 | Efrain |  |  | 10:03 PM |  |  |  |  |  |  | 05:34 AM
11/19/2018 | Efrain |  |  | 05:45 PM |  |  |  |  |  |  | 05:54 AM
11/20/2018 | Efrain |  |  | 05:50 PM |  |  |  |  |  |  | 05:26 AM
11/18/2018 | [NAME] |  |  | 08:38 PM |  |  |  |  |  |  | 12:11 AM
11/19/2018 | [NAME] |  |  | 08:16 AM |  |  |  |  |  |  | 05:00 PM
11/20/2018 | [NAME] |  |  | 07:55 AM |  |  |  |  |  |  | 04:51 PM
11/21/2018 | [NAME] |  |  | 12:35 PM |  |  |  |  |  |  | 04:10 PM
11/18/2018 | [NAME] |  |  | 04:35 PM |  |  |  |  |  |  | 06:42 AM
11/19/2018 | [NAME] |  |  | 05:54 PM |  |  |  |  |  |  | 06:43 AM
11/20/2018 | [NAME] |  |  | 05:37 PM |  |  |  |  |  |  | 07:45 AM
11/19/2018 | [NAME] |  |  | 06:00 AM |  |  |  |  |  |  | 05:18 PM
11/20/2018 | [NAME] |  |  | 06:11 AM |  |  |  |  |  |  | 04:10 PM
11/21/2018 | [NAME] |  |  | 06:00 AM |  |  |  |  |  |  | 12:11 PM
11/18/2018 | [NAME] |  |  | 06:04 PM |  |  |  |  |  |  | 06:39 AM
11/19/2018 | [NAME] |  |  | 06:00 PM |  |  |  |  |  |  | 06:03 AM
11/20/2018 | [NAME] |  |  | 06:34 PM |  |  |  |  |  |  | 06:33 AM
11/18/2018 | Sergio |  |  | 06:05 AM |  |  |  |  |  |  | 10:50 AM
11/19/2018 | Sergio |  |  | 05:58 AM |  |  |  |  |  |  | 01:29 PM
11/20/2018 | Sergio |  |  | 05:57 AM |  |  |  |  |  |  | 04:10 PM
11/21/2018 | Sergio |  |  | 05:58 AM |  |  |  |  |  |  | 12:29 PM
11/19/2018 | Terrance |  |  | 06:14 AM |  |  |  |  |  |  | 07:03 PM
11/20/2018 | Terrance |  |  | 06:20 AM |  |  |  |  |  |  | 06:46 PM
11/21/2018 | Terrance |  |  | 06:14 AM |  |  |  |  |  |  | 02:00 PM
11/23/2018 | Terrance |  |  | 08:17 AM |  |  |  |  |  |  | 09:35 AM
11/19/2018 | Willie |  |  | 05:59 AM |  |  |  |  |  |  | 03:10 PM
11/20/2018 | Willie |  |  | 06:03 AM |  |  |  |  |  |  | 03:14 PM
11/21/2018 | Willie |  |  | 06:06 AM |  |  |  |  |  |  | 12:12 PM
11/19/2018 | Zachary |  |  | 05:53 AM |  |  |  |  |  |  | 05:51 PM
11/20/2018 | Zachary |  |  | 06:35 AM |  |  |  |  |  |  | 05:28 PM
11/21/2018 | Zachary |  |  | 05:54 AM |  |  |  |  |  |  | 12:36 PM
11/19/2018 | Nick |  |  | 05:57:00 |  |  |  |  |  |  | 17:58:00
11/20/2018 | Nick |  |  | 05:55:00 |  |  |  |  |  |  | 17:30:00
11/21/2018 | Nick |  |  | 06:02:00 |  |  |  |  |  |  | 12:50:00
11/19/2018 | [NAME] |  |  | 05:58:00 |  |  |  |  |  |  | 16:43:00
11/20/2018 | [NAME] |  |  | 06:05:00 |  |  |  |  |  |  | 16:17:00
11/21/2018 | [NAME] |  |  | 03:19:00 |  |  |  |  |  |  | 14:13:00