Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 020518-02102018

Date | Crew | 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 | Number of visits (Matt & Bruce)
 | [NAME] |  | 05:58:00 |  |  |  |  |  |  | 11:48:00
 | [NAME] |  | 07:11:00 | 08:30:00 |  | 08:44:00 | 17:39:00 |  | 17:52:00 | 18:17:00
 | [NAME] |  | 05:51:00 |  |  |  |  |  |  | 14:48:00 | 00:00:00
 | [NAME] |  | 05:49:00 | 06:37:00 |  | 09:13:00 | 15:19:00 |  | 18:06:00 | 18:08:00
2018-02-07 00:00:00 | [NAME] | Costco | 07:20:00 | 08:07:00 |  | 08:24:00 | 15:33:00 |  | 15:44:00 | 16:18:00
 | [NAME] |  | 05:54:00 | 06:40:00 |  | 08:01:00 | 09:31:00
 | [NAME] |  |  |  |  | 10:11:00 | 16:01:00 |  | 16:30:00 | 17:19:00
 | [NAME] |  | 05:44:00 | 07:05:00 |  | 09:13:00 | 14:46:00 |  | 15:15:00 | 15:13:00
 | Allen Total
2018-02-05 00:00:00 | [NAME] | Costco | 15:01:00 | 15:33:00 |  | 15:33:00 | 20:17:00 |  | 20:29:00 | 21:02:00
2018-02-08 00:00:00 | [NAME] | I-295 | 07:31:00 | 08:57:00 |  | 09:24:00 | 15:45:00 |  | 16:05:00 | 16:08:00
2018-02-09 00:00:00 | [NAME] | I-295 | 07:28:00 | 08:35:00 |  | 09:18:00 | 13:56:00 |  | 14:24:00 | 14:56:00
 | [NAME]
2018-02-05 00:00:00 | [NAME] | FDOT Tracter 17-079685 | 05:58:00 | 07:24:00 |  | 08:54:00 | 11:07:00 |  | 12:22:00 | 16:08:00 |  | x
2018-02-06 00:00:00 | [NAME] | Park Ave | 06:00:00 | 06:58:00 |  | 08:39:00 | 15:16:00 |  | 16:31:00 | 16:54:00
2018-02-07 00:00:00 | [NAME] | East 6th Street | 05:52:00 | 06:14:00 |  | 10:13:00 | 11:17:00 |  |  |  |  | x
2018-02-07 00:00:00 | [NAME] | Jehovah Church |  |  |  | 12:19:00 | 15:42:00 |  | 16:22:00 | 16:43:00
2018-02-08 00:00:00 | [NAME] | Wildmere Ave | 06:03:00 | 06:58:00 |  | 07:58:00 | 15:13:00 |  | 15:39:00 | 16:24:00
2018-02-09 00:00:00 | [NAME] | Park Ave | 06:01:00 | 07:05:00 |  | 09:13:00 | 14:46:00 |  | 15:15:00 | 15:58:00
 | [NAME]
 | [NAME] |  | 05:53:00 | 06:35:00 |  | 09:57:00 | 12:11:00 |  | 14:34:00 | 14:39:00
 | [NAME] |  | 06:28:00 |  |  |  |  |  |  | 15:45:00 | 00:00:00
2018-02-07 00:00:00 | [NAME] | Shop | 06:03:00 |  |  |  |  |  |  | 14:58:00 | 00:00:00
 | [NAME] | out
2018-02-08 00:00:00 | [NAME] | Shop | 05:55:00
 | Anthony Total
2018-02-05 00:00:00 | [NAME] | Legacy Callawalk | 06:00:00 | 07:23:00 |  | 08:28:00 | 13:52:00 |  | 15:39:00 | 16:00:00
2018-02-06 00:00:00 | [NAME] | Costco | 06:02:00 | 06:38:00 |  | 09:23:00 | 17:59:00 |  | 20:05:00 | 20:15:00
2018-02-07 00:00:00 | [NAME] | Costco | 06:07:00 | 06:37:00 |  | 09:13:00 | 15:19:00 |  | 18:06:00 | 18:14:00
 | [NAME] |  | 06:00:00 | 06:40:00 |  | 08:01:00 | 09:31:00 |  |  | 17:31:00 | 00:00:00
 | [NAME] |  |  |  |  | 10:11:00 | 16:01:00 |  | 16:30:00 | 17:31:00
 | [NAME] |  | 06:00:00 | 07:05:00 |  | 09:13:00 | 14:46:00 |  | 15:15:00 | 15:31:00
 | [NAME]
 | [NAME] |  | 18:04:00 | 19:56:00 |  | 21:48:00 | 07:53:00 |  | 07:53:00 | 08:10:00
 | [NAME] |  | 19:26:00 | 19:36:00 |  | 20:02:00 | 21:10:00 |  | 21:20:00 | 21:36:00
 | [NAME] |  | 01:13:00 | 01:13:00 |  | 01:24:00 | 02:06:00 |  | 07:49:00 | 08:14:00
 | Brandon Total
