Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 07292018-08032018

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
07/30/2018 | [NAME] |  | Edison | 05:50 AM | 06:24:00 |  | 08:17:00 | 10:38:00 |  |  |  |  |  | 7
07/30/2018 | [NAME] |  | Cypress |  |  |  | 11:14:00 | 15:25:00 |  | 16:08:00 | 04:07 PM | 0:00:00 |  | 4
07/31/2018 | [NAME] |  | st cloud | 06:16 AM | 07:26:00 |  | 08:43:00 | 15:46:00 |  | 16:47:00 | 04:48 PM |  |  | 4
08/01/2018 | [NAME] |  | fl Hospital | 05:54 AM | 07:08:00 |  | 07:46:00 | 09:34:00 |  |  |  |  |  | 2
08/01/2018 | [NAME] |  | Station |  |  |  | 10:44:00 | 14:09:00 |  | 14:28:00 | 02:47 PM |  |  | 5
08/02/2018 | [NAME] |  | Hindu | 05:57 AM | 06:29:00 |  | 08:12:00 | 09:57:00 |  |  |  |  |  | 1.5
08/02/2018 | [NAME] |  | Village F |  |  |  | 11:33:00 | 13:57:00 |  | 14:45:00 | 02:48 PM |  |  | 2
08/03/2018 | [NAME] |  | Cypress | 05:51 AM | 06:29:00 |  | 07:31:00 | 13:12:00 |  |  |  |  |  | 4
08/03/2018 | [NAME] |  | station |  |  |  | 14:37:00 | 15:24:00 |  | 15:38:00 | 03:40 PM |  |  | 3
 | Allen Total
07/30/2018 | [NAME] |  | Steele | 06:37 AM | 06:52:00 |  | 07:29:00 | 09:59:00 |  |  |  |  |  | 3
07/30/2018 | [NAME] |  | [NAME] |  |  |  | 10:43:00 | 15:07:00 |  | 15:43:00 | 04:12 PM |  |  | 4
07/31/2018 | [NAME] |  | [NAME] | 06:41 AM | 07:04:00 |  | 07:52:00 | 15:38:00 |  | 15:41:00 | 03:58 PM |  |  | 8
08/01/2018 | [NAME] |  | [NAME] | 06:52 AM | 07:39:00 |  | 08:25:00 | 15:04:00 |  | 15:36:00 | 03:56 PM |  |  | 8
08/02/2018 | [NAME] |  |  | 06:53 AM | 07:12:00 |  | 07:50:00 | 15:23:00 |  | 15:59:00 | 04:21 PM |  |  | 8
08/03/2018 | [NAME] |  |  | 03:30 AM | 07:27:00 | 0:00:00 | 08:16:00 | 13:46:00 |  | 14:35:00 | 02:53 PM |  |  | 8
 | [NAME]
07/30/2018 | [NAME] |  | Rolling | 06:00 AM | 07:32:00 |  | 08:46:00 | 13:49:00 |  | 14:44:00 | 03:08 PM |  |  | 5
07/31/2018 | [NAME] |  | Bent | 06:08 AM | 07:01:00 |  | 08:54:00 | 11:05:00 |  |  |  |  |  | 2.5
07/31/2018 | [NAME] |  | station |  |  |  | 12:28:00 | 17:12:00 |  | 17:26:00 | 05:45 PM |  |  | 4
08/01/2018 | [NAME] |  | Edison | 06:00 AM | 06:42:00 |  | 07:24:00 | 15:26:00 |  | 16:11:00 | 04:25 PM |  |  | 5
08/02/2018 | [NAME] |  | Hindu | 06:14 AM | 06:40:00 |  | 07:44:00 | 10:05:00 |  |  |  |  |  | 1.5
08/02/2018 | [NAME] |  | Village F |  |  |  | 10:58:00 | 15:53:00 |  | 16:46:00 | 04:48 PM |  |  | 2
08/03/2018 | [NAME] |  | eber | 06:26 AM | 06:47:00 |  | 08:55:00 | 12:30:00 |  |  |  |  |  | 2
08/03/2018 | [NAME] |  | Cypress |  |  |  | 14:09:00 | 15:55:00 |  | 16:36:00 | 04:45 PM |  |  | 2
 | Benjamin Total
