Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 04082018-04142018

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
2018-04-09 00:00:00 | [NAME] |  | [NAME] | 05:28:00 | 07:07:00 |  | 08:11:00 | 11:18:00 |  |  |  |  |  | 8
2018-04-09 00:00:00 | [NAME] |  | Sunrise |  |  |  | 12:26:00 | 15:12:00 |  | 15:58:00 | 16:10:00 |  |  | 2
2018-04-10 00:00:00 | [NAME] |  | LNS | 06:25:00 | 06:44:00 |  | 07:59:00 | 13:08:00 |  | 13:36:00 | 14:14:00 |  |  | 5
2018-04-11 00:00:00 | [NAME] |  | Meadow Woods | 05:38:00 | 06:48:00 |  | 07:42:00 | 14:35:00 |  |  |  |  |  | 3
2018-04-11 00:00:00 | [NAME] |  | LNS |  |  |  | 15:20:00 | 16:24:00 |  | 17:03:00 | 17:06:00 |  |  | 5
2018-04-12 00:00:00 | [NAME] |  | Fountain Park | 05:42:00 | 06:35:00 |  | 06:57:00 | 08:16:00 |  |  |  |  |  | 2
2018-04-12 00:00:00 | [NAME] |  | Ashton Station |  |  |  | 10:28:00 | 18:50:00 |  | 19:18:00 | 19:21:00 |  |  | 1
2018-04-13 00:00:00 | [NAME] |  | LNS | 05:39:00 | 07:24:00 |  | 08:15:00 | 13:07:00 |  | 13:13:00 | 14:24:00 | 00:00:00 |  | 8
 | Allen Total
2018-04-08 00:00:00 | [NAME] |  | Walmart Durbin | 18:39:00 |  | 00:00:00 |  |  |  |  | 20:26:00 | 00:00:00
2018-04-10 00:00:00 | [NAME] |  | Walmart Durbin | 03:23:00 | 03:31:00 |  | 09:48:00 | 13:17:00 |  | 13:55:00 | 14:08:00 |  |  | 40
2018-04-11 00:00:00 | [NAME] |  | Siemans | 06:05:00 | 07:06:00 |  | 08:27:00 | 12:19:00 |  | 13:35:00 | 14:28:00 |  |  | 4
2018-04-12 00:00:00 | [NAME] |  | Walmart Durbin | 07:39:00 | 08:05:00 |  | 09:23:00 | 15:53:00 |  | 16:00:00 | 16:09:00
2018-04-13 00:00:00 | [NAME] |  | Walmart Durbin | 07:42:00 | 08:05:00 |  | 09:23:00 | 15:53:00 |  | 16:00:00 | 16:24:00
 | [NAME]
2018-04-09 00:00:00 | [NAME] |  | [NAME] | 05:57:00 | 07:08:00 |  | 08:11:00 | 11:16:00 |  |  |  |  |  | 8
2018-04-09 00:00:00 | [NAME] |  | Sunrise |  |  |  | 12:26:00 | 15:12:00 |  | 15:54:00 | 16:14:00 |  |  | 2
2018-04-10 00:00:00 | [NAME] |  | Centre Point | 05:56:00 | 06:42:00 |  | 07:22:00 | 13:19:00 |  | 14:22:00 | 17:07:00 | 00:00:00 |  | 4
2018-04-11 00:00:00 | [NAME] |  | Bainbridge | 09:08:00 | 09:17:00 |  | 10:11:00 | 14:30:00 |  | 15:04:00 | 16:29:00 | 00:00:00 |  | 8
2018-04-12 00:00:00 | [NAME] |  | Bainbridge | 06:03:00 | 07:43:00 |  | 09:18:00 | 14:12:00 |  | 14:43:00 | 17:14:00 | 00:00:00 |  | 8
2018-04-13 00:00:00 | [NAME] |  | Walgreens | 06:02:00 |  | 00:00:00 |  |  |  |  | 16:44:00 | 00:00:00 |  | 4
 | [NAME]
