Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 10142018-10202018

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
10/15/2018 | [NAME] |  | [NAME] | 06:20 AM | 07:57:00 |  | 08:10:00 | 15:16:00 |  | 15:46:00 | 03:57 PM |  |  | 40
10/16/2018 | [NAME] |  |  | 06:58 AM | 07:45:00 |  | 08:42:00 | 11:54:00 |  | 12:33:00 | 01:24 PM
10/17/2018 | [NAME] |  |  | 06:29 AM | 07:06:00 |  | 07:38:00 | 15:24:00 |  | 15:57:00 | 04:18 PM
10/18/2018 | [NAME] |  |  | 06:29 AM | 07:12:00 |  | 08:05:00 | 15:28:00 |  | 16:03:00 | 04:21 PM
10/19/2018 | [NAME] |  |  | 06:49 AM | 07:23:00 |  | 08:23:00 | 15:18:00 |  | 15:52:00 | 04:20 PM
 | Allen Total
10/15/2018 | Alonzo |  | Walmart | 06:20 PM | 19:33:00 |  | 20:30:00 | 02:48:00 |  | 03:18:00 | 03:30 AM |  |  | 24
10/16/2018 | Alonzo |  |  | 06:04 PM | 18:38:00 |  | 19:26:00 | 02:13:00 |  | 02:34:00 | 02:40 AM |  |  |  | 1
10/17/2018 | Alonzo |  |  | 06:04 PM | 18:58:00 |  | 20:26:00 | 04:49:00 |  | 05:11:00 | 05:15 AM
 | Alonzo Total
10/15/2018 | [NAME] |  | Reunion | 06:03 AM | 06:48:00 |  | 08:04:00 | 12:24:00 |  | 13:07:00 | 03:40 PM |  |  | 5
10/16/2018 | [NAME] |  | east | 06:03 AM | 06:16:00 |  | 07:30:00 | 09:00:00 |  | 09:33:00 | 02:50 PM | 0:00:00 |  | 3
10/17/2018 | [NAME] |  | winter | 06:12 AM | 06:34:00 |  | 07:33:00 | 14:16:00 |  | 14:39:00 | 02:46 PM |  |  | 6
10/18/2018 | [NAME] |  | Bond | 06:10 AM | 06:56:00 |  | 08:49:00 | 13:20:00 |  | 14:38:00 | 03:20 PM |  |  | 3
10/19/2018 | [NAME] |  | Pilot | 06:16 AM | 06:22:00 |  | 07:42:00 | 15:26:00 |  | 16:19:00 | 04:29 PM |  |  | 5
 | Benjamin Total
10/15/2018 | [NAME] |  | Reunion | 06:02 AM | 07:36:00 |  | 09:05:00 | 11:41:00 |  |  |  |  |  | 3
10/15/2018 | [NAME] |  | [NAME] |  |  |  | 12:40:00 | 15:00:00 |  | 15:27:00 | 03:36 PM |  |  | 4
10/16/2018 | [NAME] |  | Twistee | 06:05 AM | 06:54:00 |  | 07:37:00 | 16:28:00 |  | 16:56:00 | 05:04 PM |  |  | 5
10/17/2018 | [NAME] |  | east | 06:03 AM | 06:17:00 |  | 07:21:00 | 11:45:00 |  | 12:19:00 | 01:50 PM |  |  | 5
10/18/2018 | [NAME] |  | Capistrano | 06:10 AM | 06:56:00 |  | 08:10:00 | 14:03:00 |  | 14:28:00 | 02:40 PM |  |  | 4
10/19/2018 | [NAME] |  | Pilot | 06:01 AM | 07:29:00 |  | 10:06:00 | 14:44:00 |  | 16:15:00 | 04:30 PM |  |  | 5
 | [NAME]
10/14/2018 | [NAME] |  | Walmart | 05:54 PM | 18:24:00 |  | 01:27:00 | 07:40:00 |  | 07:53:00 | 08:03 AM
10/15/2018 | [NAME] |  |  | 04:58 PM | 17:06:00 |  | 18:32:00 | 12:16:00 |  | 15:02:00 | 04:10 PM |  |  | 40
10/17/2018 | [NAME] |  |  | 06:01 PM | 19:33:00 |  | 20:43:00 | 05:55:00 |  | 06:29:00 | 06:59 AM
10/18/2018 | [NAME] |  |  | 08:00 PM | 20:46:00 |  | 22:06:00 | 06:25:00 |  | 07:01:00 | 07:19 AM
 | Brandon Total
