Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 05202018-05262018

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] | [NAME] |  | Family Dollar | 05:46 AM | 06:53:00 |  | 10:44:00 | 14:15:00 |  | 15:56:00 | 03:58 PM |  |  | 3
05/22/2018 | [NAME] |  | Flagler Center | 05:50 AM | 06:52:00 |  | 09:19:00 | 15:25:00 |  | 17:28:00 | 05:33 PM |  |  | 4
05/23/2018 | [NAME] |  | Self Storage | 05:51 AM | 06:58:00 |  | 07:42:00 | 08:22:00 |  |  |  |  |  | 1.5
05/23/2018 | [NAME] |  | Starflyer |  |  |  | 09:03:00 | 10:05:00 |  |  |  |  |  | 3
05/23/2018 | [NAME] |  | Vernazza |  |  |  | 11:28:00 | 13:49:00 |  | 14:39:00 | 02:45 PM |  |  | 2.5
05/24/2018 | [NAME] |  | Silver Pines | 05:44 AM | 07:12:00 |  | 08:22:00 | 10:01:00 |  |  |  |  |  | 3
05/24/2018 | [NAME] |  | Trismen |  |  |  | 11:15:00 | 12:05:00 |  | 12:20:00 | 12:21 PM |  |  | 1
05/25/2018 | [NAME] |  | 7 Eleven | 05:42 AM | 06:31:00 |  | 08:10:00 | 10:05:00 |  |  |  |  |  | 2
05/25/2018 | [NAME] |  | Ashton |  |  |  | 12:54:00 | 14:48:00 |  | 15:26:00 | 03:27 PM
 | Allen Total
[NAME] | [NAME] |  | I-295 | 07:00 AM | 08:30:00 |  | 08:46:00 | 13:33:00 |  | 14:02:00 | 02:10 PM |  |  | 8
05/22/2018 | [NAME] |  | Walmart Durbin | 06:43 AM | 07:35:00 |  | 08:31:00 | 14:39:00 |  | 14:53:00 | 03:06 PM
05/23/2018 | [NAME] |  | I-295 | 06:55 AM | 07:45:00 |  | 08:05:00 | 15:12:00 |  | 15:37:00 | 04:14 PM
05/24/2018 | [NAME] |  | Walmart Durbin | 06:30 AM | 06:34:00 |  | 07:08:00 | 14:51:00 |  | 14:59:00 | 03:07 PM
05/25/2018 | [NAME] |  | Walmart Durbin | 06:26 AM | 07:10:00 |  | 07:49:00 | 13:38:00 |  | 14:11:00 | 02:51 PM
 | [NAME]
[NAME] | [NAME] |  | Family Dollar | 05:57 AM | 06:53:00 |  | 10:44:00 | 14:15:00 |  | 15:56:00 | 05:04 PM | 0:00:00 |  | 3
05/22/2018 | [NAME] |  | Flagler Center | 06:00 AM | 06:52:00 |  | 09:19:00 | 15:25:00 |  | 17:28:00 | 06:05 PM |  |  | 4
05/23/2018 | [NAME] |  | Self Storage | 05:59 AM | 06:58:00 |  | 07:42:00 | 08:22:00 |  |  |  |  |  | 1.5
05/23/2018 | [NAME] |  | Starflyer |  |  |  | 09:03:00 | 10:05:00 |  |  |  |  |  | 3
05/23/2018 | [NAME] |  | Vernazza |  |  |  | 11:28:00 | 13:49:00 |  | 14:39:00 | 03:27 PM |  |  | 2.5
05/24/2018 | [NAME] |  | Silver Pines | 06:00 AM | 07:12:00 |  | 08:22:00 | 10:01:00 |  |  |  |  |  | 3
05/24/2018 | [NAME] |  | Trismen |  |  |  | 11:15:00 | 12:05:00 |  | 12:20:00 | 05:06 PM | 0:00:00 |  | 1
05/25/2018 | [NAME] |  | 7 Eleven | 06:04 AM | 06:31:00 |  | 08:10:00 | 10:05:00 |  |  |  |  |  | 2
05/25/2018 | [NAME] |  | Ashton |  |  |  | 12:54:00 | 14:48:00 |  | 15:26:00 | 03:27 PM
 | Benjamin Total