07/29/2018 | [NAME] |  | Walmart | 05:44 PM | 18:30:00 |  | 19:50:00 | 08:07:00 |  | 08:53:00 | 10:26 AM |  |  | 48
07/30/2018 | [NAME] |  | Walmart | 05:45 PM | 18:03:00 |  | 19:20:00 | 08:57:00 |  | 09:35:00 | 10:06 AM
07/31/2018 | [NAME] |  |  | 06:07 PM | 18:50:00 |  | 20:53:00 | 07:42:00 |  | 08:24:00 | 08:31 AM
08/01/2018 | [NAME] |  |  | 06:24 PM | 18:44:00 |  | 20:19:00 | 08:07:00 |  | 08:51:00 | 10:01 AM
08/02/2018 | [NAME] |  |  | 05:05 PM | 18:48:00 |  | 20:03:00 | 07:49:00 |  | 08:25:00 | 08:34 AM
 | [NAME]
07/30/2018 | [NAME] |  | Walmart | 05:58 PM | 18:03:00 |  | 20:24:00 | 23:28:00 |  | 00:39:00 | 12:54 AM |  |  | 24
07/31/2018 | [NAME] |  |  | 06:01 PM | 18:49:00 |  | 20:54:00 | 03:29:00 |  | 04:43:00 | 04:47 AM
08/01/2018 | [NAME] |  |  | 09:40 PM | 21:58:00 |  | 23:51:00 | 01:51:00 |  | 03:04:00 | 03:07 AM
08/02/2018 | [NAME] |  |  | 09:23 PM | 21:27:00 |  | 22:23:00 | 23:19:00 |  | 00:09:00 | 12:12 AM
 | Brandon Total
07/30/2018 | Dwayne |  | Edison | 05:45 AM | 06:24:00 |  | 08:17:00 | 10:38:00 |  |  |  |  |  | 7
07/30/2018 | Dwayne |  | Cypress |  |  |  | 11:14:00 | 15:25:00 |  | 16:08:00 | 04:20 PM |  |  | 4
07/31/2018 | Dwayne |  | st cloud | 06:27 AM | 07:26:00 |  | 08:43:00 | 15:46:00 |  | 16:47:00 | 05:23 PM |  |  | 4
08/02/2018 | Dwayne |  | Hindu | 05:52 AM | 07:08:00 |  | 07:46:00 | 09:34:00 |  |  |  |  |  | 1.5
08/02/2018 | Dwayne |  | Village F |  |  |  | 10:44:00 | 14:09:00 |  | 14:28:00 | 02:51 PM |  |  | 2
08/03/2018 | Dwayne |  | Cypress | 05:48 AM | 06:29:00 |  | 08:12:00 | 09:57:00 |  |  |  |  |  | 4
08/03/2018 | Dwayne |  | station |  |  |  | 11:33:00 | 13:57:00 |  | 14:45:00 | 03:55 PM | 0:00:00 |  | 3
 | [NAME]
07/30/2018 | Edgar |  | France | 05:58 AM | 06:29:00 |  | 07:31:00 | 13:12:00 |  |  |  |  |  | 3
07/30/2018 | Edgar |  | Cypress |  |  |  | 14:37:00 | 15:24:00 |  | 15:38:00 | 04:05 PM |  |  | 4
07/31/2018 | Edgar |  | Edison | 06:03 AM | 06:46:00 |  | 07:15:00 | 15:31:00 |  | 16:09:00 | 04:30 PM |  |  | 7
08/01/2018 | Edgar |  | CVS | 06:02 AM |  | 0:00:00 | 08:00:00 | 14:00:00 |  | 14:15:00 | 02:24 PM |  |  | 6
08/02/2018 | Edgar |  | Edison | 06:02 AM | 06:32:00 |  | 08:38:00 | 15:30:00 |  | 15:57:00 | 04:07 PM |  |  | 7
08/03/2018 | Edgar |  | cemex | 06:00 AM | 06:15:00 |  | 11:00:00 | 15:00:00 |  | 15:45:00 | 04:02 PM |  |  | 4
 | [NAME]
