Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 04012018-04072018

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-02 00:00:00 | [NAME] | 1 | Field Motorcar Orlando | 08:03:00 | 08:19:00 |  | 10:20:00 | 12:24:00 |  | 13:11:00 | 15:00:00 |  |  | 8
2018-04-02 00:00:00 | [NAME] |  | Sunrise City Plaza | 17:00:00 | 18:34:00 |  | 19:55:00 | 20:14:00 |  | 21:00:00 | 21:03:00 |  |  | 4
2018-04-03 00:00:00 | [NAME] | 1 | Orange Ave Storage | 05:53:00 | 07:01:00 |  | 08:19:00 | 13:48:00 |  | 14:26:00 | 14:29:00 |  |  | 6
2018-04-04 00:00:00 | [NAME] |  | Princeton Oaks | 05:41:00 | 07:34:00 |  | 08:38:00 | 09:23:00 |  |  |  |  |  | 1
2018-04-04 00:00:00 | [NAME] |  | AIPO |  |  |  | 10:10:00 | 14:50:00 |  | 15:36:00 | 15:50:00 |  |  | 4.5
2018-04-05 00:00:00 | [NAME] |  | Golf Channel | 05:43:00 | 08:06:00 |  | 09:00:00 | 13:50:00 |  | 14:30:00 | 14:44:00 |  |  | 4.5
2018-04-06 00:00:00 | [NAME] |  |  | 05:41:00 |  | 00:00:00 |  |  |  |  | 14:56:00 | 00:00:00
 | Allen Total
2018-04-02 00:00:00 | [NAME] |  | Bells | 18:39:00 | 19:56:00 |  | 20:16:00 | 03:29:00 |  | 03:46:00 | 04:48:00 |  |  | 8
2018-04-03 00:00:00 | [NAME] |  | Target | 19:01:00 | 19:40:00 |  | 19:55:00 | 00:08:00 |  | 00:14:00 | 01:06:00 |  |  | 8
2018-04-04 00:00:00 | [NAME] |  | I-295 | 19:19:00 | 20:24:00 |  | 20:52:00 | 23:36:00 |  | 00:02:00 | 00:50:00 |  |  | 8
2018-04-05 00:00:00 | [NAME] |  | I-295 | 19:10:00 | 19:35:00 |  | 19:44:00 | 04:59:00 |  | 05:05:00 | 05:14:00 |  |  | 8
 | [NAME]
2018-04-03 00:00:00 | [NAME] |  | ? | 06:01:00 |  | 00:00:00 |  |  |  |  | 15:23:00 | 00:00:00
2018-04-04 00:00:00 | [NAME] |  | Orange Ave | 05:56:00 | 06:43:00 |  | 08:08:00 | 15:09:00 |  | 16:06:00 | 16:45:00 |  |  | 3
2018-04-05 00:00:00 | [NAME] |  | [NAME] | 05:57:00 | 07:07:00 |  | 07:58:00 | 09:22:00 |  |  |  |  |  | 8
2018-04-05 00:00:00 | [NAME] |  | [NAME] |  |  |  | 10:12:00 | 12:48:00 |  | 13:26:00 | 16:54:00 | 00:00:00 |  | 8
2018-04-06 00:00:00 | [NAME] |  | Firestation 62 | 06:01:00 | 06:43:00 |  | 08:07:00 | 09:15:00 |  |  |  |  |  | 1.5
2018-04-06 00:00:00 | [NAME] |  | Maitland City |  |  |  | 09:50:00 | 10:48:00 |  |  |  |  |  | 8
2018-04-06 00:00:00 | [NAME] |  | Epcot France |  |  |  | 11:36:00 | 13:11:00 |  | 13:57:00 | 15:43:00 | 00:00:00 |  | 8 | 1
 | [NAME]
2018-04-02 00:00:00 | [NAME] | 6 | Ridgewood Lakes | 05:49:00 | 06:32:00 |  | 08:07:00 | 15:09:00 |  | 16:34:00 | 16:39:00 |  |  | 8 | 1
2018-04-03 00:00:00 | [NAME] | 6 | Bayou Pass | 05:50:00 | 06:55:00 |  | 09:26:00 | 09:51:00 |  |  |  |  |  | 8
2018-04-03 00:00:00 | [NAME] |  | Ridgewood Lakes |  |  |  | 12:33:00 | 12:58:00 |  | 14:04:00 | 14:19:00 |  |  | 8
2018-04-06 00:00:00 | [NAME] |  | [NAME] | 05:51:00 | 06:51:00 |  | 08:23:00 | 14:58:00 |  | 15:32:00 | 15:41:00 |  |  | 4
 | Anthony Total