2018-04-09 00:00:00 | [NAME] |  | [NAME] | 06:00:00 | 07:07:00 |  | 08:11:00 | 11:18:00 |  |  |  |  |  | 8
2018-04-09 00:00:00 | [NAME] |  | Sunrise |  |  |  | 12:26:00 | 15:12:00 |  | 15:58:00 | 16:15:00 |  |  | 2
2018-04-10 00:00:00 | [NAME] |  | LNS | 06:01:00 | 06:44:00 |  | 07:59:00 | 13:08:00 |  | 13:36:00 | 15:21:00 | 00:00:00 |  | 5
2018-04-11 00:00:00 | [NAME] |  | Meadow Woods | 06:02:00 | 06:48:00 |  | 07:42:00 | 14:35:00 |  |  |  |  |  | 3
2018-04-11 00:00:00 | [NAME] |  | LNS |  |  |  | 15:20:00 | 16:24:00 |  | 17:03:00 | 17:28:00 |  |  | 5
2018-04-12 00:00:00 | [NAME] |  | Fountain Park | 06:00:00 | 06:35:00 |  | 06:57:00 | 08:16:00 |  |  |  |  |  | 2
2018-04-12 00:00:00 | [NAME] |  | Ashton Station |  |  |  | 10:28:00 | 18:50:00 |  | 19:18:00 | 19:44:00 |  |  | 1
2018-04-13 00:00:00 | [NAME] |  | LNS | 06:03:00 | 07:24:00 |  | 08:15:00 | 13:07:00 |  | 13:13:00 | 14:44:00 | 00:00:00 |  | 8
2018-04-14 00:00:00 | [NAME] |  | Longwood | 06:01:00 | 06:32:00 |  | 07:53:00 | 16:08:00 |  | 16:41:00 | 16:57:00 |  |  | 9
 | [NAME]
2018-04-08 00:00:00 | [NAME] |  | Walmart | 17:59:00 | 18:18:00 |  |  |  |  | 06:52:00 | 06:57:00
2018-04-09 00:00:00 | [NAME] |  | Walmart | 21:04:00 | 21:16:00 |  | 21:58:00 | 08:05:00 |  | 08:18:00 | 08:57:00 |  |  | 36
2018-04-10 00:00:00 | [NAME] |  | Walmart | 19:01:00 | 19:18:00 |  | 20:00:00 | 07:37:00 |  | 07:48:00 | 08:01:00
2018-04-11 00:00:00 | [NAME] |  | Walmart | 18:02:00 | 18:07:00 |  | 18:50:00 | 07:40:00 |  | 07:54:00 | 08:20:00
2018-04-12 00:00:00 | [NAME] |  | Walmart | 16:30:00 | 16:44:00 |  | 16:56:00 | 05:27:00 |  | 14:07:00 | 14:32:00
 | Brandon Total
2018-04-09 00:00:00 | Dwayne |  | PDQ | 05:47:00 | 06:30:00 |  | 07:26:00 | 08:55:00 |  |  |  |  | 1 | 1
2018-04-09 00:00:00 | Dwayne |  | Epcot |  |  |  | 09:47:00 | 11:54:00 |  | 13:02:00 | 13:54:00 |  |  | 8
2018-04-10 00:00:00 | Dwayne |  | Ponderosa | 05:42:00 | 06:05:00 |  | 07:17:00 | 07:55:00 |  |  |  |  | 1 | 2.5
2018-04-10 00:00:00 | Dwayne |  | Sherwin |  |  |  | 08:30:00 | 10:44:00 |  | 11:36:00 | 11:55:00 |  |  | 3
2018-04-11 00:00:00 | Dwayne |  | Meadow Woods | 05:42:00 | 06:10:00 |  | 07:15:00 | 14:23:00 |  |  |  |  |  | 3
2018-04-11 00:00:00 | Dwayne |  | LNS |  |  |  | 14:49:00 | 16:03:00 |  | 16:39:00 | 16:43:00 |  |  | 5
2018-04-12 00:00:00 | Dwayne |  | Eber Cove | 05:43:00 | 06:56:00 |  | 08:56:00 | 15:48:00 |  | 17:08:00 | 17:13:00 |  |  | 8
2018-04-13 00:00:00 | Dwayne |  | Eber Cove | 05:37:00 | 06:42:00 |  | 08:47:00 | 15:59:00 |  | 17:20:00 | 17:25:00 |  |  | 8
 | [NAME]