07/30/2018 | Efrain |  | Walmart | 18:15:00 | 18:15:00 |  | 19:23:00 | 03:17:00 |  | 04:22:00 | 03:56 AM | 0:00:00 |  | 48
07/31/2018 | Efrain |  | Walmart | 07:53 PM | 18:25:00 | 0:00:00 | 20:41:00 | 03:16:00 |  | 05:08:00 | 04:40 AM | 0:00:00
08/01/2018 | Efrain |  |  | 07:40 PM | 18:17:00 | 0:00:00 | 21:30:00 | 04:10:00 |  | 05:03:00 | 04:35 AM | 0:00:00
08/02/2018 | Efrain |  |  | 07:28 PM | 18:14:00 | 0:00:00 | 20:03:00 | 23:20:00 |  | 00:25:00 | 11:55 PM | 0:00:00
08/03/2018 | Efrain |  |  | 07:28 PM | 19:07:00 | 0:00:00 | 19:24:00 | 05:03:00 |  | 06:01:00 | 05:55 AM | 0:00:00
 | Efrain Total
07/30/2018 | [NAME] |  | Walmart Kirkman | 05:55 AM |  | 0:00:00 |  |  |  |  | 04:47 PM | 0:00:00 |  | 8
07/31/2018 | [NAME] |  |  | 05:58 AM |  | 0:00:00 |  |  |  |  | 02:22 PM | 0:00:00
08/01/2018 | [NAME] |  | station | 05:56 AM | 06:45:00 |  | 06:58:00 | 14:44:00 |  | 15:31:00 | 02:30 PM | 0:00:00
08/02/2018 | [NAME] |  | Walmart Kirkman | 06:12 AM | 06:28:00 |  | 07:28:00 | 13:38:00 |  | 15:36:00 | 04:06 PM |  |  | 8
08/03/2018 | [NAME] |  | cemex | 06:00 AM | 06:15:00 |  | 11:00:00 | 15:00:00 |  | 15:45:00 | 03:14 PM | 0:00:00 |  | 4
 | [NAME]
07/30/2018 | [NAME] |  | Steele | 07:00 AM | 06:53:00 | 0:00:00 | 07:29:00 | 10:27:00 |  | 11:02:00 | 01:15 PM | 0:00:00 |  | 3
07/31/2018 | [NAME] |  | Lake Dexter | 04:40 AM |  | 0:00:00 |  |  |  |  | 07:36 PM | 0:00:00 |  | 3
08/01/2018 | [NAME] |  | fl Hospital | 05:47 AM | 07:37:00 |  | 07:46:00 | 09:34:00 |  |  |  |  |  | 2
08/01/2018 | [NAME] |  | Station |  |  |  | 10:44:00 | 14:09:00 |  | 14:28:00 | 07:47 PM | 0:00:00 |  | 5
08/02/2018 | [NAME] |  | Hindu | 06:19 AM | 06:29:00 |  | 08:12:00 | 13:57:00 |  | 14:45:00 | 07:00 PM | 0:00:00 |  | 5
08/03/2018 | [NAME] |  | Cypress | 06:05 AM | 06:29:00 |  | 07:31:00 | 15:24:00 |  | 15:38:00 | 01:31 PM | 0:00:00 |  | 7
 | [NAME]
