Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 02122018-02182018

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) | Called out/Late
2018-02-12 00:00:00 | [NAME] | [NAME] | 06:50:00 | 10:04:00 |  | 11:48:00 | 16:28:00 |  | 18:02:00 | 18:02:00
2018-02-13 00:00:00 | [NAME] | Princeton Oaks | 05:57:00 | 07:23:00 |  | 08:32:00 | 15:22:00 |  | 15:57:00 | 16:10:00
2018-02-14 00:00:00 | [NAME] | Summer field Lucaya | 05:52:00 | 06:09:00 |  | 09:11:00 | 15:15:00 |  | 15:46:00 | 15:58:00
2018-02-15 00:00:00 | [NAME] | Princeton Oaks | 06:21:00 | 07:20:00 |  | 08:36:00 | 17:18:00 |  | 18:26:00 | 18:30:00
2018-02-16 00:00:00 | [NAME] | Dollar General [NAME] | 05:53:00 | 07:23:00 |  | 09:22:00 | 12:50:00 |  | 14:55:00 | 15:10:00
 | Allen Total
2018-02-12 00:00:00 | [NAME] | Shop | 06:56:00 |  |  |  |  |  |  | 14:00:00 | 00:00:00
2018-02-13 00:00:00 | [NAME] |  | 06:47:00 |  |  |  |  |  |  | 15:22:00 | 00:00:00
2018-02-14 00:00:00 | [NAME] | Seagrass | 07:04:00 | 08:07:00 |  | 08:42:00 | 17:14:00 |  | 17:54:00 | 18:01:00
2018-02-15 00:00:00 | [NAME] | I-295 | 07:05:00 | 08:29:00 |  | 08:55:00 | 12:08:00
2018-02-15 00:00:00 | [NAME] | [NAME] |  |  |  | 12:17:00 | 15:26:00 |  | 16:00:00 | 16:44:00
2018-02-16 00:00:00 | [NAME] | Shop | 07:20:00 |  |  |  |  |  |  | 13:12:00 | 00:00:00
 | [NAME]
2018-02-12 00:00:00 | [NAME] | Villa Domani | 05:55:00 | 07:03:00 |  | 08:47:00 | 11:21:00
2018-02-12 00:00:00 | [NAME] | [NAME] |  |  |  | 11:56:00 | 15:07:00 |  | 16:03:00 | 17:04:00
2018-02-13 00:00:00 | [NAME] | Oak Tree Pointe | 06:05:00 | 07:48:00 |  | 09:40:00 | 13:36:00
2018-02-13 00:00:00 | [NAME] | AIPO |  |  |  | 13:59:00 | 14:18:00 |  | 14:49:00 | 16:56:00
2018-02-14 00:00:00 | [NAME] | Princeton Oaks | 06:06:00 | 06:39:00 |  | 08:45:00 | 15:18:00 |  | 16:08:00 | 16:57:00
2018-02-15 00:00:00 | [NAME] | [NAME] | 06:03:00 | 07:03:00 |  | 08:16:00 | 10:03:00
2018-02-15 00:00:00 | [NAME] | Meadow Woods |  |  |  | 10:53:00 | 14:39:00
2018-02-15 00:00:00 | [NAME] | Princeton Oaks |  |  |  | 15:19:00 | 16:24:00 |  | 17:16:00 | 17:29:00
2018-02-16 00:00:00 | [NAME] | Vera | 05:56:00 | 06:52:00 |  | 07:17:00 | 10:49:00
2018-02-16 00:00:00 | [NAME] | Science One Ph 2 |  |  |  | 11:29:00 | 12:31:00 |  | 13:26:00 | 16:00:00
 | [NAME]
