Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 02252015-03032018

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
2018-02-26 00:00:00 | [NAME] | 1 | Segovia | 05:49:00 | 07:46:00 |  | 09:07:00 | 14:06:00 |  | 14:39:00 | 14:49:00
2018-02-27 00:00:00 | [NAME] | 1 | Shop | 05:49:00
2018-02-28 00:00:00 | [NAME] | 1 | The Strand | 05:50:00 | 06:18:00 |  | 06:54:00 | 15:13:00 |  | 11:57:00 | 12:01:00
2018-03-01 00:00:00 | [NAME] | 1 | Grande Lakes | 08:01:00 | 07:02:00 | 00:00:00 | 07:55:00 | 12:38:00 |  | 13:15:00 | 13:28:00
2018-03-02 00:00:00 | [NAME] | 1 | The Reserve At Sweetwater | 05:51:00 | 06:13:00 |  | 07:00:00 | 14:38:00 |  | 15:30:00 | 15:34:00
 | Allen Total
2018-02-26 00:00:00 | [NAME] |  | I-295 | 07:20:00 | 08:03:00 |  | 08:47:00 | 14:00:00 |  | 14:21:00 | 15:45:00
2018-02-27 00:00:00 | [NAME] |  | I-295 | 07:23:00 | 08:20:00 |  | 08:57:00 | 15:45:00 |  | 16:13:00 | 16:34:00
2018-02-28 00:00:00 | [NAME] |  | I-295 | 07:32:00 | 08:12:00 |  | 08:53:00 | 15:58:00 |  | 16:20:00 | 16:38:00
2018-03-01 00:00:00 | [NAME] |  | I-295 | 06:50:00 | 07:40:00 |  | 08:07:00 | 16:23:00 |  | 16:30:00 | 16:39:00
2018-03-02 00:00:00 | [NAME] |  | I-295 | 06:38:00 | 07:06:00 |  | 07:19:00 | 15:52:00 |  | 16:03:00 | 16:41:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 5
2018-02-26 00:00:00 | [NAME] | 1 | Legacy | 05:57:00 | 09:49:00 |  | 11:23:00 | 13:04:00 |  | 14:09:00 | 16:32:00
2018-02-27 00:00:00 | [NAME] | 2 | Lot 5A Country Club | 05:52:00 | 06:16:00 |  | 06:56:00 | 07:51:00
2018-02-27 00:00:00 | [NAME] | 2 | Bainbridge |  |  |  | 08:57:00 | 12:31:00 |  | 13:16:00 | 15:53:00
2018-02-28 00:00:00 | [NAME] | 2 | Science One Ph 2 | 05:52:00 | 06:52:00 |  | 07:14:00 | 07:43:00
2018-02-28 00:00:00 | [NAME] | 2 | Park Ave |  |  |  | 08:30:00 | 11:46:00
2018-02-28 00:00:00 | [NAME] | 2 | The Strand |  |  |  | 12:34:00 | 14:03:00 |  | 14:11:00 | 16:19:00
2018-03-01 00:00:00 | [NAME] | 1 | Grande Lakes | 05:54:00 | 07:03:00 |  | 07:55:00 | 12:36:00 |  | 13:15:00 | 16:24:00
2018-03-02 00:00:00 | [NAME] | 2 | Publix | 05:58:00 | 06:15:00 |  | 07:26:00 | 13:12:00 |  | 13:26:00 | 14:24:00
 | [NAME]
2018-02-26 00:00:00 | [NAME] | 6 | Segovia | 05:56:00 | 07:11:00 |  | 09:12:00 | 17:03:00 |  | 17:41:00 | 17:49:00
2018-02-28 00:00:00 | [NAME] |  | The Preserve at Sweetwater | 06:01:00 | 07:10:00 |  | 07:37:00 | 15:02:00
2018-02-28 00:00:00 | [NAME] |  | Heritage at Plant Street |  |  |  | 15:45:00 | 16:45:00 |  | 18:07:00 | 18:11:00
2018-03-01 00:00:00 | [NAME] | 6 | Segovia | 05:58:00 | 07:36:00
2018-03-01 00:00:00 | [NAME] | 6 | The Reserve At Sweetwater |  |  |  | 10:18:00 | 15:06:00 |  | 16:07:00 | 16:12:00
 | Anthony Total