2018-04-09 00:00:00 | Edgar |  | Sherwin | 05:58:00 | 09:15:00 | 00:00:00 | 09:15:00 | 10:52:00 |  |  |  |  |  | 2
2018-04-09 00:00:00 | Edgar |  | Sherwin |  |  |  | 11:26:00 | 12:42:00 |  | 14:00:00 | 14:35:00 |  |  | 2
2018-04-10 00:00:00 | Edgar |  | Centre Point | 06:00:00 | 06:42:00 |  | 07:22:00 | 13:19:00 |  | 14:22:00 | 15:15:00 | 00:00:00 |  | 4
2018-04-11 00:00:00 | Edgar |  | Bainbridge | 05:56:00 | 07:34:00 |  | 08:38:00 | 14:30:00 |  | 15:04:00 | 16:30:00 | 00:00:00 |  | 8
2018-04-12 00:00:00 | Edgar |  | SC | 11:59:00 | 12:31:00 |  | 20:35:00 | 07:53:00 |  | 16:07:00 | 16:24:00 |  |  | 6
 | [NAME]
2018-04-11 00:00:00 | Efrain |  | Walmart | 20:10:00 | 18:44:00 | 00:00:00 | 21:17:00 | 05:13:00 |  | 07:19:00 | 06:53:00 | 00:00:00
2018-04-12 00:00:00 | Efrain |  | Walmart | 22:00:00 | 20:22:00 | 00:00:00 | 23:22:00 | 04:44:00 |  | 06:33:00 | 07:10:00
 | Efrain Total
2018-04-09 00:00:00 | Javarious |  | Epcot | 06:11:00 | 08:50:00 |  | 10:30:00 | 12:03:00 |  | 14:32:00 | 14:57:00 |  |  | 8
2018-04-10 00:00:00 | Javarious |  | Walmart Dubin | 06:00:00 | 07:42:00 |  | 11:20:00 | 12:51:00 |  | 15:08:00 | 15:13:00 |  |  | 8
2018-04-11 00:00:00 | Javarious |  | Walmart Dubin | 06:00:00 | 06:44:00 |  | 08:54:00 | 14:57:00 |  | 17:00:00 | 17:15:00
2018-04-12 00:00:00 | Javarious |  | Ashton Station | 06:00:00 | 07:28:00 |  | 08:16:00 | 10:51:00 |  | 11:26:00 | 13:30:00 | 00:00:00 |  | 1
2018-04-13 00:00:00 | Javarious |  | Eber Cove | 06:00:00 | 06:42:00 |  | 08:47:00 | 15:59:00 |  | 17:20:00 | 17:45:00 |  |  | 8
 | Javarious Total
2018-04-10 00:00:00 | [NAME] |  | shop | 06:00:00 |  | 00:00:00 |  |  |  |  | 20:22:00 | 00:00:00
2018-04-11 00:00:00 | [NAME] |  |  | 06:27:00 |  | 00:00:00 |  |  |  |  | 13:36:00 | 00:00:00
2018-04-12 00:00:00 | [NAME] |  | shop | 06:02:00 |  | 00:00:00 |  |  |  |  | 21:56:00 | 00:00:00
2018-04-13 00:00:00 | [NAME] |  |  | 1900-01-06 00:00:00 |  |  |  |  |  |  | 12:50:00 | 00:00:00
 | [NAME]