2018-02-12 00:00:00 | [NAME] | [NAME] | 05:48:00 | 07:11:00 |  | 09:01:00 | 17:50:00 |  | 19:05:00 | 19:12:00
2018-02-13 00:00:00 | [NAME] | Princeton Oaks | 05:55:00 | 07:23:00 |  | 08:26:00 | 14:57:00 |  | 15:30:00 | 15:34:00
2018-02-14 00:00:00 | [NAME] | Seagrass | 05:57:00 | 06:45:00 |  | 09:11:00 | 14:22:00 |  | 16:40:00 | 16:46:00
2018-02-15 00:00:00 | [NAME] | I-295 | 05:53:00 | 06:29:00 |  | 09:13:00 | 12:00:00
2018-02-15 00:00:00 | [NAME] | [NAME] |  |  |  | 12:20:00 | 15:52:00 |  | 17:43:00 | 18:37:00
2018-02-16 00:00:00 | [NAME] | Jehovah Church | 05:55:00 | 06:52:00 |  | 08:03:00 | 13:49:00 |  | 14:59:00 | 15:08:00
 | Anthony Total
2018-02-12 00:00:00 | [NAME] | [NAME] | 07:10:00 | 07:37:00 |  | 09:00:00 | 16:27:00 |  | 17:48:00 | 18:03:00
2018-02-13 00:00:00 | [NAME] | Princeton Oaks | 06:13:00 | 07:23:00 |  | 08:32:00 | 15:22:00 |  | 15:57:00 | 16:11:00
2018-02-14 00:00:00 | [NAME] | Summer field Lucaya | 05:58:00 | 06:09:00 |  | 09:11:00 | 15:15:00 |  | 15:46:00 | 15:58:00
2018-02-15 00:00:00 | [NAME] | Princeton Oaks | 06:02:00 | 07:20:00 |  | 08:36:00 | 17:18:00 |  | 18:26:00 | 18:58:00
2018-02-16 00:00:00 | [NAME] | Dollar General [NAME] | 06:30:00 | 07:23:00 |  | 09:22:00 | 12:50:00 |  | 14:55:00 | 16:00:00
 | [NAME]
2018-02-13 00:00:00 | [NAME] | Walmart | 18:01:00 | 19:13:00 |  | 19:49:00 | 04:11:00 |  | 06:37:00 | 07:01:00
2018-02-15 00:00:00 | [NAME] | Vera | 06:02:00 | 06:43:00 |  | 07:29:00 | 12:52:00 |  | 14:11:00 | 14:59:00
2018-02-16 00:00:00 | [NAME] | Office | 06:14:00 |  |  |  |  |  |  | 16:04:00 | 00:00:00
 | Brandon Total
2018-02-12 00:00:00 | Dwayne | Called out
2018-02-13 00:00:00 | Dwayne | Seagrass | 06:00:00 | 07:30:00 |  | 10:37:00 | 14:03:00 |  | 16:25:00 | 17:00:00
2018-02-14 00:00:00 | Dwayne | Seagrass | 06:03:00 | 06:14:00 |  | 09:08:00 | 18:18:00 |  | 18:31:00 | 18:34:00
2018-02-15 00:00:00 | Dwayne | Project 942 | 05:50:00 | 06:26:00 |  | 07:01:00 | 12:31:00
2018-02-15 00:00:00 | Dwayne | [NAME] | 05:50:00 |  |  | 14:00:00 | 14:41:00 |  | 15:39:00 | 15:50:00
2018-02-16 00:00:00 | Dwayne | Kids R Kids | 05:52:00 | 06:39:00 |  | 08:21:00 | 16:20:00 |  | 17:41:00 | 18:21:00
 | [NAME]