2018-04-02 00:00:00 | [NAME] | 1 | Field Motorcar Orlando | 07:11:00 | 08:19:00 |  | 10:20:00 | 12:24:00 |  | 13:11:00 | 15:00:00 | 00:00:00 |  | 8
2018-04-02 00:00:00 | [NAME] |  | Sunrise City Plaza | 17:00:00 | 18:34:00 |  | 19:55:00 | 20:14:00 |  | 21:00:00 | 21:03:00 |  |  | 8
2018-04-03 00:00:00 | [NAME] | 1 | Orange Ave Storage | 06:00:00 | 07:01:00 |  | 08:19:00 | 13:48:00 |  | 14:26:00 | 15:21:00 |  |  | 3
2018-04-03 00:00:00 | [NAME] |  | Sunrise City Plaza | 18:55:00 | 19:00:00 |  | 20:02:00 | 21:08:00 |  | 21:49:00 | 22:22:00 |  |  | 8
2018-04-04 00:00:00 | [NAME] |  | Princeton Oaks | 06:00:00 | 07:34:00 |  | 08:38:00 | 09:23:00 |  |  |  |  |  | 1
2018-04-04 00:00:00 | [NAME] |  | AIPO |  |  |  | 10:10:00 | 14:50:00 |  | 15:36:00 | 15:50:00 |  |  | 2
2018-04-05 00:00:00 | [NAME] |  | Golf Channel | 08:00:00 | 08:06:00 |  | 09:00:00 | 13:50:00 |  | 14:30:00 | 16:47:00 | 00:00:00 |  | 3
2018-04-06 00:00:00 | [NAME] |  |  | 06:07:00 |  | 00:00:00 |  |  |  |  | 17:26:00 | 00:00:00
2018-04-07 00:00:00 | [NAME] |  | [NAME] | 08:30:00 | 08:44:00 |  | 09:40:00 | 13:01:00 |  | 13:32:00 | 14:57:00 | 00:00:00 |  | 2
 | [NAME]
2018-04-01 00:00:00 | [NAME] |  | Walmart | 18:06:00 | 18:44:00 |  | 19:58:00 | 04:39:00 |  | 05:22:00 | 05:27:00 |  |  | 24
2018-04-02 00:00:00 | [NAME] |  | Walmart | 20:17:00 | 20:27:00 |  | 21:38:00 | 21:49:00 |  | 22:31:00 | 23:40:00 |  |  | 24
2018-04-03 00:00:00 | [NAME] |  | Walmart | 18:00:00 | 18:47:00 |  | 19:56:00 | 05:26:00 |  | 06:09:00 | 06:15:00
2018-04-04 00:00:00 | [NAME] |  | Walmart | 18:21:00 | 19:12:00 |  | 20:40:00 | 06:10:00 |  | 06:55:00 | 07:38:00
2018-04-05 00:00:00 | [NAME] |  | Walmart | 18:12:00 | 18:21:00 |  | 19:44:00 | 04:40:00 |  | 05:23:00 | 05:28:00
 | Brandon Total
 | Dwayne |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation
 | [NAME]
2018-04-02 00:00:00 | Edgar | 8 | Grande Lakes Multi | 05:56:00 | 07:00:00 |  | 08:34:00 | 13:54:00 |  | 15:09:00 | 15:49:00 |  |  | 8
2018-04-03 00:00:00 | Edgar | 8 | Grande Lakes Multi | 06:00:00 | 07:42:00 |  | 08:56:00 | 13:38:00 |  | 14:17:00 | 15:33:00 |  |  | 8
2018-04-04 00:00:00 | Edgar |  | [NAME] | 06:00:00 | 06:17:00 |  | 07:18:00 | 11:23:00 |  |  |  |  |  | 8
2018-04-04 00:00:00 | Edgar |  | Olive Garden |  |  |  | 13:40:00 | 20:33:00 |  | 04:25:00 | 04:26:00 |  |  | 8
2018-04-05 00:00:00 | Edgar |  | Olive Garden | 08:50:00 |  | 00:00:00 |  |  |  |  | 15:37:00 | 00:00:00
2018-04-06 00:00:00 | Edgar |  | [NAME] | 06:00:00 |  | 00:00:00 |  |  |  |  | 16:52:00 | 00:00:00 |  | 8
 | [NAME]