2018-04-09 00:00:00 | [NAME] |  | Sherwin | 05:46:00 | 09:15:00 | 00:00:00 | 09:15:00 | 10:52:00 |  |  |  |  |  | 2
2018-04-09 00:00:00 | [NAME] |  | Sherwin |  |  |  | 11:26:00 | 12:42:00 |  | 14:00:00 | 14:55:00 |  |  | 2
2018-04-10 00:00:00 | [NAME] |  | Centre Point | 05:45:00 | 06:42:00 |  | 07:22:00 | 13:19:00 |  | 14:22:00 | 15:20:00 | 00:00:00
2018-04-11 00:00:00 | [NAME] |  | Bainbridge | 05:44:00 | 07:34:00 |  | 08:38:00 | 14:30:00 |  | 15:04:00 | 16:30:00 | 00:00:00 |  | 8
2018-04-12 00:00:00 | [NAME] |  | Fountain Park | 05:45:00 | 06:35:00 |  | 06:57:00 | 08:16:00
2018-04-12 00:00:00 | [NAME] |  | Ashton Station |  |  |  | 10:28:00 | 18:50:00 |  | 19:18:00 | 19:26:00 |  |  | 8
2018-04-13 00:00:00 | [NAME] |  | Eber Cove | 05:45:00 | 06:42:00 |  | 08:47:00 | 15:59:00 |  | 17:20:00 | 17:45:00 |  |  | 8
2018-04-14 00:00:00 | [NAME] |  | Longwood | 06:02:00 | 06:32:00 |  | 07:53:00 | 16:08:00 |  | 16:41:00 | 16:47:00 |  |  | 9
 | [NAME]
2018-04-09 00:00:00 | Kenny |  | Walmart Deland | 05:45:00 | 07:18:00 |  | 11:41:00 | 13:55:00 |  | 14:35:00 | 16:14:00 | 00:00:00 |  | 2.5
2018-04-10 00:00:00 | Kenny |  | Walmart Dubin | 05:45:00 | 07:31:00 |  | 11:20:00 | 12:51:00 |  | 15:22:00 | 16:06:00 |  |  | 8
2018-04-11 00:00:00 | Kenny |  | Walmart Dubin | 06:00:00 | 06:50:00 |  | 09:17:00 | 16:12:00 |  | 18:13:00 | 18:00:00 | 00:00:00
2018-04-12 00:00:00 | Kenny |  | Bainbridge | 05:45:00 | 07:43:00 |  | 09:10:00 | 16:17:00 |  | 17:14:00 | 17:00:00 | 00:00:00 |  | 8
2018-04-13 00:00:00 | Kenny |  | West Livingston | 05:40:00 | 07:24:00 |  | 08:58:00 | 11:33:00 |  | 12:08:00 | 14:21:00 | 00:00:00 |  | 3
2018-04-14 00:00:00 | Kenny |  | Longwood | 06:00:00 | 06:32:00 |  | 07:53:00 | 16:08:00 |  | 16:41:00 | 16:30:00 | 00:00:00 |  | 9
 | Kenny Total
2018-04-09 00:00:00 | Lindsey |  | PDQ | 05:51:00 | 06:30:00 |  | 07:26:00 | 08:55:00 |  |  |  |  |  | 1
2018-04-09 00:00:00 | Lindsey |  | Epcot |  |  |  | 09:47:00 | 11:54:00 |  | 13:02:00 | 14:31:00 | 00:00:00 |  | 8
2018-04-10 00:00:00 | Lindsey |  | Ponderosa | 05:50:00 | 06:05:00 |  | 07:17:00 | 07:55:00 |  |  |  |  |  | 2.5
2018-04-10 00:00:00 | Lindsey |  | Sherwin |  |  |  | 08:30:00 | 10:44:00 |  | 11:36:00 | 12:12:00 |  |  | 3
2018-04-11 00:00:00 | Lindsey |  | Meadow Woods | 05:50:00 | 06:10:00 |  | 07:15:00 | 14:23:00 |  |  |  |  |  | 3
2018-04-11 00:00:00 | Lindsey |  | LNS |  |  |  | 14:49:00 | 16:03:00 |  | 16:39:00 | 16:46:00 |  |  | 5
2018-04-12 00:00:00 | Lindsey |  | Eber Cove | 05:50:00 | 06:56:00 |  | 08:56:00 | 15:48:00 |  | 17:08:00 | 17:14:00 |  |  | 8
2018-04-13 00:00:00 | Lindsey |  | Eber Cove | 05:50:00 | 06:42:00 |  | 08:47:00 | 15:59:00 |  | 17:20:00 | 17:27:00 |  |  | 8
 | Lindsey Total