2018-02-12 00:00:00 | Edgar | Firestation 62 | 05:56:00 | 07:29:00 |  | 08:23:00 | 15:12:00 |  | 16:17:00 | 16:56:00
2018-02-13 00:00:00 | Edgar | Sonata | 06:00:00 | 07:49:00 |  | 09:16:00 | 11:02:00
2018-02-13 00:00:00 | Edgar | Princeton Oaks |  |  |  | 11:30:00 | 15:35:00 |  | 16:11:00 | 16:55:00
2018-02-14 00:00:00 | Edgar | [NAME] | 05:58:00 | 06:24:00 |  | 06:56:00 | 15:52:00 |  | 16:31:00 | 16:57:00
2018-02-15 00:00:00 | Edgar | Vera | 06:01:00 | 06:43:00 |  | 07:29:00 | 12:52:00 |  | 14:11:00 | 15:08:00
2018-02-16 00:00:00 | Edgar | Vera | 05:58:00 | 06:25:00 |  | 07:16:00 | 07:53:00
2018-02-16 00:00:00 | Edgar | Science One Ph 2 |  |  |  | 08:35:00 | 14:18:00 |  | 14:38:00 | 15:23:00
 | [NAME]
2018-02-12 00:00:00 | Efrain | [NAME] | 05:48:00 | 07:03:00 |  | 08:47:00 | 11:21:00
2018-02-12 00:00:00 | Efrain | [NAME] |  |  |  | 11:56:00 | 15:07:00 |  | 16:03:00 | 16:31:00
2018-02-13 00:00:00 | Efrain | Shop | 05:50:00 |  |  |  |  |  |  | 09:54:00 | 00:00:00
2018-02-14 00:00:00 | Efrain | Shop | 05:49:00 |  |  |  |  |  |  | 16:10:00 | 00:00:00
2018-02-15 00:00:00 | Efrain | Apopka Firestation | 05:48:00 | 06:43:00 |  | 07:42:00 | 08:41:00 |  | 09:35:00 | 10:01:00
2018-02-16 00:00:00 | Efrain | Shop | 05:50:00 |  |  |  |  |  |  | 11:16:00 | 00:00:00
 | Efrain Total
2018-02-12 00:00:00 | [NAME] | Shop | 08:21:00 |  |  |  |  |  |  | 17:00:00 | 00:00:00
2018-02-13 00:00:00 | [NAME] | Seagrass | 07:48:00 | 07:48:00 |  | 09:50:00 | 19:31:00 |  | 14:23:00 | 14:23:00
2018-02-14 00:00:00 | [NAME] | Seagrass | 08:04:00 | 08:07:00 |  | 08:42:00 | 17:14:00 |  | 17:00:00 | 17:00:00
2018-02-15 00:00:00 | [NAME] |  | 07:34:00 | 08:11:00 |  | 09:05:00 | 17:40:00 |  | 17:00:00 | 17:00:00
2018-02-16 00:00:00 | [NAME] | Shop | 06:00:00 |  |  |  |  |  |  | 17:00:00 | 00:00:00
 | [NAME]
2018-02-12 00:00:00 | Lindsey | Firestation 62 | 05:50:00 | 07:29:00 |  | 08:23:00 | 15:12:00 |  | 16:17:00 | 16:30:00
2018-02-13 00:00:00 | Lindsey | Seagrass | 05:50:00 | 07:30:00 |  | 10:37:00 | 14:03:00 |  | 16:25:00 | 16:56:00
2018-02-14 00:00:00 | Lindsey | Seagrass | 05:50:00 | 06:14:00 |  | 09:08:00 | 18:18:00 |  | 18:31:00 | 18:37:00
2018-02-15 00:00:00 | Lindsey | Project 942 | 05:51:00 | 06:26:00 |  | 07:01:00 | 12:31:00
2018-02-15 00:00:00 | Lindsey | [NAME] | 05:51:00 |  |  | 14:00:00 | 14:41:00 |  | 15:39:00 | 16:05:00
2018-02-16 00:00:00 | Lindsey | Kids R Kids | 05:50:00 | 06:39:00 |  | 08:21:00 | 16:20:00 |  | 17:41:00 | 17:50:00
 | Lindsey Total
