Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 11112018-11172018

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 |  | [NAME] | Start Date | All day | [NAME] | Repeats | Location | Subject
11/12/2018 | [NAME] |  |  | 06:56 AM |  |  |  |  |  |  | 02:54 PM |  |  |  |  |  | [NAME] | 2018-11-13 00:00:00 | 01:30:00 | Paperwork Completed |  | Orlando | Shingle Creek Signs
11/13/2018 | [NAME] |  |  | 06:54 AM |  |  |  |  |  |  | 04:39 PM |  |  |  |  |  | [NAME] | 2018-11-12 00:00:00 | 05:00:00 | Paperwork Completed |  | Truck 10 | Houston Manor Apartments  Paint Signs and Thermo
11/14/2018 | [NAME] |  |  | 06:51 AM |  |  |  |  |  |  | 04:22 PM |  |  |  |  |  | [NAME] | 2018-11-13 00:00:00 | 01:30:00 | Paperwork Completed |  | Orlando | Shingle Creek Signs
11/15/2018 | [NAME] |  |  | 06:22 AM |  |  |  |  |  |  | 06:00 PM |  |  |  |  |  | Jesse | 2018-11-12 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 2 | Lake Nona Medical Dr Paint Temp Perm
11/16/2018 | [NAME] |  |  | 03:00 AM |  |  |  |  |  |  | 09:22 PM |  |  |  |  |  | Jesse | 2018-11-12 00:00:00 | 02:00:00 | Paperwork Completed |  | Truck 2 | Maschmeyer Paint
11/11/2018 | Alonzo |  |  | 05:49 PM |  |  |  |  |  |  | 05:23 AM |  |  |  |  |  | Jesse | 2018-11-13 00:00:00 | 8 | Paperwork Completed |  |  | Emerald Island 2017
11/12/2018 | Alonzo |  |  | 06:18 PM |  |  |  |  |  |  | 07:05 AM |  |  |  |  |  | Sergio | 2018-11-12 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 1 | Houston Manor Apartments  Thermo
11/13/2018 | Alonzo |  |  | 05:57 PM |  |  |  |  |  |  | 04:13 AM |  |  |  |  |  | Willie | 2018-11-12 00:00:00 | 08:00:00 | Actual Schedule completed |  | Truck 7 | Pilot Zoo Pkwy Thermo
11/14/2018 | Alonzo |  |  | 06:06 PM |  |  |  |  |  |  | 11:49 PM |  |  |  |  |  | Willie | 2018-11-13 00:00:00 | 8 | Actual Schedule completed |  | Truck 10 | Houston Manor Paint
11/12/2018 | [NAME] |  |  | 06:00 AM |  |  |  |  |  |  | 04:25 PM |  |  |  |  |  | [NAME] | 2018-11-14 00:00:00 | 01:00:00 | Paperwork Completed |  | [NAME] | Houston Manor Senior Apts.
11/13/2018 | [NAME] |  |  | 06:02 AM |  |  |  |  |  |  | 06:12 PM |  |  |  |  |  | [NAME] | 2018-11-12 00:00:00 | 08:00:00 | Actual Schedule completed |  | Truck 7 | Pilot Zoo Pkwy Thermo
11/14/2018 | [NAME] |  |  | 06:12 AM |  |  |  |  |  |  | 03:51 PM |  |  |  |  |  | [NAME] | 2018-11-13 00:00:00 | 8 | Actual Schedule completed |  | Truck 10 | Houston Manor Paint
11/15/2018 | [NAME] |  |  | 06:00 AM |  |  |  |  |  |  | 03:47 PM |  |  |  |  |  | [NAME] | 2018-11-14 00:00:00 | 04:00:00 | Paperwork Completed |  | Truck 7 | [NAME] 1B -1B Thermo
11/16/2018 | [NAME] |  |  | 06:10 AM |  |  |  |  |  |  | 05:15 PM |  |  |  |  |  | [NAME] | 2018-11-16 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 10, 7, 15 | Maitland Multi Family Paint
11/12/2018 | [NAME] |  |  | 06:00 AM |  |  |  |  |  |  | 03:23 PM |  |  |  |  |  | [NAME] | 2018-11-16 00:00:00 | 06:00:00 | Paperwork Completed |  | Truck 2 | Maitland Concourse Paint
11/13/2018 | [NAME] |  |  | 06:06 AM |  |  |  |  |  |  | 04:02 PM |  |  |  |  |  | [NAME] | 2018-11-12 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 1 | Houston Manor Apartments  Thermo
11/15/2018 | [NAME] |  |  | 06:01 AM |  |  |  |  |  |  | 02:35 PM |  |  |  |  |  | [NAME] | 2018-11-13 00:00:00 | 07:00:00 | Paperwork Completed |  | Truck 1 | Pilot Zoo Pkwy Thermo
11/16/2018 | [NAME] |  |  | 06:01 AM |  |  |  |  |  |  | 03:23 PM |  |  |  |  |  | [NAME] | 2018-11-14 00:00:00 | 07:00:00 | Paperwork Completed |  | Truck 6 | [NAME] Ph 2A Thermo
11/11/2018 | [NAME] |  |  | 05:59 PM |  |  |  |  |  |  | 06:20 AM |  |  |  |  |  | [NAME] | 2018-11-15 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 1, 4 | [NAME] Ph 2A Thermo
11/12/2018 | [NAME] |  |  | 06:02 PM |  |  |  |  |  |  | 07:56 AM |  |  |  |  |  | [NAME] | 2018-11-16 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 1 | Pilot Zoo Pkwy Thermo
11/13/2018 | [NAME] |  |  | 06:04 PM |  |  |  |  |  |  | 06:15 AM |  |  |  |  |  | [NAME] | 2018-11-16 00:00:00 | 02:30:00 | Paperwork Completed |  | Truck 1 | Trailmark Ph 5A & 5B Thermo
11/14/2018 | [NAME] |  |  | 06:32 PM |  |  |  |  |  |  | 11:42 PM |  |  |  |  |  | [NAME] | 2018-11-12 00:00:00 | 02:00:00 | Paperwork Completed |  | Truck 15 | Moss Park N2 & O Signs
11/15/2018 | [NAME] |  |  | 06:06 PM |  |  |  |  |  |  | 07:23 AM |  |  |  |  |  | [NAME] | 2018-11-12 00:00:00 | 02:00:00 | Paperwork Completed |  | Truck 15 | Maschmeyer Paint
11/12/2018 | [NAME] |  |  | 05:54 AM |  |  |  |  |  |  | 07:00 PM |  |  |  |  |  | [NAME] | 2018-11-15 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 6 | [NAME]
11/13/2018 | [NAME] |  |  | 05:50 AM |  |  |  |  |  |  | 06:10 PM |  |  |  |  |  | [NAME] | 2018-11-16 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 10, 7, 15 | Maitland Multi Family Paint
11/14/2018 | [NAME] |  |  | 05:49 AM |  |  |  |  |  |  | 03:53 PM |  |  |  |  |  | [NAME] | 2018-11-13 00:00:00 | 07:00:00 | Paperwork Completed |  | Truck 1 | Pilot Zoo Pkwy Thermo
11/15/2018 | [NAME] |  |  | 05:52 AM |  |  |  |  |  |  | 04:40 PM |  |  |  |  |  | [NAME] | 2018-11-14 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 10 | Maitland Multi Family Paint
11/16/2018 | [NAME] |  |  | 06:29 AM |  |  |  |  |  |  | 03:21 PM |  |  |  |  |  | [NAME] | 2018-11-15 00:00:00 | 07:00:00 | Paperwork Completed |  | Truck 10 | Maitland Multi Family Paint
11/12/2018 | Dwayne |  |  | 07:11 AM |  |  |  |  |  |  | 07:01 PM |  |  |  |  |  | [NAME] | 2018-11-16 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 10, 7, 15 | Maitland Multi Family Paint
11/14/2018 | Dwayne |  |  | 05:42 AM |  |  |  |  |  |  | 04:02 PM |  |  |  |  |  | Dwayne | 2018-11-12 00:00:00 | 05:00:00 | Paperwork Completed |  | Truck 10 | Houston Manor Apartments  Paint Signs and Thermo
11/15/2018 | Dwayne |  |  | 05:43 AM |  |  |  |  |  |  | 04:39 PM |  |  |  |  |  | Dwayne | 2018-11-14 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 10 | Maitland Multi Family Paint
11/16/2018 | Dwayne |  |  | 05:40 AM |  |  |  |  |  |  | 03:47 PM |  |  |  |  |  | Dwayne | 2018-11-15 00:00:00 | 07:00:00 | Paperwork Completed |  | Truck 10 | Maitland Multi Family Paint
11/12/2018 | Edgar |  |  | 06:01 AM |  |  |  |  |  |  | 04:05 PM |  |  |  |  |  | Dwayne | 2018-11-16 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 10, 7, 15 | Maitland Multi Family Paint
11/13/2018 | Edgar |  |  | 06:03 AM |  |  |  |  |  |  | 03:01 PM |  |  |  |  |  | Edgar | 2018-11-12 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 2 | Lake Nona Medical Dr Paint Temp Perm
11/14/2018 | Edgar |  |  | 05:58 AM |  |  |  |  |  |  | 04:26 PM |  |  |  |  |  | Edgar | 2018-11-12 00:00:00 | 02:00:00 | Paperwork Completed |  | Truck 2 | Maschmeyer Paint
11/15/2018 | Edgar |  |  | 06:01 AM |  |  |  |  |  |  | 04:42 PM |  |  |  |  |  | Edgar | 2018-11-13 00:00:00 | 8 | Paperwork Completed |  |  | Emerald Island 2017
11/16/2018 | Edgar |  |  | 05:58 AM |  |  |  |  |  |  | 03:18 PM |  |  |  |  |  | Edgar | 2018-11-13 00:00:00 | 02:00:00 | Paperwork Completed |  | Orlando | Shingle Creek Paint
11/11/2018 | Efrain |  |  | 06:35 PM |  |  |  |  |  |  | 05:42 AM |  |  |  |  |  | Edgar | 2018-11-14 00:00:00 | 02:00:00 | Actual Schedule completed |  | Truck 2 | Crown Point
11/12/2018 | Efrain |  |  | 06:00 PM |  |  |  |  |  |  | 07:29 AM |  |  |  |  |  | Edgar | 2018-11-14 00:00:00 | 02:15:00 | Paperwork Completed |  | Truck 2 | Winter Springs apartments
11/13/2018 | Efrain |  |  | 06:55 PM |  |  |  |  |  |  | 04:26 AM |  |  |  |  |  | Edgar | 2018-11-15 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 2 | Champions Vue Paint
11/14/2018 | Efrain |  |  | 06:35 PM |  |  |  |  |  |  | 11:49 PM |  |  |  |  |  | Edgar | 2018-11-15 00:00:00 | 01:00:00 | Paperwork Completed |  | Truck 2 | Action Gator Tire Windermere Paint
11/15/2018 | Efrain |  |  | 07:17 PM |  |  |  |  |  |  | 07:37 PM |  |  |  |  |  | Edgar | 2018-11-15 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 2 | Maitland Multi Family Paint
11/13/2018 | [NAME] |  |  | 06:00 PM |  |  |  |  |  |  | 05:00 AM |  |  |  |  |  | Edgar | 2018-11-16 00:00:00 | 06:00:00 | Paperwork Completed |  | Truck 2 | Maitland Concourse Paint
11/15/2018 | [NAME] |  |  | 06:03 AM |  |  |  |  |  |  | 06:53 PM |  |  |  |  |  | Edgar | 2018-11-16 00:00:00 | 06:00:00 | Actual Schedule completed |  | Truck 2 | Princeton Parc Paint
11/12/2018 | [NAME] |  |  | 05:57 AM |  |  |  |  |  |  | 07:00 AM |  |  |  |  |  | [NAME] | 2018-11-14 00:00:00 | 02:00:00 | Actual Schedule completed |  | Truck 2 | Crown Point
11/12/2018 | [NAME] |  |  | 08:00 AM |  |  |  |  |  |  | 04:05 PM |  |  |  |  |  | [NAME] | 2018-11-14 00:00:00 | 02:15:00 | Paperwork Completed |  | Truck 2 | Winter Springs apartments
11/13/2018 | [NAME] |  |  | 05:59 AM |  |  |  |  |  |  | 02:51 PM |  |  |  |  |  | [NAME] | 2018-11-15 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 2 | Champions Vue Paint
11/14/2018 | [NAME] |  |  | 05:57 AM |  |  |  |  |  |  | 02:55 PM |  |  |  |  |  | [NAME] | 2018-11-15 00:00:00 | 01:00:00 | Paperwork Completed |  | Truck 2 | Action Gator Tire Windermere Paint
11/15/2018 | [NAME] |  |  | 05:59 AM |  |  |  |  |  |  | 04:38 PM |  |  |  |  |  | [NAME] | 2018-11-15 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 2 | Maitland Multi Family Paint
11/16/2018 | [NAME] |  |  | 05:49 AM |  |  |  |  |  |  | 12:52 PM |  |  |  |  |  | [NAME] | 2018-11-16 00:00:00 | 06:00:00 | Paperwork Completed |  | Truck 2 | Maitland Concourse Paint
11/11/2018 | [NAME] |  |  | 05:35 PM |  |  |  |  |  |  | 04:47 AM |  |  |  |  |  | [NAME] | 2018-11-16 00:00:00 | 06:00:00 | Actual Schedule completed |  | Truck 2 | Princeton Parc Paint
11/12/2018 | [NAME] |  |  | 05:23 PM |  |  |  |  |  |  | 04:30 AM |  |  |  |  |  | [NAME] | 2018-11-15 00:00:00 | 8 | Paperwork Completed |  | Truck 7 | Champions Vue Signs
11/13/2018 | [NAME] |  |  | 02:14 PM |  |  |  |  |  |  | 05:12 AM |  |  |  |  |  | [NAME] | 2018-11-15 00:00:00 | 00:30:00 | Paperwork Completed |  | Truck 15 | Lake Lucerne Sign
11/14/2018 | [NAME] |  |  | 05:29 PM |  |  |  |  |  |  | 02:36 AM |  |  |  |  |  | [NAME] | 2018-11-16 00:00:00 | 02:00:00 | Paperwork Completed |  | Truck 15 | Eber Cove Signs
11/15/2018 | [NAME] |  |  | 12:59 PM |  |  |  |  |  |  | 07:07 AM |  |  |  |  |  | Sergio | 2018-11-13 00:00:00 | 07:00:00 | Paperwork Completed |  | Truck 1 | Pilot Zoo Pkwy Thermo
11/11/2018 | [NAME] |  |  | 05:50 PM |  |  |  |  |  |  | 04:48 AM |  |  |  |  |  | Sergio | 2018-11-14 00:00:00 | 07:00:00 | Paperwork Completed |  | Truck 6 | [NAME] Ph 2A Thermo
11/12/2018 | [NAME] |  |  | 06:18 PM |  |  |  |  |  |  | 04:31 AM |  |  |  |  |  | Sergio | 2018-11-15 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 1, 4 | [NAME] Ph 2A Thermo
11/13/2018 | [NAME] |  |  | 05:51 PM |  |  |  |  |  |  | 04:25 AM |  |  |  |  |  | Sergio | 2018-11-16 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 1 | Pilot Zoo Pkwy Thermo
11/15/2018 | [NAME] |  |  | 06:00 AM |  |  |  |  |  |  | 02:42 PM |  |  |  |  |  | Sergio | 2018-11-16 00:00:00 | 02:30:00 | Paperwork Completed |  | Truck 1 | Trailmark Ph 5A & 5B Thermo
11/16/2018 | [NAME] |  |  | 06:06 AM |  |  |  |  |  |  | 01:30 PM |  |  |  |  |  | TJ | 2018-11-12 00:00:00 | 05:00:00 | Paperwork Completed |  | Truck 15 | Houston Manor Apartments  Paint Signs and Thermo
11/11/2018 | [NAME] |  |  | 05:59 PM |  |  |  |  |  |  | 06:05 AM |  |  |  |  |  | TJ | 2018-11-13 00:00:00 | 01:30:00 | Paperwork Completed |  | Orlando | Shingle Creek Signs
11/12/2018 | [NAME] |  |  | 06:02 PM |  |  |  |  |  |  | 07:56 AM |  |  |  |  |  | TJ | 2018-11-13 00:00:00 | 01:30:00 | Paperwork Completed |  | Orlando | East Tract 8 Signs
11/13/2018 | [NAME] |  |  | 06:04 PM |  |  |  |  |  |  | 06:15 AM |  |  |  |  |  | TJ | 2018-11-14 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 10 | Maitland Multi Family Paint
11/14/2018 | [NAME] |  |  | 06:32 PM |  |  |  |  |  |  | 11:41 PM |  |  |  |  |  | TJ | 2018-11-15 00:00:00 | 03:00:00 | Paperwork Completed |  | Truck 6 | [NAME]
11/15/2018 | [NAME] |  |  | 06:06 PM |  |  |  |  |  |  | 07:23 AM |  |  |  |  |  | TJ | 2018-11-16 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 10, 7, 15 | Maitland Multi Family Paint
11/12/2018 | Sergio |  |  | 05:58 AM |  |  |  |  |  |  | 06:00 PM |  |  |  |  |  | Willie | 2018-11-14 00:00:00 | 04:00:00 | Paperwork Completed |  | Truck 7 | [NAME] 1B -1B Thermo
11/13/2018 | Sergio |  |  | 05:58 AM |  |  |  |  |  |  | 06:16 PM |  |  |  |  |  | Willie | 2018-11-16 00:00:00 | 08:00:00 | Paperwork Completed |  | Truck 10, 7, 15 | Maitland Multi Family Paint
11/14/2018 | Sergio |  |  | 05:58 AM |  |  |  |  |  |  | 04:10 PM
11/15/2018 | Sergio |  |  | 05:58 AM |  |  |  |  |  |  | 02:34 PM
11/16/2018 | Sergio |  |  | 05:58 AM |  |  |  |  |  |  | 05:32 PM
11/12/2018 | Terrance |  |  | 06:09 AM |  |  |  |  |  |  | 07:04 PM
11/13/2018 | Terrance |  |  | 06:09 AM |  |  |  |  |  |  | 04:24 PM
11/14/2018 | Terrance |  |  | 06:04 AM |  |  |  |  |  |  | 05:16 PM
11/15/2018 | Terrance |  |  | 06:07 AM |  |  |  |  |  |  | 05:54 PM
11/16/2018 | Terrance |  |  | 06:14 AM |  |  |  |  |  |  | 03:27 PM
11/12/2018 | Willie |  |  | 05:55 AM |  |  |  |  |  |  | 12:28 PM
11/13/2018 | Willie |  |  | 05:53 AM |  |  |  |  |  |  | 06:13 PM
11/15/2018 | Willie |  |  | 06:00 AM |  |  |  |  |  |  | 02:48 PM
11/16/2018 | Willie |  |  | 06:01 AM |  |  |  |  |  |  | 12:16 PM
11/11/2018 | Zachary |  |  | 05:50 PM |  |  |  |  |  |  | 04:44 AM
11/12/2018 | Zachary |  |  | 05:51 PM |  |  |  |  |  |  | 04:28 AM
11/13/2018 | Zachary |  |  | 05:43 PM |  |  |  |  |  |  | 05:07 AM
11/14/2018 | Zachary |  |  | 05:44 PM |  |  |  |  |  |  | 02:44 AM
11/15/2018 | Zachary |  |  | 05:46 PM |  |  |  |  |  |  | 07:01 AM
11/11/2018 | Nick |  |  | 17:00:00 |  |  |  |  |  |  | 04:46:00
11/12/2018 | Nick |  |  | 17:03:00 |  |  |  |  |  |  | 16:29:00
11/13/2018 | Nick |  |  | 17:17:00 |  |  |  |  |  |  | 17:09:00
11/14/2018 | Nick |  |  | 17:30:00 |  |  |  |  |  |  | 02:44:00
11/15/2018 | Nick |  |  | 17:10:00 |  |  |  |  |  |  | 07:05:00
11/12/2018 | [NAME] |  |  | 05:56:00 |  |  |  |  |  |  | 18:00:00
11/13/2018 | [NAME] |  |  | 06:00:00 |  |  |  |  |  |  | 18:20:00
11/14/2018 | [NAME] |  |  | 06:05:00 |  |  |  |  |  |  | 16:27:00
11/15/2018 | [NAME] |  |  | 06:02:00 |  |  |  |  |  |  | 16:34:00
11/16/2018 | [NAME] |  |  | 05:58:00 |  |  |  |  |  |  | 16:24:00