[NAME] | [NAME] |  | Walmart | 06:00 PM | 18:55:00 |  | 02:08:00 | 06:35:00 |  | 08:03:00 | 08:29 AM |  |  | 48
05/22/2018 | [NAME] |  | Walmart | 06:06 PM | 18:06:00 |  | 18:06:00 | 07:40:00 |  | 07:50:00 | 07:58 AM
05/23/2018 | [NAME] |  | Walmart | 06:02 PM | 18:05:00 |  | 18:12:00 | 09:32:00 |  | 21:50:00 | 10:00 PM
 | Brandon Total
[NAME] | Dwayne |  | Shop | 06:00 AM | 06:42:00 | 0:00:00 |  |  |  |  | 12:00 PM | 0:00:00 |  | 8
05/22/2018 | Dwayne |  | Flagler Center | 05:40 AM | 06:09:00 |  | 09:17:00 | 15:23:00 |  | 17:38:00 | 05:45 PM |  |  | 6
05/23/2018 | Dwayne |  | Flagler Center | 05:42 AM | 06:39:00 |  | 09:25:00 | 14:43:00 |  | 17:38:00 | 05:43 PM |  |  | 6
05/24/2018 | Dwayne |  | Trismen | 05:37 AM | 06:30:00 |  | 07:16:00 | 11:04:00 |  | 11:34:00 | 12:17 PM |  |  | 2
05/25/2018 | Dwayne |  | Neptune | 02:36 AM | 03:02:00 |  | 04:02:00 | 11:43:00 |  | 12:52:00 | 02:12 PM | 0:00:00
 | [NAME]
[NAME] | Edgar |  | Long Bay | 05:58 AM | 06:53:00 |  | 10:05:00 | 14:49:00 |  | 17:19:00 | 05:23 PM |  |  | 8
05/22/2018 | Edgar |  | Long Bay | 05:59 AM | 06:32:00 |  | 09:43:00 | 17:16:00 |  | 19:20:00 | 07:26 PM |  |  | 8
05/23/2018 | Edgar |  | [NAME] | 05:57 AM | 06:45:00 |  | 07:40:00 | 13:07:00 |  | 13:34:00 | 02:40 PM | 0:00:00 |  | 8
05/24/2018 | Edgar |  | Dollar General | 05:55 AM | 06:15:00 |  | 07:39:00 | 13:11:00 |  | 14:15:00 | 02:53 PM |  |  | 8
 | [NAME]
05/22/2018 | Efrain |  | Walmart | 07:30 PM | 17:22:00 | 0:00:00 | 21:04:00 | 01:05:00 |  | 03:12:00 | 03:15 AM |  |  | 24
05/24/2018 | Efrain |  |  | 07:40 PM | 18:17:00 | 0:00:00 | 22:31:00 | 06:16:00 |  | 11:05:00 | 11:15 AM
 | Efrain Total
[NAME] | [NAME] |  | The Strand | 05:46 AM | 07:57:00 | 0:00:00 | 08:07:00 | 08:25:00 |  | 08:31:00 | 04:24 PM | 0:00:00 |  | 1
05/22/2018 | [NAME] |  | Orlando Health | 06:01 AM | 06:52:00 |  | 09:13:00 | 10:15:00 |  | 10:58:00 | 05:00 PM | 0:00:00 |  | 8
05/23/2018 | [NAME] |  | Shop | 06:00 AM |  | 0:00:00 |  |  |  |  | 08:21 PM | 0:00:00
05/24/2018 | [NAME] |  |  | 06:23 AM |  | 0:00:00 |  |  |  |  | 07:36 PM | 0:00:00
05/25/2018 | [NAME] |  |  | 06:08 AM |  | 0:00:00 |  |  |  |  | 07:56 PM | 0:00:00
 | [NAME]