2018-02-12 00:00:00 | Nick | Scheduled off
2018-02-13 00:00:00 | Nick | Scheduled off
2018-02-14 00:00:00 | Nick | [NAME] | 06:00:00 | 06:24:00 |  | 06:56:00 | 15:52:00 |  | 16:31:00 | 16:55:00
2018-02-15 00:00:00 | Nick | Vera | 05:58:00 | 06:43:00 |  | 07:29:00 | 12:52:00 |  | 14:11:00 | 15:00:00
2018-02-16 00:00:00 | Nick | Vera | 06:03:00 | 06:25:00 |  | 07:16:00 | 07:53:00
2018-02-16 00:00:00 | Nick | Science One Ph 2 |  |  |  | 08:35:00 | 14:18:00 |  | 14:38:00 | 15:23:00
 | Nick Total
2018-02-12 00:00:00 | [NAME] | [NAME] | 06:03:00 | 07:11:00 |  | 09:01:00 | 17:50:00 |  | 19:05:00 | 19:18:00
2018-02-13 00:00:00 | [NAME] | Princeton Oaks | 06:08:00 | 07:23:00 |  | 08:26:00 | 14:57:00 |  | 15:30:00 | 16:42:00
2018-02-14 00:00:00 | [NAME] | Seagrass | 06:07:00 | 06:45:00 |  | 09:11:00 | 14:22:00 |  | 16:40:00 | 16:48:00
2018-02-15 00:00:00 | [NAME] | I-295 | 06:10:00 | 06:29:00 |  | 09:13:00 | 12:00:00
2018-02-15 00:00:00 | [NAME] | [NAME] |  |  |  | 12:20:00 | 15:52:00 |  | 17:43:00 | 17:50:00
2018-02-16 00:00:00 | [NAME] | Jehovah Church | 06:04:00 | 06:52:00 |  | 08:03:00 | 13:49:00 |  | 14:59:00 | 15:16:00
 | [NAME]
2018-02-12 00:00:00 | Ricky | Called out
2018-02-13 00:00:00 | Ricky | Sonata | 06:03:00 | 07:49:00 |  | 09:16:00 | 11:02:00
2018-02-13 00:00:00 | Ricky | Princeton Oaks |  |  |  | 11:30:00 | 15:35:00 |  | 16:11:00 | 16:42:00
2018-02-14 00:00:00 | Ricky | Oak Tree Pointe | 06:10:00 | 07:03:00 |  | 08:40:00 | 14:51:00 |  | 15:45:00 | 16:22:00
2018-02-15 00:00:00 | Ricky | Oaktree Point | 06:10:00 | 06:31:00 |  | 08:05:00 | 09:02:00
2018-02-15 00:00:00 | Ricky | [NAME] |  |  |  | 13:34:00 | 15:23:00 |  | 16:11:00 | 17:05:00
2018-02-16 00:00:00 | Ricky | [NAME] | 06:10:00 | 07:30:00 |  | 09:37:00 | 11:05:00
2018-02-16 00:00:00 | Ricky | Kids R Kids |  |  |  | 12:53:00 | 16:57:00 |  | 18:13:00 | 19:37:00
 | Ricky Total
2018-02-13 00:00:00 | [NAME] | Walmart | 18:02:00 | 19:13:00 |  | 19:49:00 | 04:11:00 |  | 06:37:00 | 07:01:00
2018-02-15 00:00:00 | [NAME] | Vera | 06:03:00 | 06:43:00 |  | 07:29:00 | 12:52:00 |  | 14:11:00 | 14:57:00
2018-02-16 00:00:00 | [NAME] | Office | 06:14:00 |  |  |  |  |  |  | 16:03:00 | 00:00:00
 | Rocco Total