2018-04-01 00:00:00 | Efrain |  | Walmart | 20:25:00 | 19:53:00 | 00:00:00 | 20:52:00 | 04:43:00 |  | 05:23:00 | 05:32:00 |  |  | 1900-01-24 00:00:00
2018-04-02 00:00:00 | Efrain |  | Walmart | 18:19:00 | 18:51:00 |  | 21:48:00 | 03:26:00 |  | 05:30:00 | 05:34:00 |  |  | 24
2018-04-03 00:00:00 | Efrain |  | Walmart | 17:47:00 | 19:24:00 |  | 20:45:00 | 05:00:00 |  | 05:08:00 | 05:16:00
2018-04-04 00:00:00 | Efrain |  | Walmart | 18:18:00 | 19:30:00 |  | 21:47:00 | 06:45:00 |  | 09:22:00 | 09:28:00
2018-04-05 00:00:00 | Efrain |  | Walmart | 18:00:00 | 18:23:00 |  | 20:45:00 | 06:07:00 |  | 07:50:00 | 08:42:00
 | Efrain Total
2018-04-05 00:00:00 | Javarious |  | Golf Channel | 06:10:00 | 08:06:00 |  | 09:00:00 | 13:50:00 |  | 14:30:00 | 16:50:00 | 00:00:00 |  | 3
2018-04-06 00:00:00 | Javarious |  | Maitland City | 06:01:00 | 06:43:00 |  | 08:07:00 | 09:15:00 |  |  |  |  |  | 8
2018-04-06 00:00:00 | Javarious |  | Firestation 62 |  |  |  | 11:36:00 | 13:11:00 |  | 13:57:00 | 15:41:00 | 00:00:00 |  | 1.5
 | Javarious Total
2018-04-02 00:00:00 | [NAME] |  | shop | 07:01:00 |  | 00:00:00 |  |  |  |  | 17:49:00 | 00:00:00
2018-04-03 00:00:00 | [NAME] |  | shop | 06:00:00 |  | 00:00:00 |  |  |  |  | 15:38:00 | 00:00:00
2018-04-04 00:00:00 | [NAME] |  | I-295 | 20:16:00 | 20:24:00 |  | 20:52:00 | 23:36:00 |  | 00:02:00 | 00:04:00 |  |  | 8
2018-04-05 00:00:00 | [NAME] |  | I-295 | 19:34:00 | 19:35:00 |  | 19:44:00 | 04:59:00 |  | 05:05:00 | 05:13:00 |  |  | 8
 | [NAME]
2018-04-03 00:00:00 | [NAME] | 6 | Grande Lakes Multi | 05:50:00 | 06:55:00 |  | 08:56:00 | 13:38:00 |  | 14:17:00 | 15:27:00 |  |  | 8
2018-04-03 00:00:00 | [NAME] | 6 | Epcot France | 05:50:00 | 06:55:00 |  | 08:56:00 | 13:38:00 |  | 14:17:00 | 15:27:00 |  |  | 8
2018-04-04 00:00:00 | [NAME] |  | France BOA | 05:46:00 | 07:29:00 |  | 09:15:00 | 10:04:00 |  |  |  |  |  | 8
2018-04-04 00:00:00 | [NAME] |  | Fish Memorial | 05:46:00 |  |  | 11:21:00 | 16:31:00 |  | 18:14:00 | 18:26:00 |  |  | 8
2018-04-05 00:00:00 | [NAME] |  | The Strand | 05:45:00 | 08:06:00 |  | 08:47:00 | 14:43:00 |  | 14:55:00 | 16:19:00 | 00:00:00 |  | 1
2018-04-06 00:00:00 | [NAME] |  | [NAME] | 05:35:00 |  | 00:00:00 |  |  |  |  | 17:24:00 | 00:00:00 |  | 8
2018-04-07 00:00:00 | [NAME] |  | [NAME] | 08:12:00 | 08:44:00 |  | 09:40:00 | 13:01:00 |  | 13:32:00 | 14:57:00 | 00:00:00 |  | 2
 | [NAME]