2018-04-08 00:00:00 | Logan |  | Walmart | 18:25:00 |  | 00:00:00 |  |  |  |  | 18:29:00 | 00:00:00
2018-04-11 00:00:00 | Logan |  | Walmart | 18:12:00 | 19:27:00 |  | 20:51:00 | 05:10:00 |  | 05:58:00 | 06:07:00
2018-04-12 00:00:00 | Logan |  | Walmart | 20:04:00 | 20:20:00 |  | 22:16:00 | 08:10:00 |  | 09:24:00 | 11:25:00
 | Logan Total
2018-04-09 00:00:00 | Nick |  | Sherwin | 06:03:00 | 09:15:00 | 00:00:00 | 09:15:00 | 10:52:00 |  |  |  |  |  | 2
2018-04-09 00:00:00 | Nick |  | Sherwin |  |  |  | 11:26:00 | 12:42:00 |  | 14:00:00 | 14:43:00 |  |  | 2
2018-04-10 00:00:00 | Nick |  | Centre Point | 06:05:00 | 06:42:00 |  | 07:22:00 | 13:19:00 |  | 14:22:00 | 15:19:00 | 00:00:00 |  | 4
2018-04-11 00:00:00 | Nick |  | Bainbridge | 06:01:00 | 07:34:00 |  | 08:38:00 | 14:30:00 |  | 15:04:00 | 16:22:00 | 00:00:00 |  | 8
2018-04-12 00:00:00 | Nick |  | SC | 12:12:00 | 12:31:00 |  | 20:35:00 | 07:53:00 |  | 16:07:00 | 16:17:00 |  |  | 6
 | Nick Total
2018-04-11 00:00:00 | Ricky |  | Walmart | 18:18:00 | 19:27:00 |  | 20:51:00 | 05:10:00 |  | 05:58:00 | 06:07:00
2018-04-12 00:00:00 | Ricky |  | Walmart | 20:04:00 | 20:20:00 |  | 22:16:00 | 08:10:00 |  | 09:24:00 | 11:25:00
 | Ricky Total
2018-04-08 00:00:00 | [NAME] |  | Walmart | 18:00:00 | 18:18:00 |  |  |  |  | 06:52:00 | 06:56:00 | 00:00:00
2018-04-09 00:00:00 | [NAME] |  | Walmart | 21:04:00 | 21:16:00 |  | 21:58:00 | 08:05:00 |  | 08:18:00 | 08:47:00 |  |  | 36
2018-04-10 00:00:00 | [NAME] |  | Walmart | 19:00:00 | 19:18:00 |  | 20:00:00 | 07:37:00 |  | 07:48:00 | 08:00:00
2018-04-11 00:00:00 | [NAME] |  | Walmart | 18:01:00 | 18:07:00 |  | 18:50:00 | 07:40:00 |  | 07:54:00 | 08:02:00
2018-04-12 00:00:00 | [NAME] |  | Walmart | 16:29:00 | 16:44:00 |  | 16:56:00 | 05:27:00 |  | 14:07:00 | 14:32:00
 | Rocco Total
2018-04-09 00:00:00 | Sergio |  | Epcot | 05:40:00 | 08:50:00 |  | 10:30:00 | 12:03:00 |  | 14:32:00 | 15:05:00 |  |  | 8
2018-04-10 00:00:00 | Sergio |  | Walmart Dubin | 05:56:00 | 07:42:00 |  | 11:20:00 | 12:51:00 |  | 15:08:00 | 16:08:00 |  |  | 8
2018-04-12 00:00:00 | Sergio |  | Bainbridge | 06:05:00 | 07:43:00 |  | 09:10:00 | 16:17:00 |  | 17:14:00 | 17:30:00 |  |  | 8 | 1
2018-04-13 00:00:00 | Sergio |  | West Livingston | 06:10:00 | 07:24:00 |  | 08:58:00 | 11:33:00 |  | 12:08:00 | 13:53:00 | 00:00:00 |  | 3
 | Sergio Total