[NAME] | [NAME] |  | shop | 05:57 AM |  | 0:00:00 |  |  |  |  | 03:21 PM | 0:00:00 |  | 8
05/22/2018 | [NAME] |  | Flagler Center | 05:47 AM | 06:09:00 |  | 09:17:00 | 15:23:00 |  | 17:38:00 | 06:05 PM |  |  | 6
05/23/2018 | [NAME] |  | Flagler Center | 06:32 AM | 06:39:00 |  | 09:25:00 | 14:43:00 |  | 17:38:00 | 05:51 PM |  |  | 6
05/24/2018 | [NAME] |  | Trismen | 06:09 AM | 06:30:00 |  | 07:16:00 | 11:04:00 |  | 11:34:00 | 12:22 PM |  |  | 2
05/25/2018 | [NAME] |  | Neptune | 02:44 AM | 03:02:00 |  | 04:02:00 | 11:43:00 |  | 12:52:00 | 12:55 PM
 | [NAME]
05/22/2018 | [NAME] |  | Flagler Center | 06:03 AM | 06:52:00 |  | 09:13:00 | 15:30:00 |  | 17:43:00 | 06:00 PM |  |  | 4 | 1
05/23/2018 | [NAME] |  | [NAME] | 05:53 AM | 06:58:00 |  | 08:47:00 | 11:44:00 |  |  |  |  |  | 4
05/23/2018 | [NAME] |  | St. Cloud |  |  |  | 12:20:00 | 17:36:00 |  | 18:25:00 | 06:00 PM | 0:00:00
05/24/2018 | [NAME] |  | Dollar General | 05:58 AM | 07:58:00 |  | 09:05:00 | 16:02:00 |  | 16:33:00 | 05:04 PM
05/25/2018 | [NAME] |  | 7 Eleven | 06:00 AM | 07:15:00 |  | 08:42:00 | 12:17:00 |  | 12:25:00 | 12:30 PM
 | Kenneth Total
05/22/2018 | Logan |  | Walmart | 08:32 PM |  | 0:00:00 |  |  |  |  | 10:45 PM | 0:00:00
05/24/2018 | Logan |  |  | 05:42 PM | 18:17:00 |  | 22:31:00 | 06:16:00 |  | 11:05:00 | 11:27:00 |  |  | 36
05/25/2018 | Logan |  |  | 06:43 PM | 19:07:00 |  | 23:02:00 | 03:41:00 |  | 05:50:00 | 06:28:00
 | Logan Total
[NAME] | [NAME] |  | The Strand | 06:03 AM | 09:53:00 | 0:00:00 | 10:02:00 | 14:26:00 |  | 14:36:00 | 04:39 PM | 0:00:00 |  | 1
05/22/2018 | [NAME] |  | Orlando Health | 06:00 AM | 07:03:00 |  | 07:44:00 | 10:11:00 |  | 11:21:00 | 05:53 PM | 0:00:00 |  | 8
05/23/2018 | [NAME] |  | Shop | 06:28 AM |  | 0:00:00 |  |  |  |  | 03:45 PM | 0:00:00
05/24/2018 | [NAME] |  | Fountain | 06:00 AM | 06:53:00 |  | 09:06:00 | 09:34:00 |  | 10:40:00 | 04:20 PM | 0:00:00 |  | 1
05/25/2018 | [NAME] |  | Innovation | 06:06 AM | 06:31:00 |  | 08:18:00 | 12:17:00 |  |  |  | 0:00:00
05/25/2018 | [NAME] |  | Moss Park |  |  |  | 14:17:00 | 15:20:00 |  | 15:15:00 | 04:09 PM
 | Patrick Total