2018-02-05 00:00:00 | Dwayne | [NAME] | 06:00:00 | 06:21:00 |  | 07:14:00 | 10:52:00 |  | 14:17:00 | 14:49:00
2018-02-06 00:00:00 | Dwayne | Universal 942 | 05:50:00 | 06:14:00 |  | 07:39:00 | 10:56:00
2018-02-06 00:00:00 | Dwayne | Park Ave |  |  |  | 11:40:00 | 14:11:00 |  | 14:50:00 | 14:56:00
2018-02-07 00:00:00 | Dwayne | [NAME] | 05:50:00 | 06:17:00 |  | 07:37:00 | 15:11:00 |  | 15:45:00 | 16:06:00
2018-02-08 00:00:00 | Dwayne | [NAME] | 05:49:00 | 06:34:00 |  | 07:57:00 | 09:31:00
 | Dwayne | [NAME] |  |  |  | 09:55:00 | 16:05:00 |  | 16:37:00 | 16:51:00
2018-02-09 00:00:00 | Dwayne | [NAME] | 06:30:00 | 07:13:00 |  | 09:00:00 | 14:57:00 |  | 15:24:00 | 15:27:00
 | [NAME]
 | Edgar |  | 11:55:00 | 13:11:00 |  | 15:49:00 | 20:23:00 |  | 22:40:00 | 22:43:00
 | Edgar |  | 06:06:00 | 06:43:00 |  | 08:33:00 | 16:21:00 |  | 18:28:00 | 18:33:00
2018-02-07 00:00:00 | Edgar | Costco | 06:01:00 | 06:51:00 |  | 08:34:00 | 15:30:00 |  | 17:38:00 | 17:44:00
 | Edgar |  | 05:58:00 | 06:36:00 |  | 07:52:00 | 12:44:00 |  | 13:12:00 | 15:38:00
 | Edgar |  | 06:00:00 | 07:13:00 |  | 09:00:00 | 14:57:00 |  | 15:24:00 | 15:30:00
 | [NAME]
 | Efrain |  | 05:50:00 | 06:41:00 |  | 07:56:00 | 14:49:00 |  | 15:27:00 | 15:27:00
 | Efrain |  | 05:42:00 | 06:39:00 |  | 07:17:00 | 08:49:00
 | Efrain |  |  |  |  | 09:38:00 | 16:21:00 |  | 16:50:00 | 19:07:00
 | Efrain |  | 05:49:00 | 06:33:00 |  | 09:22:00 | 16:04:00 |  | 18:11:00 | 18:22:00
 | Efrain |  | 05:43:00 | 09:13:00 |  | 10:01:00 | 10:53:00 |  | 11:19:00 | 12:08:00
 | Efrain Total
2018-02-07 00:00:00 | [NAME] | Costco | 07:38:00 | 08:02:00 |  | 08:14:00 | 15:21:00 |  | 15:32:00 | 19:20:00
2018-02-08 00:00:00 | [NAME] |  | 08:14:00 | 08:14:00 |  |  |  |  |  | 12:34:00 | 00:00:00
 | [NAME] |  | 08:36:00 | 08:38:00 |  | 08:51:00 | 18:36:00 |  | 18:52:00 | 20:37:00
 | [NAME]
 | Lindsey |  | 05:50:00 |  |  |  |  |  |  | 14:30:00
 | Lindsey |  | 05:50:00 |  |  |  |  |  |  | 14:33:00 | 00:00:00 |  |  | [NAME] 1.42 hours
 | Lindsey |  | 05:50:00 | 06:17:00 |  | 07:37:00 | 15:11:00 |  | 15:45:00 | 16:31:00
 | Lindsey |  | 05:50:00 | 06:34:00 |  | 07:57:00 | 09:31:00
 | Lindsey |  |  |  |  | 09:55:00 | 16:05:00 |  | 16:37:00 | 16:50:00
 | Lindsey |  | 05:50:00 | 07:13:00 |  | 09:00:00 | 14:57:00 |  | 15:24:00 | 15:33:00
 | Lindsey Total