07/30/2018 | [NAME] |  | Rolling | 06:32 AM | 07:32:00 |  | 08:46:00 | 13:49:00 |  | 14:44:00 | 03:08 PM |  |  | 5
07/31/2018 | [NAME] |  | Bent | 06:38 AM | 07:01:00 |  | 08:54:00 | 11:05:00 |  |  |  |  |  | 2.5
07/31/2018 | [NAME] |  | station |  |  |  | 12:28:00 | 17:12:00 |  | 17:26:00 | 05:45 PM |  |  | 4
08/02/2018 | [NAME] |  | Hindu | 05:53 AM | 06:40:00 |  | 07:44:00 | 10:05:00 |  |  |  |  |  | 2 | 1
08/02/2018 | [NAME] |  | Village F |  |  |  | 10:58:00 | 15:53:00 |  | 16:46:00 | 04:48 PM |  |  | 2
08/03/2018 | [NAME] |  | eber | 06:26 AM | 06:47:00 |  | 08:55:00 | 12:30:00 |  |  |  |  |  | 3.5
08/03/2018 | [NAME] |  | Cypress |  |  |  | 14:09:00 | 15:55:00 |  | 16:36:00 | 04:45 PM |  |  | 2
 | [NAME]
07/30/2018 | Logan |  | Walmart | 05:58 PM | 18:03:00 |  | 20:24:00 | 23:28:00 |  | 00:39:00 | 12:54 AM |  |  | 24
07/31/2018 | Logan |  |  | 06:01 PM | 18:49:00 |  | 20:54:00 | 03:29:00 |  | 04:43:00 | 04:47 AM
08/01/2018 | Logan |  |  | 09:40 PM | 21:58:00 |  | 23:51:00 | 01:51:00 |  | 03:04:00 | 03:06 AM
08/02/2018 | Logan |  |  | 09:20 PM | 21:27:00 |  | 22:23:00 | 23:19:00 |  | 00:09:00 | 12:12 AM
 | Logan Total
07/30/2018 | [NAME] |  | Bent | 06:08 AM | 07:03:00 |  | 08:14:00 | 13:56:00 |  | 14:09:00 | 02:37 PM |  |  | 5
07/31/2018 | [NAME] |  | Sunrise | 06:03 AM | 07:35:00 |  | 09:12:00 | 13:03:00 |  |  |  |  |  | 3
07/31/2018 | [NAME] |  | st cloud |  |  |  | 14:01:00 | 15:47:00 |  | 16:33:00 | 05:22 PM |  |  | 3
08/01/2018 | [NAME] |  | Edison | 06:21 AM | 07:09:00 |  | 07:50:00 | 14:58:00 |  | 15:22:00 | 04:31 PM |  |  | 8
08/02/2018 | [NAME] |  | Hindu | 06:06 AM | 07:10:00 |  | 09:03:00 | 11:35:00 |  | 11:58:00 | 06:25 PM | 0:00:00 |  | 1
08/03/2018 | [NAME] |  | [NAME] | 06:10 AM | 07:32:00 |  | 08:31:00 | 09:51:00 |  |  |  |  |  | 1.5
08/03/2018 | [NAME] |  | CVS Lee |  |  |  | 10:30:00 | 11:23:00 |  |  |  |  |  | 1
08/03/2018 | [NAME] |  | Cypress |  |  |  | 11:50:00 | 14:04:00 |  | 14:41:00 | 04:11 PM | 0:00:00 |  | 3
 | Patrick Total
07/30/2018 | [NAME] |  | Walmart | 06:01 PM | 18:15:00 |  | 19:23:00 | 03:17:00 |  | 04:22:00 | 04:25 AM |  |  | 48
07/31/2018 | [NAME] |  | Walmart | 06:02 PM | 18:25:00 | 0:00:00 | 20:41:00 | 03:16:00 |  | 05:08:00 | 05:13 AM
08/01/2018 | [NAME] |  |  | 06:03 PM | 18:17:00 | 0:00:00 | 21:30:00 | 04:10:00 |  | 05:03:00 | 05:12 AM
08/02/2018 | [NAME] |  |  | 06:01 PM | 18:14:00 | 0:00:00 | 20:03:00 | 23:20:00 |  | 00:25:00 | 12:30 AM
08/03/2018 | [NAME] |  |  | 07:01 PM | 19:07:00 | 0:00:00 | 19:24:00 | 05:03:00 |  | 06:01:00 | 05:57 AM | 0:00:00
 | Rocco Total