2018-02-26 00:00:00 | [NAME] | 1 | Segovia | 06:30:00 | 07:46:00 |  | 09:07:00 | 14:06:00 |  | 14:39:00 | 17:30:00
2018-02-27 00:00:00 | [NAME] | 1 | Shop | 06:00:00
2018-02-28 00:00:00 | [NAME] | 1 | The Strand | 06:00:00 | 06:18:00 |  | 06:54:00 | 15:13:00 |  | 15:16:00 | 15:22:00
2018-03-01 00:00:00 | [NAME] | 1 | Grande Lakes | 06:00:00 | 07:02:00 |  | 07:55:00 | 12:38:00 |  | 13:15:00 | 17:23:00
2018-03-02 00:00:00 | [NAME] | 1 | The Reserve At Sweetwater | 05:58:00 | 06:13:00 |  | 07:00:00 | 14:38:00 |  | 15:30:00 | 15:42:00
 | [NAME]
2018-02-25 00:00:00 | [NAME] |  | Walmart | 16:53:00 | 17:31:00 |  | 21:47:00 | 08:00:00 |  | 08:13:00 | 08:32:00
2018-02-26 00:00:00 | [NAME] |  | Walmart | 18:01:00 | 18:10:00 |  | 18:25:00 | 07:33:00 |  | 08:00:00 | 08:07:00
2018-02-27 00:00:00 | [NAME] |  | Walmart | 18:06:00 | 18:09:00 |  | 18:27:00 | 06:45:00 |  | 07:08:00 | 07:18:00
2018-02-28 00:00:00 | [NAME] |  | Walmart | 18:00:00 | 18:18:00 |  | 18:27:00 | 06:52:00 |  | 07:16:00 | 07:23:00
2018-03-01 00:00:00 | [NAME] |  | Walmart | 17:51:00 | 17:58:00 |  | 18:09:00 | 06:23:00 |  | 06:44:00 | 07:00:00
2018-03-02 00:00:00 | [NAME] |  | Walmart | 18:04:00 |  |  |  |  |  |  | 12:56:00 | 00:00:00
 | Brandon Total |  |  |  |  |  |  |  |  |  |  |  |  | 36
2018-02-26 00:00:00 | Dwayne |  | Sadler | 04:43:00 | 05:14:00 |  | 08:44:00 | 14:41:00 |  | 17:39:00 | 17:44:00
2018-02-27 00:00:00 | Dwayne | 10 | [NAME] | 05:49:00 | 06:16:00 |  | 07:21:00 | 12:52:00
2018-02-27 00:00:00 | Dwayne | 10 | The Strand |  |  |  | 13:25:00 | 15:49:00 |  | 16:01:00 | 16:31:00
2018-02-28 00:00:00 | Dwayne | 10 | The Strand | 05:57:00 | 06:18:00 |  | 06:40:00 | 14:29:00 |  | 14:31:00 | 14:34:00
2018-03-02 00:00:00 | Dwayne | 10 | Sadler | 04:48:00 | 05:06:00 |  | 08:17:00 | 15:02:00 |  | 18:11:00 | 18:16:00
 | [NAME]
2018-02-25 00:00:00 | Edgar | 8 | [NAME] | 18:06:00 | 19:28:00 |  | 22:30:00 | 03:45:00 |  | 05:48:00 | 06:01:00
2018-02-26 00:00:00 | Edgar | 10 | Sadler | 18:12:00 | 18:37:00 |  | 21:22:00 | 04:08:00 |  | 06:30:00 | 06:39:00
2018-02-27 00:00:00 | Edgar | 8 | [NAME] | 18:20:00 | 18:42:00 |  | 21:45:00 | 04:52:00 |  | 07:02:00 | 07:23:00
2018-02-28 00:00:00 | Edgar | 8 | [NAME] | 17:57:00 | 18:56:00 |  | 21:53:00 | 05:00:00 |  | 07:24:00 | 07:29:00
2018-03-01 00:00:00 | Edgar | 8 | [NAME] | 18:06:00 | 18:39:00 |  | 21:43:00 | 05:02:00 |  | 07:06:00 | 07:13:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 5
2018-02-25 00:00:00 | Efrain |  | Walmart | 17:54:00 | 18:50:00 |  | 19:53:00 | 04:04:00 |  | 04:31:00 | 04:34:00
2018-02-26 00:00:00 | Efrain |  | Walmart | 19:00:00 | 18:05:00 | 00:00:00 | 20:30:00 | 07:28:00 |  | 09:49:00 | 09:52:00
2018-02-27 00:00:00 | Efrain |  | Walmart | 18:09:00 | 18:46:00 |  | 21:17:00 | 07:10:00 |  | 09:24:00 | 09:35:00
2018-02-28 00:00:00 | Efrain |  | Walmart | 18:02:00 | 18:39:00 |  | 21:48:00 | 06:13:00 |  | 09:05:00 | 09:19:00
2018-03-01 00:00:00 | Efrain |  | Walmart | 18:16:00 | 19:03:00 |  | 21:13:00 | 06:52:00 |  | 08:46:00 | 08:51:00
 | Efrain Total |  |  |  |  |  |  |  |  |  |  |  |  | 36