[NAME] | [NAME] |  | Walmart | 06:00 PM | 18:55:00 |  | 02:08:00 | 06:35:00 |  | 08:03:00 | 08:29 AM |  |  | 48
05/22/2018 | [NAME] |  | Walmart | 06:00 PM | 18:06:00 |  | 18:06:00 | 07:40:00 |  | 07:50:00 | 07:58 AM
05/23/2018 | [NAME] |  | Walmart | 06:01 PM | 18:05:00 |  | 18:12:00 | 09:32:00 |  |  | 08:15 AM
05/24/2018 | [NAME] |  |  | 09:25 AM |  | 0:00:00 |  |  |  | 21:50:00 | 09:59 PM
 | Rocco Total
[NAME] | [NAME] |  | Walmart | 03:51 PM |  | 0:00:00 |  |  |  |  | 05:21 PM | 0:00:00 |  | 56
05/22/2018 | [NAME] |  | Walmart | 04:35 PM | 17:22:00 |  | 21:04:00 | 01:05:00 |  | 03:12:00 | 03:23:00
05/23/2018 | [NAME] |  | Walmart | 04:34 PM | 17:54:00 |  | 21:23:00 | 07:39:00 |  | 10:08:00 | 11:24 AM
05/24/2018 | [NAME] |  |  | 05:43 PM | 18:20:00 |  | 23:29:00 | 07:07:00 |  | 12:32:00 | 12:50 PM
05/25/2018 | [NAME] |  |  | 05:29 PM | 19:07:00 |  | 23:02:00 | 03:41:00 |  | 05:50:00 | 06:12:00
 | [NAME]
[NAME] | Terrance |  | Golf Channel | 06:17 AM | 07:04:00 |  | 08:27:00 | 09:08:00 |  | 09:40:00 | 02:34 PM | 0:00:00 |  | 1
05/22/2018 | Terrance |  | Flagler Center | 05:57 AM | 06:52:00 |  | 09:13:00 | 15:30:00 |  | 17:43:00 | 05:56 PM |  |  | 4
05/23/2018 | Terrance |  | [NAME] | 06:10 AM | 06:58:00 |  | 08:47:00 | 11:44:00 |  |  |  |  |  | 4
05/23/2018 | Terrance |  | St. Cloud |  |  |  | 12:20:00 | 17:36:00 |  | 18:25:00 | 06:32 PM
05/24/2018 | Terrance |  | Dollar General | 06:17 AM | 07:58:00 |  | 09:05:00 | 16:02:00 |  | 16:33:00 | 04:50 PM
05/25/2018 | Terrance |  | 7 Eleven | 06:18 AM | 07:15:00 |  | 08:42:00 | 12:17:00 |  | 12:25:00 | 12:30 PM
 | Terrance Total
[NAME] | [NAME] |  | Walmart | 01:48 PM |  | 0:00:00 |  |  |  |  | 05:21 PM | 0:00:00 |  | 56
05/22/2018 | [NAME] |  | Walmart | 16:25:00 | 17:22:00 |  | 21:04:00 | 01:05:00 |  | 03:12:00 | 03:47 AM
05/23/2018 | [NAME] |  | Walmart | 17:02:00 | 17:54:00 |  | 21:23:00 | 07:39:00 |  | 10:08:00 | 10:08 AM
05/24/2018 | [NAME] |  |  | 18:29:00 | 18:33:00 |  | 23:29:00 | 07:07:00 |  | 11:04:00 | 11:15 AM
05/25/2018 | [NAME] |  |  | 07:01 PM | 19:07:00 |  | 23:02:00 | 03:41:00 |  | 05:50:00 | 06:11:00
 | [NAME]
05/22/2018 | [NAME] |  | Orlando Health | 06:00 AM | 07:03:00 |  | 09:11:00 | 10:11:00 |  | 11:21:00 | 03:00 PM | 0:00:00 |  | 8
05/23/2018 | [NAME] |  | Adventist Health | 06:00 AM | 06:38:00 |  | 08:20:00 | 13:04:00 |  | 13:49:00 | 02:30 PM |  |  | 1.5 | 2
05/24/2018 | [NAME] |  | Adventist Health | 08:00 AM | 08:43:00 |  | 09:53:00 | 10:51:00 |  | 11:28:00 | 11:30 AM |  |  | 1
 | Willie S Total