2018-02-05 00:00:00 | Nick | Costco | 12:03:00 | 13:11:00 |  | 15:49:00 | 20:23:00 |  | 22:40:00 | 22:43:00
2018-02-06 00:00:00 | Nick | Costco | 06:03:00 | 06:43:00 |  | 08:33:00 | 16:21:00 |  | 18:28:00 | 18:32:00
2018-02-08 00:00:00 | Nick | [NAME] | 05:53:00 | 06:36:00 |  | 07:52:00 | 12:44:00 |  | 13:12:00 | 16:24:00
 | Nick Total
2018-02-05 00:00:00 | [NAME] | Shop | 06:09:00 |  |  |  |  |  |  | 15:03:00
2018-02-06 00:00:00 | [NAME] | Jehovah Church | 06:03:00 | 06:41:00 |  | 07:56:00 | 14:49:00 |  | 15:57:00 | 16:33:00
2018-02-09 00:00:00 | [NAME] | Longwood Septic | 06:18:00 | 06:57:00 |  | 08:28:00 | 16:46:00 |  | 17:10:00 | 17:54:00
 | [NAME]
2018-02-07 00:00:00 | [NAME] | Lake Florence | 06:08:00 | 06:39:00 |  | 07:17:00 | 08:49:00
2018-02-07 00:00:00 | [NAME] | [NAME] |  |  |  | 09:38:00 | 16:21:00 |  | 16:50:00 | 18:11:00
2018-02-07 00:00:00 | [NAME] | Costco | 06:00:00 | 06:53:00 |  | 09:08:00 | 13:21:00 |  | 15:19:00 | 17:45:00
2018-02-08 00:00:00 | [NAME] | Steele Creek Apts | 06:25:00 | 06:33:00 |  | 09:22:00 | 16:04:00 |  | 18:11:00 | 18:29:00
2018-02-08 00:00:00 | [NAME] | Steele Creek Apts | 06:12:00 | 06:40:00 |  | 09:31:00 | 15:45:00 |  | 17:52:00 | 18:29:00
2018-02-09 00:00:00 | [NAME] | Portiva | 06:08:00 | 06:53:00 |  | 10:57:00 | 13:27:00 |  | 15:51:00 | 15:53:00
2018-02-05 00:00:00 | [NAME] | Costco | 06:08:00 | 06:35:00 |  | 09:57:00 | 12:11:00 |  | 14:34:00 | 14:40:00
 | [NAME] |  | 09:20:00 |  |  |  |  |  |  | 15:31:00 | 00:00:00
 | [NAME]
2018-02-05 00:00:00 | [NAME] | Sleiman & Walmart | 18:04:00 | 19:56:00 |  | 21:48:00 | 07:53:00 |  | 07:53:00 | 08:09:00
2018-02-06 00:00:00 | [NAME] |  | 19:25:00 | 19:36:00 |  | 20:02:00 | 21:10:00 |  | 21:20:00 | 21:35:00
2018-02-08 00:00:00 | [NAME] | Walmart Pensacola | 01:13:00 | 01:13:00 |  | 01:24:00 | 02:06:00 |  | 07:49:00 | 08:14:00
 | Rocco Total
 | Sergio |  | 05:51:00 | 07:24:00 |  | 08:54:00 | 11:07:00 |  | 12:22:00 | 12:39:00
 | Sergio |  | 05:55:00 | 06:58:00 |  | 08:39:00 | 15:16:00 |  | 16:31:00 | 16:32:00
 | Sergio |  | 05:51:00 | 06:14:00 |  | 10:13:00 | 11:17:00
 | Sergio |  |  |  |  | 12:19:00 | 15:42:00 |  | 16:22:00 | 16:47:00
 | Sergio |  | 06:00:00 |  |  |  |  |  |  | 16:48:00 | 00:00:00
 | Sergio Total
 | [NAME] |  | 05:50:00 | 06:41:00 |  | 07:56:00 | 14:49:00 |  | 15:57:00 | 16:34:00
 | [NAME] |  | 05:42:00 | 06:39:00 |  | 07:17:00 | 08:49:00
 | [NAME] |  |  |  |  | 09:38:00 | 16:21:00 |  | 16:50:00 | 19:08:00
 | [NAME] |  | 05:48:00 | 06:33:00 |  | 09:22:00 | 16:04:00 |  | 18:11:00 | 18:22:00