10/15/2018 | Dwayne |  | Pilot | 05:40 AM | 06:26:00 |  | 09:22:00 | 15:04:00 |  | 17:15:00 | 05:20 PM |  |  | 7 | 1
10/17/2018 | Dwayne |  | east | 05:40 AM | 06:44:00 |  | 07:36:00 | 11:03:00 |  | 12:19:00 | 01:28 PM |  |  | 5
10/18/2018 | Dwayne |  | Capistrano | 05:43 AM | 06:16:00 |  | 07:14:00 | 09:51:00 |  |  |  |  |  | 2
10/18/2018 | Dwayne |  | Adventist |  |  |  | 10:05:00 | 12:00:00 |  | 12:22:00 | 02:46 PM | 0:00:00 |  | 3
10/19/2018 | Dwayne |  | Pilot | 05:58 AM | 06:23:00 |  | 08:57:00 | 13:17:00 |  | 15:37:00 | 03:57 PM |  |  | 5
 | [NAME]
10/15/2018 | Edgar |  | Reunion | 06:03 AM | 07:12:00 |  | 09:29:00 | 15:00:00 |  | 15:24:00 | 03:30 PM |  |  | 6
10/16/2018 | Edgar |  | east | 05:59 AM | 06:44:00 |  | 07:36:00 | 10:20:00 |  |  |  |  |  | 3
10/16/2018 | Edgar |  | sand |  |  |  | 11:26:00 | 12:59:00 |  | 13:53:00 | 04:25 PM | 0:00:00 |  | 2
10/17/2018 | Edgar |  | east | 06:00 AM | 06:17:00 |  | 07:21:00 | 11:45:00 |  | 12:19:00 | 02:51 PM |  |  | 5
10/18/2018 | Edgar |  | Bond | 06:02 AM | 06:50:00 |  | 08:41:00 | 13:20:00 |  | 14:43:00 | 03:17 PM |  |  | 5
10/19/2018 | Edgar |  | tavistock | 06:03 AM |  | 0:00:00 |  |  |  |  | 04:06 PM | 0:00:00 |  | 2
 | [NAME]
10/15/2018 | Efrain |  | Walmart | 06:06 PM | 19:33:00 |  | 20:30:00 | 02:48:00 |  | 03:18:00 | 03:23 AM |  |  | 24
10/16/2018 | Efrain |  |  | 06:24 PM | 18:38:00 |  | 19:26:00 | 02:13:00 |  | 02:34:00 | 02:37 AM
10/17/2018 | Efrain |  |  | 05:29 PM | 18:58:00 |  | 20:26:00 | 04:49:00 |  | 05:11:00 | 05:15 AM
10/18/2018 | Efrain |  |  | 06:56 PM |  | 0:00:00 |  |  |  |  | 04:12 AM | 0:00:00
 | Efrain Total
10/15/2018 | [NAME] |  | Walmart | 05:32 PM |  | 0:00:00 |  |  |  |  | 07:37 AM | 0:00:00
10/16/2018 | [NAME] |  | Walmart | 06:41 PM |  | 0:00:00 |  |  |  |  | 08:22 AM | 0:00:00
10/17/2018 | [NAME] |  | Walmart | 06:10 PM |  | 0:00:00 |  |  |  |  | 08:52 AM | 0:00:00
10/18/2018 | [NAME] |  | Walmart | 07:04 PM |  | 0:00:00 |  |  |  |  | 12:51 PM | 0:00:00 |  | 40
 | [NAME]
10/15/2018 | [NAME] |  | Reunion | 05:56 AM | 07:12:00 |  | 09:29:00 | 15:00:00 |  | 15:24:00 | 03:35 PM |  |  | 6
10/16/2018 | [NAME] |  | east | 05:55 AM | 06:44:00 |  | 07:36:00 | 10:20:00 |  |  |  |  |  | 3
10/16/2018 | [NAME] |  | sand |  |  |  | 11:26:00 | 12:59:00 |  | 13:53:00 | 10:42 AM | 0:00:00 |  | 2
10/17/2018 | [NAME] |  | maitland | 06:00 AM | 06:45:00 |  | 07:24:00 | 08:59:00 |  |  |  |  |  | 2 | 1
10/17/2018 | [NAME] |  | i-4 |  |  |  | 09:28:00 | 10:14:00 |  | 10:49:00 | 12:50 PM | 0:00:00 |  | 2
10/19/2018 | [NAME] |  | tavistock | 05:42 AM |  | 0:00:00 |  |  |  |  | 03:56 PM | 0:00:00 |  | 2
 | [NAME]