2018-02-12 00:00:00 | Sergio | [NAME] | 06:10:00 | 07:38:00 |  | 09:30:00 | 16:28:00 |  | 17:44:00 | 18:15:00
2018-02-13 00:00:00 | Sergio | Princeton Oaks | 05:59:00 | 07:33:00 |  | 08:33:00 | 15:34:00 |  | 16:00:00 | 16:00:00
2018-02-14 00:00:00 | Sergio | Princeton Oaks | 06:05:00 | 06:39:00 |  | 08:51:00 | 15:18:00 |  | 16:04:00 | 16:08:00
2018-02-15 00:00:00 | Sergio | Princeton Oaks | 05:55:00 | 07:22:00 |  | 08:37:00 | 16:22:00 |  | 17:16:00 | 17:20:00
2018-02-16 00:00:00 | Sergio | Vera
2018-02-16 00:00:00 | Sergio | Science One Ph 2
 | Sergio Total
2018-02-12 00:00:00 | [NAME] | [NAME] | 05:48:00 | 07:03:00 |  | 08:47:00 | 11:21:00
2018-02-12 00:00:00 | [NAME] | Villa Domani |  |  |  | 11:56:00 | 15:07:00 |  | 16:03:00 | 16:44:00
2018-02-13 00:00:00 | [NAME] | Shop | 05:49:00 |  |  |  |  |  |  | 12:09:00 | 00:00:00
2018-02-14 00:00:00 | [NAME] | Shop | 05:47:00 |  |  |  |  |  |  | 16:14:00 | 00:00:00
2018-02-15 00:00:00 | [NAME] | Apopka Firestation | 05:47:00 | 06:43:00 |  | 07:42:00 | 08:41:00 |  | 09:35:00 | 10:01:00
2018-02-16 00:00:00 | [NAME] | Shop | 05:49:00 |  |  |  |  |  |  | 11:16:00 | 00:00:00
2018-02-16 00:00:00 | [NAME] | Shop | 14:03:00 |  |  |  |  |  |  | 16:05:00 | 00:00:00
 | [NAME]
2018-02-12 00:00:00 | Terriel | Firestation 62 | 06:00:00 | 06:39:00 |  | 08:06:00 | 10:16:00 |  | 11:23:00
2018-02-12 00:00:00 | Terriel | [NAME] |  |  |  | 13:54:00 | 14:19:00 |  | 15:43:00 | 17:56:00
2018-02-13 00:00:00 | Terriel | Oak Tree Pointe | 06:00:00 | 07:20:00 |  | 08:30:00 | 13:00:00 |  | 13:42:00 | 14:30:00
2018-02-14 00:00:00 | Terriel | Apopka Firestation | 07:04:00 | 07:17:00 |  | 08:34:00 | 13:52:00 |  | 14:46:00 | 15:00:00
2018-02-15 00:00:00 | Terriel | Princeton Oaks | 05:57:00 | 06:52:00 |  | 08:04:00 | 08:16:00
2018-02-15 00:00:00 | Terriel | Park Ave |  |  |  | 08:45:00 | 09:49:00
2018-02-15 00:00:00 | Terriel | Oaktree Point |  |  |  | 10:39:00 | 11:07:00
2018-02-15 00:00:00 | Terriel | Vera |  |  |  | 12:09:00 | 12:47:00
2018-02-15 00:00:00 | Terriel | Princeton Oaks |  |  |  | 14:46:00 | 15:56:00
2018-02-15 00:00:00 | Terriel | Vera |  |  |  | 16:05:00 | 17:44:00 |  | 18:23:00 | 18:29:00
2018-02-16 00:00:00 | Terriel
 | Terriel Total
2018-02-12 00:00:00 | TJ | Firestation 62 | 05:54:00 | 06:39:00 |  | 08:06:00 | 10:16:00 |  | 11:23:00 | 16:50:00
2018-02-13 00:00:00 | TJ | Shop | 06:09:00 |  |  |  |  |  |  | 15:18:00 | 00:00:00
2018-02-14 00:00:00 | TJ | Apopka Firestation | 06:06:00 | 07:17:00 |  | 08:34:00 | 13:52:00 |  | 14:46:00 | 16:36:00
2018-02-15 00:00:00 | TJ | Shop | 06:18:00 |  |  |  |  |  |  | 15:43:00 | 00:00:00
2018-02-16 00:00:00 | TJ | Shop | 06:10:00 |  |  |  |  |  |  | 11:00:00 | 00:00:00
 | TJ Total