[NAME] | Willie |  | Long Bay | 05:59 AM | 06:53:00 |  | 10:05:00 | 14:49:00 |  | 17:19:00 | 05:21 PM |  |  | 8 | 1
05/22/2018 | Willie |  | Long Bay | 05:53 AM | 06:32:00 |  | 09:43:00 | 17:16:00 |  | 19:20:00 | 07:21 PM |  |  | 8
05/23/2018 | Willie |  | Vernazza | 06:01 AM | 06:42:00 |  | 07:38:00 | 10:16:00 |  | 11:14:00 | 11:39 AM |  |  | 5
05/25/2018 | Willie |  | Innovation | 06:01 AM | 06:29:00 |  | 08:20:00 | 15:21:00 |  | 15:50:00 | 04:17 PM
 | Willie Total
[NAME] | Zachary |  | Golf Channel | 05:58 AM | 07:04:00 |  | 08:27:00 | 09:08:00 |  | 09:40:00 | 12:02 PM | 0:00:00 |  | 1
05/22/2018 | Zachary |  | Orlando Health | 05:56 AM | 07:03:00 |  | 07:44:00 | 10:11:00 |  | 11:21:00 | 03:23 PM | 0:00:00 |  | 8
05/23/2018 | Zachary |  | Shop | 05:57 AM |  | 0:00:00 |  |  |  |  | 03:06 PM | 0:00:00
05/24/2018 | Zachary |  | Dollar General | 05:55 AM | 06:15:00 |  | 07:39:00 | 13:11:00 |  | 14:15:00 | 14:55:00 |  |  | 8
05/25/2018 | Zachary |  | Innovation | 05:56 AM | 06:06 AM | 06:31:00 |  | 08:18:00 | 12:17:00
05/25/2018 | Zachary |  | Moss Park |  |  |  |  | 14:17:00 | 15:20:00 | 15:15:00 | 03:55 PM
 | Zachary Total
[NAME] | [NAME] |  | Long Bay | 06:05:00 | 06:53:00 |  | 10:05:00 | 14:49:00 |  | 17:19:00 | 17:21:00 |  |  | 8
05/22/2018 | [NAME] |  | Long Bay | 05:57:00 | 06:32:00 |  | 09:43:00 | 17:16:00 |  | 19:20:00 | 19:24:00 |  |  | 8
05/23/2018 | [NAME] |  | Vernazza | 06:06:00 | 06:42:00 |  | 07:38:00 | 10:16:00 |  | 11:14:00 | 15:44:00 | 0:00:00 |  | 5
05/24/2018 | [NAME] |  | AFCO | 06:07:00 | 06:59:00 |  | 07:41:00 | 08:29:00 |  | 09:06:00 | 16:16:00 | 0:00:00 |  | 4
05/25/2018 | [NAME] |  | Innovation | 06:00:00 | 06:29:00 |  | 08:20:00 | 15:21:00 |  | 15:50:00 | 16:09:00
 | [NAME]
[NAME] | Nick |  | Long Bay | 05:53:00 | 06:53:00 |  | 10:05:00 | 14:49:00 |  | 17:19:00 | 17:22:00 |  |  | 8
05/22/2018 | Nick |  | Long Bay | 06:00:00 | 06:32:00 |  | 09:43:00 | 17:16:00 |  | 19:20:00 | 19:27:00 |  |  | 8
05/23/2018 | Nick |  | [NAME] | 06:02:00 | 06:45:00 |  | 07:40:00 | 13:07:00 |  | 13:34:00 | 14:41:00 | 0:00:00 |  | 8
05/24/2018 | Nick |  | Dollar General | 05:57:00 | 06:15:00 |  | 07:39:00 | 13:11:00 |  | 14:15:00 | 14:55:00 |  |  | 8
05/25/2018 | Nick |  | Innovation | 06:03:00 | 06:29:00 |  | 08:20:00 | 15:21:00 |  | 15:50:00 | 15:54:00
 | Nick Total