2018-02-26 00:00:00 | [NAME] |  | Shop | 08:31:00 |  |  |  |  |  |  | 17:23:00
2018-02-26 00:00:00 | [NAME] | 4 | Kids R Kids | 05:58:00 | 09:50:00 |  | 10:51:00 | 14:12:00 |  | 15:24:00 | 18:46:00
2018-02-27 00:00:00 | [NAME] |  | Shop | 05:56:00
2018-02-28 00:00:00 | [NAME] |  | Shop | 06:07:00
2018-03-01 00:00:00 | [NAME] |  | Shop | 06:08:00
2018-03-02 00:00:00 | [NAME] |  | Shop | 06:08:00 |  |  |  |  |  |  | 13:48:00 | 00:00:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0
2018-02-26 00:00:00 | Lindsey |  | Sadler | 05:00:00 | 05:14:00 |  | 08:44:00 | 14:41:00 |  | 17:39:00 | 17:47:00
2018-02-27 00:00:00 | Lindsey | 10 | [NAME] | 05:50:00 | 06:16:00 |  | 07:21:00 | 12:52:00
2018-02-27 00:00:00 | Lindsey | 10 | The Strand |  |  |  | 13:25:00 | 15:49:00 |  | 16:01:00 | 16:34:00
2018-02-28 00:00:00 | Lindsey | 10 | The Strand | 05:50:00 | 06:18:00 |  | 06:40:00 | 14:29:00 |  | 14:31:00 | 14:33:00
2018-03-02 00:00:00 | Lindsey | 10 | Sadler | 04:56:00 | 05:06:00 |  | 08:17:00 | 15:02:00 |  | 18:11:00 | 18:20:00
 | Lindsey Total
2018-02-25 00:00:00 | Logan |  | Walmart | 16:45:00 | 19:08:00 |  | 21:36:00 | 07:31:00 |  | 09:36:00 | 10:01:00
2018-02-26 00:00:00 | Logan |  | Walmart | 18:18:00 | 18:40:00 |  | 21:35:00 | 07:11:00 |  | 09:07:00 | 09:37:00
2018-02-27 00:00:00 | Logan |  | Walmart | 19:57:00 | 20:36:00 |  | 23:07:00 | 03:44:00 |  | 05:14:00 | 05:22:00
2018-02-28 00:00:00 | Logan |  | Walmart | 17:10:00 | 18:36:00 |  | 21:08:00 | 08:20:00 |  | 11:15:00 | 11:34:00
2018-03-01 00:00:00 | Logan |  | Walmart | 20:58:00 | 21:00:00 |  | 22:42:00 | 03:28:00 |  | 05:06:00 | 05:22:00
2018-03-02 00:00:00 | Logan |  | Walmart | 19:04:00 | 19:17:00 |  | 20:16:00 | 07:28:00 |  | 09:39:00 | 10:39:00
 | Logan Total |  |  |  |  |  |  |  |  |  |  |  |  | 36
2018-02-25 00:00:00 | Nick | 8 | [NAME] | 17:29:00 | 19:28:00 |  | 22:30:00 | 03:45:00 |  | 05:48:00 | 05:59:00
2018-02-26 00:00:00 | Nick | 10 | Sadler | 17:26:00 | 18:37:00 |  | 21:22:00 | 04:08:00 |  | 06:30:00 | 06:40:00
2018-02-27 00:00:00 | Nick | 8 | [NAME] | 17:38:00 | 18:42:00 |  | 21:45:00 | 04:52:00 |  | 07:02:00 | 07:24:00
2018-02-28 00:00:00 | Nick | 8 | [NAME] | 17:33:00 | 18:56:00 |  | 21:53:00 | 05:00:00 |  | 07:24:00 | 07:29:00
2018-03-01 00:00:00 | Nick | 8 | [NAME] | 17:40:00 | 18:39:00 |  | 21:43:00 | 05:02:00 |  | 07:06:00 | 07:12:00
 | Nick Total |  |  |  |  |  |  |  |  |  |  |  |  | 5