10/14/2018 | [NAME] |  | Walmart | 06:00 PM | 18:47:00 |  | 20:08:00 | 06:26:00 |  | 07:33:00 | 08:01 AM
10/15/2018 | [NAME] |  | Walmart | 05:36 PM |  |  |  |  |  |  | 10:07 AM | 0:00:00
10/16/2018 | [NAME] |  | Walmart | 05:38 PM | 19:07:00 |  | 22:16:00 | 07:30:00 |  | 09:00:00 | 08:54 AM | 0:00:00 |  | 40
10/17/2018 | [NAME] |  | Walmart | 05:59 PM | 18:19:00 |  | 20:47:00 | 05:15:00 |  | 07:03:00 | 07:34 AM
10/18/2018 | [NAME] |  |  | 06:01 PM |  | 0:00:00 |  |  |  |  | 11:06 AM | 0:00:00
 | Patrick Total
10/14/2018 | [NAME] |  | Walmart | 06:11 PM |  | 0:00:00 |  |  |  |  | 07:00 AM | 0:00:00
10/15/2018 | [NAME] |  | Walmart | 06:00 PM |  | 0:00:00 |  |  |  |  | 07:00 AM | 0:00:00
10/16/2018 | [NAME] |  | Walmart | 06:00 PM |  | 0:00:00 |  |  |  |  | 07:09 AM | 0:00:00
10/17/2018 | [NAME] |  | Walmart | 06:00 PM |  | 0:00:00 |  |  |  |  | 07:15 AM | 0:00:00
10/18/2018 | [NAME] |  |  | 06:01 PM |  | 0:00:00 |  |  |  |  | 01:13 PM | 0:00:00
 | [NAME]
10/14/2018 | [NAME] |  | Walmart | 05:54 PM | 18:24:00 |  | 01:27:00 | 07:40:00 |  | 07:53:00 | 08:03 AM |  |  | 40
10/15/2018 | [NAME] |  |  | 04:58 PM | 17:06:00 |  | 18:32:00 | 12:16:00 |  | 15:02:00 | 04:01 PM
10/17/2018 | [NAME] |  |  | 06:01 PM | 19:33:00 |  | 20:43:00 | 05:55:00 |  | 06:29:00 | 06:59 AM
10/18/2018 | [NAME] |  |  | 08:00 PM | 20:46:00 |  | 22:06:00 | 06:25:00 |  | 07:01:00 | 07:19 AM
 | Rocco Total
10/15/2018 | [NAME] |  | Reunion | 06:08 AM | 07:36:00 |  | 09:05:00 | 11:41:00 |  |  |  |  |  | 3
10/15/2018 | [NAME] |  | [NAME] |  |  |  | 12:40:00 | 15:00:00 |  | 15:27:00 | 03:48 PM |  |  | 4
10/16/2018 | [NAME] |  | sand | 06:00 AM | 06:48:00 |  | 07:35:00 | 12:58:00 |  | 13:52:00 | 02:04 PM |  |  | 2 | 2
10/19/2018 | [NAME] |  |  | 06:03 AM |  | 0:00:00 |  |  |  |  | 07:39 AM | 0:00:00
 | Ryan Total
10/15/2018 | Sergio |  | Reunion | 05:57 AM | 06:48:00 |  | 08:04:00 | 12:24:00 |  | 13:07:00 | 01:40 PM |  |  | 5
10/16/2018 | Sergio |  | east | 05:55 AM | 06:16:00 |  | 07:30:00 | 09:00:00 |  | 09:33:00 | 11:57 AM | 0:00:00 |  | 3
10/17/2018 | Sergio |  | winter | 06:00 AM | 06:34:00 |  | 07:33:00 | 14:16:00 |  | 14:39:00 | 03:00 PM |  |  | 6
10/18/2018 | Sergio |  | Bond | 05:58 AM | 06:56:00 |  | 08:49:00 | 13:20:00 |  | 14:38:00 | 03:30 PM |  |  | 3
10/19/2018 | Sergio |  | Pilot | 06:02 AM | 06:22:00 |  | 07:42:00 | 15:26:00 |  | 16:19:00 | 04:34 PM |  |  | 5
 | Sergio Total