2018-04-02 00:00:00 | Lindsey |  | shop | 05:50:00 |  |  |  |  |  |  | 16:41:00 | 00:00:00
2018-04-03 00:00:00 | Lindsey | 15 | Epcot France | 05:50:00 | 07:49:00 |  | 09:42:00 | 12:39:00 |  | 13:18:00 | 14:36:00 |  |  | 4
2018-04-04 00:00:00 | Lindsey |  | France BOA | 05:50:00 | 07:29:00 |  | 09:15:00 | 10:04:00 |  |  |  |  |  | 4
2018-04-04 00:00:00 | Lindsey |  | Fish Memorial | 05:50:00 |  |  | 11:21:00 | 16:31:00 |  | 18:14:00 | 18:30:00 |  |  | 8
2018-04-05 00:00:00 | Lindsey |  | The Strand | 05:50:00 | 08:06:00 |  | 08:47:00 | 14:43:00 |  | 14:55:00 | 16:30:00 | 00:00:00 |  | 1 | 1
 | Lindsey Total
2018-04-01 00:00:00 | Logan |  | Walmart | 20:30:00 | 20:35:00 |  | 23:44:00 | 07:19:00 |  | 09:30:00 | 09:57:00 |  |  | 24
2018-04-02 00:00:00 | Logan |  | Walmart | 17:12:00 | 19:34:00 |  | 22:14:00 | 03:31:00 |  | 05:40:00 | 06:47:00 |  |  | 24
2018-04-03 00:00:00 | Logan |  | Walmart | 18:30:00 | 19:58:00 |  | 22:53:00 | 05:02:00 |  | 05:08:00 | 05:18:00
2018-04-05 00:00:00 | Logan |  | Walmart | 21:00:00 |  | 00:00:00 |  |  |  |  | 01:16:00 | 00:00:00
 | Logan Total
2018-04-02 00:00:00 | Nick | 8 | Grande Lakes Multi | 06:01:00 | 07:00:00 |  | 08:34:00 | 13:54:00 |  | 15:09:00 | 15:42:00 |  |  | 8
2018-04-03 00:00:00 | Nick | 8 | Grande Lakes Multi | 06:01:00 | 07:42:00 |  | 08:56:00 | 13:38:00 |  | 14:17:00 | 15:18:00 |  |  | 8
2018-04-04 00:00:00 | Nick |  | [NAME] | 06:01:00 | 06:17:00 |  | 07:18:00 | 11:23:00 |  |  |  |  |  | 8
2018-04-04 00:00:00 | Nick |  | Olive Garden |  |  |  | 13:40:00 | 20:33:00 |  | 04:25:00 | 04:26:00 |  |  | 8
2018-04-05 00:00:00 | Nick |  | Olive Garden | 08:50:00 |  | 00:00:00 |  |  |  |  | 15:42:00 | 00:00:00 |  | 8
2018-04-06 00:00:00 | Nick |  | [NAME] | 06:11:00 |  | 00:00:00 |  |  |  |  | 16:49:00 | 00:00:00 |  | 8
 | Nick Total
2018-04-02 00:00:00 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | [NAME]
2018-04-03 00:00:00 | Ricky |  | Walmart | 18:30:00 | 19:58:00 |  | 22:53:00 | 05:02:00 |  | 05:08:00 | 05:19:00 |  |  | 24
2018-04-05 00:00:00 | Ricky |  | Walmart | 21:30:00 |  | 00:00:00 |  |  |  |  | 01:16:00 | 00:00:00 |  | 24
 | Ricky Total
2018-04-01 00:00:00 | [NAME] |  | Walmart | 18:07:00 | 18:44:00 |  | 19:58:00 | 04:39:00 |  | 05:22:00 | 05:26:00
2018-04-02 00:00:00 | [NAME] |  | Walmart | 20:18:00 | 20:27:00 |  | 21:38:00 | 21:49:00 |  | 22:31:00 | 23:40:00
2018-04-03 00:00:00 | [NAME] |  | Walmart | 18:00:00 | 18:47:00 |  | 19:56:00 | 05:26:00 |  | 06:09:00 | 06:16:00
2018-04-04 00:00:00 | [NAME] |  | Walmart | 18:21:00 | 19:12:00 |  | 20:40:00 | 06:10:00 |  | 06:55:00 | 07:38:00
2018-04-05 00:00:00 | [NAME] |  | Walmart | 18:12:00 | 18:21:00 |  | 19:44:00 | 04:40:00 |  | 05:23:00 | 05:27:00
 | Rocco Total