2018-02-12 00:00:00 | [NAME] | [NAME] | 06:03:00 | 10:04:00 |  | 11:48:00 | 16:28:00 |  | 18:02:00 | 18:04:00
2018-02-13 00:00:00 | [NAME] | Princeton Oaks | 05:59:00 | 07:33:00 |  | 08:33:00 | 15:34:00 |  | 16:37:00 | 17:22:00
2018-02-14 00:00:00 | [NAME] | Oak Tree Pointe | 05:34:00 | 07:03:00 |  | 08:40:00 | 14:51:00 |  | 15:45:00 | 16:09:00
2018-02-15 00:00:00 | [NAME] | Oaktree Point | 06:01:00 | 06:31:00 |  | 08:05:00 | 09:02:00
2018-02-15 00:00:00 | [NAME] | [NAME] |  |  |  | 13:34:00 | 15:23:00 |  | 16:11:00 | 17:05:00
2018-02-16 00:00:00 | [NAME] | [NAME] | 06:22:00 | 07:30:00 |  | 09:37:00 | 11:05:00
2018-02-16 00:00:00 | [NAME] | Kids R Kids |  |  |  | 12:53:00 | 16:57:00 |  | 18:13:00 | 19:37:00
 | [NAME]
2018-02-12 00:00:00 | Willie | Called out
2018-02-13 00:00:00 | Willie | Oak Tree Pointe | 05:49:00 | 07:48:00 |  | 09:40:00 | 13:36:00
2018-02-13 00:00:00 | Willie | AIPO |  |  |  |  |  |  | 14:49:00 | 15:28:00
2018-02-14 00:00:00 | Willie | Princeton Oaks | 05:58:00 | 06:39:00 |  | 08:45:00 | 15:18:00 |  | 16:08:00 | 16:11:00
2018-02-15 00:00:00 | Willie | [NAME] | 05:55:00 | 07:03:00 |  | 08:16:00 | 10:03:00
2018-02-15 00:00:00 | Willie | Meadow Woods |  |  |  | 10:53:00 | 14:39:00
2018-02-15 00:00:00 | Willie | Princeton Oaks |  |  |  | 15:19:00 | 16:24:00 |  | 17:16:00 | 17:29:00
2018-02-16 00:00:00 | Willie | Vera | 05:55:00 | 06:52:00 |  | 07:17:00 | 10:49:00
2018-02-16 00:00:00 | Willie | Science One Ph 2 |  |  |  | 11:29:00 | 12:31:00 |  | 13:26:00 | 13:28:00
 | Willie Total
2018-02-12 00:00:00 | [NAME] | Called out
2018-02-13 00:00:00 | [NAME] |  | 06:00:00 |  |  |  |  |  |  | 14:30:00 | 00:00:00
2018-02-14 00:00:00 | [NAME] | Apopka Firestation | 06:00:00 | 07:17:00 |  | 08:34:00 | 13:52:00 |  | 14:30:00 | 14:30:00
2018-02-15 00:00:00 | [NAME] | Princeton Oaks | 06:00:00 | 06:52:00 |  | 08:04:00 | 08:16:00
2018-02-15 00:00:00 | [NAME] | Park Ave |  |  |  | 08:45:00 | 09:49:00
2018-02-15 00:00:00 | [NAME] | Oaktree Point |  |  |  | 10:39:00 | 11:07:00
2018-02-15 00:00:00 | [NAME] | Vera |  |  |  | 12:09:00 | 12:47:00 |  | 14:04:00 | 15:00:00
2018-02-16 00:00:00 | [NAME] | Science One Ph 2 | 06:00:00 | 06:30:00 |  | 07:11:00 | 10:12:00 |  | 10:35:00 | 10:45:00
 | Willie S Total