2018-02-27 00:00:00 | [NAME] | 6 | The Strand | 06:06:00 | 07:10:00 |  | 07:24:00 | 16:46:00 |  | 16:55:00 | 17:01:00
2018-02-28 00:00:00 | [NAME] |  | The Preserve at Sweetwater | 06:05:00 | 07:10:00 |  | 07:37:00 | 15:02:00
2018-02-28 00:00:00 | [NAME] |  | Heritage at Plant Street |  |  |  | 15:45:00 | 16:45:00 |  | 18:07:00 | 18:20:00
2018-03-01 00:00:00 | [NAME] | 6 | Segovia | 06:05:00 | 07:36:00 |  | 08:15:00 | 09:17:00
2018-03-01 00:00:00 | [NAME] | 6 | The Reserve At Sweetwater |  |  |  | 10:18:00 | 15:06:00 |  | 16:07:00 | 16:42:00
2018-03-02 00:00:00 | [NAME] | 6 | Segovia | 06:05:00 | 06:44:00 |  | 09:06:00 | 10:26:00 |  | 11:06:00 | 15:17:00
 | [NAME]
2018-02-25 00:00:00 | Ricky |  | Walmart | 16:45:00 | 19:08:00 |  | 21:36:00 | 07:31:00 |  | 09:36:00 | 10:10:00
2018-02-26 00:00:00 | Ricky |  | Walmart | 18:18:00 | 18:40:00 |  | 21:35:00 | 07:11:00 |  | 09:07:00 | 09:36:00
2018-02-27 00:00:00 | Ricky |  | Walmart | 19:57:00 | 20:36:00 |  | 23:07:00 | 03:44:00 |  | 05:14:00 | 05:22:00
2018-02-28 00:00:00 | Ricky |  | Walmart | 17:08:00 | 18:36:00 |  | 21:08:00 | 08:20:00 |  | 11:15:00 | 11:38:00
2018-03-01 00:00:00 | Ricky |  | Walmart | 20:58:00 | 21:00:00 |  | 22:42:00 | 03:28:00 |  | 05:06:00 | 05:15:00
2018-03-02 00:00:00 | Ricky |  | Walmart | 19:04:00 | 19:17:00 |  | 20:16:00 | 07:28:00 |  | 09:39:00 | 10:39:00
 | Ricky Total |  |  |  |  |  |  |  |  |  |  |  |  | 36
2018-02-25 00:00:00 | [NAME] |  | Walmart | 16:53:00 | 17:31:00 |  | 21:47:00 | 08:00:00 |  | 08:13:00 | 08:32:00
2018-02-26 00:00:00 | [NAME] |  | Walmart | 18:01:00 | 18:10:00 |  | 18:25:00 | 07:33:00 |  | 08:00:00 | 08:07:00
2018-02-27 00:00:00 | [NAME] |  | Walmart | 18:02:00 | 18:09:00 |  | 18:27:00 | 06:45:00 |  | 07:08:00 | 07:18:00
2018-02-28 00:00:00 | [NAME] |  | Walmart | 18:00:00 | 18:18:00 |  | 18:27:00 | 06:52:00 |  | 07:16:00 | 07:23:00
2018-03-01 00:00:00 | [NAME] |  | Walmart | 17:49:00 | 17:58:00 |  | 18:09:00 | 06:23:00 |  | 06:44:00 | 06:57:00
2018-03-02 00:00:00 | [NAME] |  | Walmart | 18:03:00 |  |  |  |  |  |  | 12:55:00 | 00:00:00
 | Rocco Total |  |  |  |  |  |  |  |  |  |  |  |  | 36
2018-02-27 00:00:00 | Sergio |  | Vera | 05:46:00 | 08:09:00 |  | 08:36:00 | 10:19:00
2018-02-27 00:00:00 | Sergio |  | UCF Energy Plant |  |  |  | 11:17:00 | 13:25:00 |  | 13:53:00 | 14:12:00
2018-02-28 00:00:00 | Sergio |  | The Strand | 06:02:00 | 07:10:00 |  | 08:46:00 | 10:40:00 |  | 10:48:00 | 11:24:00
2018-03-01 00:00:00 | Sergio | 15 | Shop | 05:57:00 |  |  |  |  |  |  | 15:20:00 | 00:00:00
 | Sergio Total |  |  |  |  |  |  |  |  |  |  |  |  | 3