07/30/2018 | [NAME] |  | Walmart Kirkman | 05:57 AM |  | 0:00:00 |  |  |  |  | 04:45 PM | 0:00:00 |  | 8
07/31/2018 | [NAME] |  |  | 05:58 AM |  | 0:00:00 |  |  |  |  | 03:46 PM | 0:00:00
08/01/2018 | [NAME] |  | station | 05:59 AM | 06:45:00 |  | 06:58:00 | 14:44:00 |  | 15:31:00 | 04:05 PM
08/02/2018 | [NAME] |  | Walmart Kirkman | 06:01 AM | 06:28:00 |  | 07:28:00 | 13:38:00 |  | 15:36:00 | 04:28 PM |  |  | 8
08/03/2018 | [NAME] |  | st cloud | 06:00 AM | 06:55:00 |  | 08:29:00 | 15:06:00 |  | 16:02:00 | 04:05 PM |  |  | 6
 | Ryan Total
07/29/2018 | [NAME] |  | Walmart | 05:43 PM | 18:30:00 |  | 19:50:00 | 08:07:00 |  | 08:53:00 | 10:27 AM |  |  | 48
07/30/2018 | [NAME] |  | Walmart | 05:45 PM | 18:03:00 |  | 19:20:00 | 08:57:00 |  | 09:35:00 | 10:06 AM
07/31/2018 | [NAME] |  |  | 06:07 PM | 18:50:00 |  | 20:53:00 | 07:42:00 |  | 08:24:00 | 08:31 AM
08/01/2018 | [NAME] |  |  | 06:23 PM | 18:44:00 |  | 20:19:00 | 08:07:00 |  | 08:51:00 | 10:01 AM
08/02/2018 | [NAME] |  |  | 05:06 PM | 18:48:00 |  | 20:03:00 | 07:49:00 |  | 08:25:00 | 08:34 AM
 | [NAME]
07/30/2018 | Terrance |  | Cypress | 06:08 AM | 07:13:00 |  | 08:01:00 | 11:01:00 |  | 14:10:00 | 02:33 PM |  |  | 4
08/01/2018 | Terrance |  | [NAME] | 06:09 AM | 07:07:00 |  | 08:16:00 | 14:45:00 |  | 15:22:00 | 04:30 PM | 0:00:00 |  | 6
08/02/2018 | Terrance |  | Village F | 06:09 AM | 06:47:00 |  | 08:19:00 | 11:03:00 |  | 11:13:00 | 01:00 PM | 0:00:00 |  | 2 | 1
08/03/2018 | Terrance |  | st cloud | 06:22 AM | 06:55:00 |  | 08:29:00 | 15:06:00 |  | 16:02:00 | 06:00 PM | 0:00:00 |  | 6
 | Terrance Total
07/29/2018 | [NAME] |  | Walmart | 06:05 PM | 18:30:00 |  | 19:50:00 | 08:07:00 |  | 08:53:00 | 08:53 AM |  |  | 48
07/30/2018 | [NAME] |  | Walmart | 06:07 PM | 18:03:00 | 0:00:00 | 19:20:00 | 08:57:00 |  | 09:35:00 | 09:51 AM
07/31/2018 | [NAME] |  |  | 07:01 PM | 18:50:00 | 0:00:00 | 20:53:00 | 07:42:00 |  | 08:24:00 | 08:28 AM
08/01/2018 | [NAME] |  |  | 06:59 PM | 18:44:00 | 0:00:00 | 20:19:00 | 08:07:00 |  | 08:51:00 | 09:11 AM
08/02/2018 | [NAME] |  |  | 06:14 PM | 18:48:00 |  | 20:03:00 | 07:49:00 |  | 08:25:00 | 08:46 AM
 | [NAME]