2018-04-09 00:00:00 | [NAME] |  | Walmart | 18:12:00 | 19:00:00 |  | 21:47:00 | 04:53:00 |  | 06:24:00 | 06:50:00 |  |  | 36
2018-04-11 00:00:00 | [NAME] |  | Walmart | 18:09:00 | 18:44:00 |  | 21:17:00 | 05:13:00 |  | 07:19:00 | 07:23:00
2018-04-12 00:00:00 | [NAME] |  | Walmart | 18:03:00 | 20:22:00 |  | 23:22:00 | 04:44:00 |  | 06:33:00 | 06:40:00
 | [NAME]
2018-04-11 00:00:00 | [NAME] |  | Walmart | 16:17:00 | 19:27:00 |  | 20:51:00 | 05:10:00 |  | 05:58:00 | 06:15:00
2018-04-12 00:00:00 | [NAME] |  | Walmart | 18:48:00 | 20:20:00 |  | 22:16:00 | 08:10:00 |  | 09:24:00 | 11:25:00
2018-04-13 00:00:00 | [NAME] |  | Walmart | 19:43:00 |  | 00:00:00 |  |  |  |  | 00:00:00
 | [NAME]
2018-04-09 00:00:00 | TJ |  | Walmart Deland | 05:57:00 | 07:18:00 |  | 11:41:00 | 13:55:00 |  | 14:35:00 | 16:00:00 | 00:00:00 |  | 2.5
2018-04-10 00:00:00 | TJ |  | Walmart Dubin | 05:56:00 | 07:31:00 |  | 11:20:00 | 12:51:00 |  | 15:22:00 | 16:05:00 |  |  | 8
2018-04-11 00:00:00 | TJ |  | Walmart Dubin | 05:59:00 | 06:50:00 |  | 09:17:00 | 16:12:00 |  | 18:13:00 | 18:24:00
2018-04-12 00:00:00 | TJ |  | Bainbridge | 06:00:00 |  | 00:00:00 |  |  |  |  | 15:42:00 | 00:00:00 |  | 8
2018-04-13 00:00:00 | TJ |  | Shop | 06:11:00 |  | 00:00:00 |  |  |  |  | 14:03:00 | 00:00:00
 | TJ Total
2018-04-09 00:00:00 | Willie |  | [NAME] | 05:56:00 | 07:08:00 |  | 08:11:00 | 11:16:00 |  |  |  |  |  | 8
2018-04-09 00:00:00 | Willie |  | Sunrise |  |  |  | 12:26:00 | 15:12:00 |  | 15:54:00 | 16:01:00 |  |  | 2
2018-04-11 00:00:00 | Willie |  | Bainbridge | 05:54:00 | 07:34:00 |  | 08:38:00 | 14:30:00 |  | 15:04:00 | 15:00:00 | 00:00:00 |  | 8
2018-04-12 00:00:00 | Willie |  | Bainbridge | 05:43:00 | 07:43:00 |  | 09:18:00 | 14:12:00 |  | 14:43:00 | 14:10:00 | 00:00:00 |  | 8
2018-04-13 00:00:00 | Willie |  | Walgreens | 05:47:00 |  | 00:00:00 |  |  |  |  | 16:42:00 | 00:00:00 |  | 4 | 1
 | Willie Total
2018-04-09 00:00:00 | [NAME] |  | The Strand | 06:00:00 | 07:36:00 |  | 07:51:00 | 08:02:00 |  | 08:21:00 | 09:00:00 |  |  | 1 | 2
2018-04-11 00:00:00 | [NAME] |  | Walmart Dubin | 05:45:00 | 06:44:00 |  | 08:54:00 | 14:57:00 |  | 17:00:00 | 17:30:00
2018-04-12 00:00:00 | [NAME] |  | Ashton Station | 06:00:00 | 07:28:00 |  | 08:16:00 | 10:51:00 |  | 11:26:00 | 12:30:00 |  |  | 1
 | Willie S Total
 | Grand Total