2018-02-25 00:00:00 | [NAME] |  | Walmart | 17:53:00 | 18:50:00 |  | 19:53:00 | 04:04:00 |  | 04:31:00 | 04:35:00
2018-02-26 00:00:00 | [NAME] |  | Walmart | 17:53:00 | 18:05:00 |  | 20:30:00 | 07:28:00 |  | 09:49:00 | 09:52:00
2018-02-27 00:00:00 | [NAME] |  | Walmart | 18:09:00 | 18:46:00 |  | 21:17:00 | 07:10:00 |  | 09:24:00 | 09:35:00
2018-02-28 00:00:00 | [NAME] |  | Walmart | 18:02:00 | 18:39:00 |  | 21:48:00 | 06:13:00 |  | 09:05:00 | 09:19:00
2018-03-01 00:00:00 | [NAME] |  | Walmart | 18:16:00 | 19:03:00 |  | 21:13:00 | 06:52:00 |  | 08:46:00 | 08:51:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 36
2018-02-25 00:00:00 | [NAME] | 8 | [NAME] | 19:04:00 | 19:28:00 |  | 22:30:00 | 04:09:00 |  | 06:18:00 | 07:22:00
2018-02-26 00:00:00 | [NAME] | 10 | Sadler | 18:25:00 | 18:37:00 |  | 21:22:00 | 04:08:00 |  | 06:30:00 | 06:45:00
2018-02-27 00:00:00 | [NAME] | 8 | [NAME] | 15:48:00 | 18:42:00 |  | 21:45:00 | 04:52:00 |  | 07:02:00 | 07:51:00
2018-02-28 00:00:00 | [NAME] | 8 | [NAME] | 17:25:00 | 18:46:00 |  | 21:08:00 | 05:14:00 |  | 07:16:00 | 07:48:00
2018-03-01 00:00:00 | [NAME] | 8 | [NAME] | 17:03:00 | 18:40:00 |  | 21:49:00 | 05:18:00 |  | 07:39:00 | 08:11:00
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 5
2018-02-25 00:00:00 | TJ | 8 | [NAME] | 19:04:00 | 19:28:00 |  | 22:30:00 | 04:09:00 |  | 06:18:00 | 07:22:00
2018-02-26 00:00:00 | TJ | 10 | Sadler | 18:25:00 | 18:37:00 |  | 21:22:00 | 04:08:00 |  | 06:30:00 | 06:45:00
2018-02-27 00:00:00 | TJ | 8 | [NAME] | 15:48:00 | 18:42:00 |  | 21:45:00 | 04:52:00 |  | 07:02:00 | 07:51:00
2018-02-28 00:00:00 | TJ | 8 | [NAME] | 17:25:00 | 18:46:00 |  | 21:08:00 | 05:14:00 |  | 07:16:00 | 07:48:00
2018-03-01 00:00:00 | TJ | 8 | [NAME] | 17:03:00 | 18:40:00 |  | 21:49:00 | 05:18:00 |  | 07:39:00 | 08:11:00
 | TJ Total |  |  |  |  |  |  |  |  |  |  |  |  | 5
2018-02-26 00:00:00 | Willie | 1 | Legacy | 06:00:00 | 09:49:00 |  | 11:23:00 | 13:04:00 |  | 14:09:00 | 14:13:00
2018-02-27 00:00:00 | Willie | 2 | Lot 5A Country Club | 06:13:00 | 06:16:00 |  | 06:56:00 | 07:51:00
2018-02-27 00:00:00 | Willie | 2 | Bainbridge |  |  |  | 08:57:00 | 12:31:00 |  | 13:16:00 | 15:00:00
2018-02-28 00:00:00 | Willie | 2 | Science One Ph 2 | 05:58:00 | 06:52:00 |  | 07:14:00 | 07:43:00
2018-02-28 00:00:00 | Willie | 2 | Park Ave |  |  |  | 08:30:00 | 11:46:00
2018-02-28 00:00:00 | Willie | 2 | The Strand |  |  |  | 12:34:00 | 14:03:00 |  | 14:11:00 | 15:00:00
2018-03-01 00:00:00 | Willie | 1 | Grande Lakes | 05:59:00 | 07:03:00 |  | 07:55:00 | 12:36:00 |  | 13:15:00 | 13:58:00
2018-03-02 00:00:00 | Willie | 2 | Publix | 05:58:00 | 06:15:00 |  | 07:26:00 | 13:12:00 |  | 13:26:00 | 14:30:00
 | Willie Total
2018-02-26 00:00:00 | [NAME] | 4 | Kids R Kids | 07:48:00 | 09:50:00 |  | 10:51:00 | 14:12:00 |  | 14:30:00 | 14:30:00
2018-02-27 00:00:00 | [NAME] | 4 | Maudlin | 05:45:00 | 07:15:00 |  | 08:39:00 | 11:23:00 |  | 14:23:00 | 14:35:00
2018-02-28 00:00:00 | [NAME] |  | The Strand | 06:00:00 | 07:10:00 |  | 08:46:00 | 10:40:00 |  | 10:48:00 | 11:00:00
 | Willie S Total
 | Grand Total