07/30/2018 | Willie |  | France | 05:56 AM | 06:24:00 |  | 08:17:00 | 10:38:00 |  |  |  |  |  | 3
07/30/2018 | Willie |  | Cypress |  |  |  | 11:14:00 | 15:25:00 |  | 16:08:00 | 03:57 PM | 0:00:00 |  | 4
07/31/2018 | Willie |  | Station | 05:58 AM | 07:15:00 |  | 07:26:00 | 08:40:00 |  | 15:36:00 | 04:36 PM | 0:00:00 |  | 2
08/01/2018 | Willie |  | [NAME] | 06:00 AM | 07:07:00 |  | 08:16:00 | 14:45:00 |  | 15:22:00 | 03:34 PM |  |  | 6 | 1
08/02/2018 | Willie |  | Vernazza | 06:18 AM | 06:28:00 |  | 07:28:00 | 08:23:00 |  |  |  |  |  | 2
08/02/2018 | Willie |  | flagler |  |  |  | 13:15:00 | 14:36:00 |  | 15:36:00 | 03:40 PM |  |  | 2.5
 | Willie Total
07/30/2018 | Zachary |  | Bent | 05:52 AM | 06:14:00 |  | 07:19:00 | 14:22:00 |  | 15:01:00 | 03:14 PM |  |  | 7
07/31/2018 | Zachary |  | Edison | 05:51 AM | 06:46:00 |  | 07:15:00 | 15:31:00 |  | 16:09:00 | 04:28 PM |  |  | 7
08/01/2018 | Zachary |  | Edison | 05:53 AM | 06:40:00 |  | 08:02:00 | 15:11:00 |  | 15:41:00 | 04:01 PM |  |  | 8
08/02/2018 | Zachary |  | Edison | 05:54 AM | 06:32:00 |  | 08:38:00 | 15:30:00 |  | 15:57:00 | 04:07 PM |  |  | 6
08/03/2018 | Zachary |  | Longwood | 05:56 AM | 06:33:00 |  | 07:30:00 | 09:00:00 |  |  |  |  |  | 1.5
08/03/2018 | Zachary |  | Edison |  |  |  | 11:00:00 | 15:00:00 |  | 15:45:00 | 04:00 PM |  |  | 6
 | Zachary Total
07/30/2018 | Nick |  | Bent | 05:49:00 | 06:14:00 |  | 07:19:00 | 14:22:00 |  | 15:01:00 | 15:16:00 |  |  | 7
07/31/2018 | Nick |  | Edison | 05:50:00 | 06:46:00 |  | 07:15:00 | 15:31:00 |  | 16:09:00 | 16:30:00 |  |  | 7
08/01/2018 | Nick |  | Edison | 06:00:00 | 06:40:00 |  | 08:02:00 | 15:11:00 |  | 15:41:00 | 16:00:00 |  |  | 8
08/02/2018 | Nick |  | Edison | 05:57:00 | 06:32:00 |  | 08:38:00 | 15:30:00 |  | 15:57:00 | 16:06:00 |  |  | 6
08/03/2018 | Nick |  | Longwood | 06:01:00 | 06:33:00 |  | 07:30:00 | 09:00:00 |  |  |  |  |  | 1.5
08/03/2018 | Nick |  | Edison |  |  |  | 11:00:00 | 15:00:00 |  | 15:45:00 | 16:02:00 |  |  | 6
2018-08-04 00:00:00 | Nick |  | station | 05:55:00 | 06:05:00 |  | 06:30:00 | 14:25:00 |  | 14:34:00 | 14:39:00 |  |  | 8
 | Nick Total
07/31/2018 | [NAME] |  | Station | 05:58:00 | 07:15:00 |  | 07:26:00 | 08:40:00 |  | 15:36:00 | 16:25:00 |  |  | 2 | 1
08/01/2018 | [NAME] |  | [NAME] | 06:02:00 | 07:07:00 |  | 08:16:00 | 14:45:00 |  | 15:22:00 | 16:32:00 | 0:00:00 |  | 6
08/02/2018 | [NAME] |  | Vernazza | 06:05:00 | 06:28:00 |  | 07:28:00 | 08:23:00 |  |  |  |  |  | 2
08/02/2018 | [NAME] |  | flagler |  |  |  | 13:15:00 | 14:36:00 |  | 15:36:00 | 16:30:00 | 0:00:00 |  | 2.5
08/03/2018 | [NAME] |  | st cloud | 05:58:00 | 07:07:00 |  | 08:16:00 | 14:45:00 |  | 15:22:00 | 16:15:00 | 0:00:00 |  | 6
 | [NAME]