10/15/2018 | Terrance |  | Reunion | 06:00 AM | 07:36:00 |  | 09:05:00 | 11:41:00 |  |  |  |  |  | 2
10/15/2018 | Terrance |  | [NAME] |  |  |  | 12:40:00 | 15:00:00 |  | 15:27:00 | 03:33 PM |  |  | 4
10/16/2018 | Terrance |  | Twistee | 05:58 AM | 06:54:00 |  | 07:37:00 | 16:28:00 |  | 16:56:00 | 05:16 PM |  |  | 5
10/17/2018 | Terrance |  | maitland | 05:59 AM | 06:45:00 |  | 07:24:00 | 08:59:00 |  |  |  |  |  | 2
10/17/2018 | Terrance |  | I-4 |  |  |  | 09:28:00 | 10:14:00 |  | 10:49:00 | 02:07 PM | 0:00:00 |  | 2
10/18/2018 | Terrance |  | Capistrano | 06:11 AM | 06:56:00 |  | 08:10:00 | 14:03:00 |  | 14:28:00 | 04:47 PM | 0:00:00 |  | 3
10/19/2018 | Terrance |  | Pilot | 06:13 AM | 07:29:00 |  | 10:06:00 | 14:44:00 |  | 16:15:00 | 04:31 PM |  |  | 5
 | Terrance Total
10/15/2018 | Willie |  | Pilot | 06:01 AM | 06:26:00 |  | 09:22:00 | 15:04:00 |  | 17:15:00 | 05:17 PM |  |  | 7
10/16/2018 | Willie |  | Twistee | 06:00 AM | 06:54:00 |  | 07:37:00 | 16:28:00 |  | 16:56:00 | 06:00 AM | 0:00:00 |  | 5
10/17/2018 | Willie |  | east | 06:00 AM | 06:44:00 |  | 07:36:00 | 11:03:00 |  | 12:19:00 | 01:25 PM |  |  | 5
10/18/2018 | Willie |  | bond | 06:04 AM | 06:52:00 |  | 08:48:00 | 13:20:00 |  | 14:29:00 | 02:41 PM |  |  | 4
10/19/2018 | Willie |  | Pilot | 06:00 AM | 06:23:00 |  | 08:57:00 | 13:17:00 |  | 15:37:00 | 03:58 PM |  |  | 5
 | Willie Total
10/14/2018 | Zachary |  | Walmart | 05:29 PM |  | 0:00:00 |  |  |  |  | 07:41 AM | 0:00:00 |  | 40
10/15/2018 | Zachary |  | Walmart | 05:17 PM |  | 0:00:00 |  |  |  |  | 07:12 AM | 0:00:00
10/16/2018 | Zachary |  | Walmart | 07:03 PM |  | 0:00:00 |  |  |  |  | 07:04 AM | 0:00:00
10/17/2018 | Zachary |  | Walmart | 06:33 PM |  | 0:00:00 |  |  |  |  | 07:46 AM | 0:00:00
10/18/2018 | Zachary |  |  | 06:02 PM |  | 0:00:00 |  |  |  |  | 01:03 PM | 0:00:00
 | Zachary Total
10/14/2018 | Nick |  | Walmart | 17:20:00 |  | 0:00:00 |  |  |  |  | 07:43:00 | 0:00:00 |  | 40
10/15/2018 | Nick |  | Walmart | 17:11:00 |  | 0:00:00 |  |  |  |  | 06:41:00 | 0:00:00
10/16/2018 | Nick |  | Walmart | 19:04:00 |  | 0:00:00 |  |  |  |  | 07:04:00 | 0:00:00
10/17/2018 | Nick |  | Walmart | 18:33:00 |  | 0:00:00 |  |  |  |  | 07:45:00 | 0:00:00
10/18/2018 | Nick |  |  | 18:00:00 |  | 0:00:00 |  |  |  |  | 13:11:00 | 0:00:00
 | Nick Total