2018-02-09 00:00:00 | [NAME] | Longwood Septic | 05:42:00 | 09:13:00 |  | 10:01:00 | 10:53:00 |  | 11:19:00 | 12:09:00
 | [NAME]
2018-02-05 00:00:00 | Terriel | Shop | 05:59:00 |  |  |  |  |  |  | 09:47:00
2018-02-06 00:00:00 | Terriel | The Strand | 06:00:00 | 06:58:00 |  | 07:12:00 | 09:23:00
2018-02-06 00:00:00 | Terriel | Winter Springs Apts | 09:33:00 | 11:08:00 |  | 11:52:00 | 14:09:00 |  | 14:37:00 | 16:30:00
2018-02-07 00:00:00 | Terriel | Jehovah Church | 05:51:00 | 06:41:00 |  | 08:04:00 | 12:01:00 |  | 13:02:00 | 14:18:00
2018-02-08 00:00:00 | Terriel | [NAME] | 05:44:00 | 06:42:00 |  | 08:10:00 | 10:49:00
 | Terriel | Park Ave |  |  |  | 11:41:00 | 15:06:00 |  | 14:05:00 | 14:32:00
2018-02-09 00:00:00 | Terriel | The Strand | 05:46:00 | 06:56:00 |  | 07:55:00 | 11:09:00 |  | 11:18:00 | 12:30:00
 | Terriel Total
 | [NAME] |  | 05:42:00 | 06:33:00 |  | 09:22:00 | 16:04:00 |  | 18:11:00 | 18:27:00
 | [NAME] |  | 05:39:00 | 06:57:00 |  | 08:28:00 | 16:46:00 |  | 17:10:00 | 17:40:00
 | [NAME]
2018-02-06 00:00:00 | TJ | The Shop | 06:10:00 |  |  |  |  |  |  | 13:50:00 | 00:00:00
 | TJ |  | 06:22:00 | 06:41:00 |  | 08:04:00 | 12:01:00 |  | 13:02:00 | 13:09:00
 | TJ |  | 06:10:00 | 06:42:00 |  | 08:10:00 | 10:49:00 |  |  | 14:37:00 | 00:00:00
 | TJ |  |  |  |  | 11:41:00 | 15:06:00 |  | 14:05:00 | 14:37:00
 | TJ |  | 05:50:00 | 06:56:00 |  | 07:55:00 | 11:09:00 |  | 11:18:00 | 11:54:00
 | TJ Total
 | [NAME] |  | 06:07:00 | 07:23:00 |  | 08:28:00 | 13:52:00 |  | 15:39:00 | 15:46:00
 | [NAME] |  | 06:05:00 | 06:38:00 |  | 09:23:00 | 17:59:00 |  | 20:05:00 | 20:11:00
 | [NAME]
 | Willie |  | 06:00:00 | 07:24:00 |  | 08:54:00 | 11:07:00 |  | 12:22:00 | 13:00:00
 | Willie |  | 06:00:00 | 06:58:00 |  | 08:39:00 | 15:16:00 |  | 16:31:00 | 16:55:00
 | Willie |  | 05:57:00 | 06:58:00 |  | 07:58:00 | 15:13:00 |  | 15:39:00 | 16:00:00
 | Willie |  | 05:58:00 | 07:05:00 |  | 09:13:00 | 14:46:00 |  | 15:15:00 | 15:23:00
 | Willie Total
 | [NAME] |  | 06:00:00 | 06:21:00 |  | 07:14:00 | 10:52:00 |  | 14:17:00 | 14:49:00
 | [NAME] |  | 05:50:00 | 06:14:00 |  | 07:39:00 | 10:56:00
 | [NAME] |  |  |  |  | 11:40:00 | 14:11:00 |  | 14:50:00 | 14:56:00
 | [NAME] |  | 05:50:00 | 06:53:00 |  | 09:08:00 | 13:21:00 |  | 15:19:00 | 15:40:00
2018-02-08 00:00:00 | [NAME] | Shop | 06:00:00 |  |  |  |  |  |  | 14:30:00 | 00:00:00
2018-02-09 00:00:00 | [NAME] | Lake Florence | 06:00:00 | 07:56:00 |  | 08:20:00 | 08:39:00 |  | 09:22:00 | 10:00:00
 | Willie S Total
 | Grand Total