2018-04-03 00:00:00 | Sergio | 15 | Epcot France | 06:13:00 | 07:49:00 |  | 09:42:00 | 12:39:00 |  | 13:18:00 | 15:30:00 |  |  | 8
2018-04-04 00:00:00 | Sergio |  | Fish Memorial | 06:05:00 | 07:26:00 |  | 11:35:00 | 17:23:00 |  | 18:53:00 | 19:05:00 |  |  | 8 | 3
 | Sergio Total
2018-04-01 00:00:00 | [NAME] |  | Walmart | 17:19:00 | 19:53:00 |  | 20:52:00 | 04:43:00 |  | 05:23:00 | 05:34:00 |  |  | 24
2018-04-02 00:00:00 | [NAME] |  | Walmart | 18:18:00 | 18:51:00 |  | 21:48:00 | 03:26:00 |  | 05:30:00 | 05:38:00 |  |  | 24
2018-04-03 00:00:00 | [NAME] |  | Walmart | 17:45:00 | 19:24:00 |  | 20:45:00 | 05:00:00 |  | 05:08:00 | 05:16:00
2018-04-04 00:00:00 | [NAME] |  | Walmart | 18:18:00 | 19:30:00 |  | 21:47:00 | 06:45:00 |  | 09:22:00 | 09:28:00
2018-04-05 00:00:00 | [NAME] |  | Walmart | 17:59:00 | 18:23:00 |  | 20:45:00 | 06:07:00 |  | 07:50:00 | 08:43:00
 | [NAME]
2018-04-01 00:00:00 | [NAME] |  | Walmart | 18:05:00 | 20:35:00 |  | 23:44:00 | 07:19:00 |  | 09:30:00 | 09:36:00 |  |  | 24
2018-04-02 00:00:00 | [NAME] |  | Walmart | 18:32:00 | 18:51:00 |  | 21:48:00 | 03:26:00 |  | 05:30:00 | 05:40:00 |  |  | 24
2018-04-03 00:00:00 | [NAME] |  | Walmart | 17:40:00 | 19:24:00 |  | 20:45:00 | 05:00:00 |  | 05:08:00 | 05:15:00
2018-04-04 00:00:00 | [NAME] |  | Walmart | 17:36:00 | 21:14:00 |  | 22:07:00 | 06:49:00 |  | 06:54:00 | 07:08:00
 | [NAME]
 | TJ |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | TJ Total
2018-04-03 00:00:00 | Willie |  |  | 05:53:00 |  | 00:00:00 |  |  |  |  | 14:30:00 | 00:00:00
2018-04-04 00:00:00 | Willie |  | Orange Ave | 05:55:00 | 06:43:00 |  | 08:08:00 | 15:09:00 |  | 16:06:00 | 16:07:00 |  |  | 3
2018-04-05 00:00:00 | Willie |  | [NAME] | 05:56:00 | 07:07:00 |  | 07:58:00 | 09:22:00 |  |  |  |  |  | 8
2018-04-05 00:00:00 | Willie |  | [NAME] |  |  |  | 10:12:00 | 12:48:00 |  | 13:26:00 | 14:30:00 | 00:00:00 |  | 8
2018-04-06 00:00:00 | Willie |  | Firestation 62 | 06:04:00 | 06:43:00 |  | 08:07:00 | 09:15:00 |  |  |  |  |  | 1.5
2018-04-06 00:00:00 | Willie |  | Maitland City |  |  |  | 09:50:00 | 10:48:00 |  |  |  |  |  | 8 | 1
2018-04-06 00:00:00 | Willie |  | Epcot France |  |  |  | 11:36:00 | 13:11:00 |  | 13:57:00 | 14:33:00 |  |  | 8
 | Willie Total
2018-04-03 00:00:00 | [NAME] | 7 | The Strand | 07:30:00 | 08:19:00 |  | 08:49:00 | 14:22:00 |  | 14:27:00 | 15:00:00 |  |  | 1
2018-04-04 00:00:00 | [NAME] |  | Orange Ave Storage | 06:00:00 | 07:29:00 |  | 08:33:00 | 11:17:00 |  | 11:59:00 | 12:30:00 |  |  | 3 | 3
 | Willie S Total
 | Grand Total