Spreadsheet: 600398d1543675263-multiple-conditional-formula-driver-job-log-book
Sheet: 04292018-05052018

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-30 00:00:00 | [NAME] | 4 | Samoy | 5:31:00 | 7:15:00 |  | 8:44:00 | 12:09:00 |  |  |  |  |  | 4.5
2018-04-30 00:00:00 | [NAME] | 4 | Orange Ave |  |  |  | 13:20:00 | 14:58:00 |  | 15:10:00 | 15:17:00 |  |  | 4.5
2018-05-02 00:00:00 | [NAME] | 4 | Heritage ills | 5:50:00 | 7:39:00 |  | 9:59:00 | 16:36:00 |  | 17:48:00 | 17:47:00 | 0:00:00 |  | 8 | 1
2018-05-03 00:00:00 | [NAME] | 4 | Heritage ills | 5:43:00 | 7:06:00 |  | 9:02:00 | 15:46:00 |  | 16:31:00 | 16:34:00 |  |  | 8
2018-05-04 00:00:00 | [NAME] | 4 | Vera | 5:36:00 | 6:48:00 |  | 7:07:00 | 9:54:00
2018-05-04 00:00:00 | [NAME] | 4 | Longwood |  |  |  | 12:39:00 | 15:23:00 |  | 15:51:00 | 15:54:00
2018-05-04 00:00:00 | [NAME] | 4 | The Strand |  |  |  | 10:53:00 | 11:54:00
 | Allen Total
2018-04-30 00:00:00 | [NAME] |  | GA | 4:50:00 |  | 0:00:00 |  |  |  |  | 17:14:00 | 0:00:00
2018-05-01 00:00:00 | [NAME] |  | I-295 | 6:39:00 | 13:55:00 |  | 14:10:00 | 14:51:00 |  | 15:10:00 | 15:45:00
2018-05-02 00:00:00 | [NAME] |  | I-295 | 18:32:00 | 21:04:00 |  | 22:07:00 | 23:33:00 |  | 23:44:00 | 0:03:00 | 0:00:00 |  | 7
2018-05-03 00:00:00 | [NAME] |  | I-295 | 17:52:00 | 19:40:00 |  | 20:03:00 | 12:10:00 |  | 12:21:00 | 12:25:00 |  |  | 6
 | [NAME]
2018-04-30 00:00:00 | [NAME] | 10 | Adventist | 6:02:00 | 7:57:00 |  | 10:11:00 | 13:46:00 |  |  |  |  |  | 8
2018-04-30 00:00:00 | [NAME] | 10 | Bainbridge |  |  |  | 8:29:00 | 9:31:00 |  | 14:57:00 | 17:08:00 |  |  | 8
2018-05-01 00:00:00 | [NAME] | 10 | Murphy Oil | 6:06:00 | 7:05:00 |  | 9:07:00 | 13:49:00 |  | 14:49:00 | 16:09:00 | 0:00:00 |  | 8
2018-05-02 00:00:00 | [NAME] | 10 | Animal | 8:51:00 | 8:56:00 |  | 9:48:00 | 11:02:00 |  |  | 16:06:00 | 0:00:00 |  | 3
2018-05-03 00:00:00 | [NAME] | 10 | Heritage ills | 6:11:00 | 7:08:00 |  | 9:03:00 | 15:20:00 |  | 16:24:00 | 16:56:00 |  |  | 8
2018-05-04 00:00:00 | [NAME] | 10 | Family Dollar | 6:05:00 | 6:32:00 |  | 8:58:00 | 13:55:00 |  | 15:59:00 | 16:21:00 |  |  | 6
 | [NAME]
2018-05-02 00:00:00 | [NAME] | 4 | Heritage ills | 6:03:00 | 7:39:00 |  | 9:59:00 | 16:36:00 |  | 17:48:00 | 17:48:00 |  |  | 8
2018-05-03 00:00:00 | [NAME] | 4 | Heritage ills | 6:11:00 | 7:06:00 |  | 9:02:00 | 15:46:00 |  | 16:31:00 | 17:01:00 |  |  | 8
2018-05-04 00:00:00 | [NAME] | 4 | Vera | 5:56:00 | 6:48:00 |  | 7:07:00 | 9:54:00
2018-05-04 00:00:00 | [NAME] | 4 | Longwood |  |  |  | 12:39:00 | 15:23:00 |  | 15:51:00 | 16:24:00
2018-05-04 00:00:00 | [NAME] | 4 | The Strand |  |  |  | 10:53:00 | 11:54:00
 | [NAME]
2018-04-29 00:00:00 | [NAME] |  | Walmart | 17:37:00 | 17:51:00 |  | 21:58:00 | 12:39:00 |  | 12:46:00 | 12:51:00 |  |  | 36
2018-04-30 00:00:00 | [NAME] |  | Walmart | 20:31:00 | 20:39:00 |  | 20:44:00 | 6:12:00 |  | 6:23:00 | 6:36:00
2018-05-01 00:00:00 | [NAME] |  | Walmart | 19:18:00 | 19:22:00 |  | 19:31:00 | 6:11:00 |  | 8:00:00 | 8:30:00
2018-05-02 00:00:00 | [NAME] |  | Walmart | 17:38:00 | 18:11:00 |  | 18:32:00 | 6:42:00 |  | 6:48:00 | 6:55:00
2018-05-03 00:00:00 | [NAME] |  | Walmart | 17:30:00 | 18:03:00 |  | 18:24:00 | 5:41:00 |  | 11:30:00 | 12:26:00
 | Brandon Total
2018-04-29 00:00:00 | Dwayne | 10 | South and [NAME] | 18:37:00 | 18:59:00 |  | 19:33:00 | 2:59:00 |  | 3:22:00 | 3:26:00 |  |  | 8
2018-04-30 00:00:00 | Dwayne | 10 | South and [NAME] | 19:33:00 | 20:10:00 |  | 21:00:00 | 6:06:00 |  | 6:34:00 | 6:47:00 |  |  | 8
2018-05-01 00:00:00 | Dwayne | 10 | South and [NAME] | 19:30:00 | 19:36:00 |  | 20:28:00 | 3:08:00 |  | 3:33:00 | 3:30:00 | 0:00:00 |  | 8
2018-05-02 00:00:00 | Dwayne | 10 | South and [NAME] | 18:40:00 | 19:37:00 |  | 20:24:00 | 4:07:00 |  | 4:28:00 | 4:36:00 |  |  | 8
2018-05-03 00:00:00 | Dwayne | 10 | South and [NAME] | 18:42:00 | 18:59:00 |  | 19:37:00 | 2:30:00 |  | 2:50:00 | 2:52:00 |  |  | 8
 | [NAME]
2018-04-29 00:00:00 | Edgar | 6 | USPS | 6:00:00 | 6:53:00 |  | 8:20:00 | 16:32:00 |  | 17:37:00 | 17:41:00 |  |  | 7
2018-04-30 00:00:00 | Edgar | 8 | USPS | 5:59:00 | 6:39:00 |  | 7:58:00 | 15:29:00 |  | 16:35:00 | 16:50:00 |  |  | 4
2018-05-01 00:00:00 | Edgar | 8 | USPS | 6:01:00 | 7:08:00 |  | 8:12:00 | 11:39:00 |  |  |  |  |  | 4
2018-05-01 00:00:00 | Edgar | 8 | [NAME] |  |  |  | 12:39:00 | 15:52:00 |  | 16:31:00 | 16:42:00 |  |  | 4
2018-05-02 00:00:00 | Edgar | 8 | AFGO | 5:56:00 | 6:19:00 |  | 7:23:00 | 9:56:00 |  |  | 15:00:00 | 0:00:00 |  | 4
2018-05-02 00:00:00 | Edgar | 8 | Ashton |  |  |  | 10:17:00 | 14:01:00 |  | 14:37:00 | 15:00:00 |  |  | 4
2018-05-03 00:00:00 | Edgar | 8 | Ashton | 6:01:00 | 6:45:00 |  | 7:35:00 | 9:30:00 |  |  |  |  |  | 8
2018-05-03 00:00:00 | Edgar | 8 | Bainbridge |  |  |  | 9:40:00 | 11:00:00 |  |  |  |  |  | 1
2018-05-03 00:00:00 | Edgar | 8 | The Strand |  |  |  | 11:49:00 | 12:58:00 |  | 13:06:00 | 13:33:00 |  |  | 2
2018-05-04 00:00:00 | Edgar | 8 | BVL | 5:58:00 | 6:29:00 |  | 7:23:00 | 9:41:00 |  |  |  |  |  | 2
2018-05-04 00:00:00 | Edgar | 8 | Retreat |  |  |  | 11:13:00 | 12:41:00 |  | 13:29:00 | 14:13:00 |  |  | 2
 | [NAME]
2018-04-29 00:00:00 | Efrain | 3 | Walmart | 18:54:00 | 18:59:00 |  | 20:18:00 | 6:12:00 |  | 6:12:00 | 6:55:00 |  |  | 36
2018-04-30 00:00:00 | Efrain |  | Walmart | 21:14:00 | 20:03:00 | 0:00:00 | 21:52:00 | 7:22:00 |  | 8:28:00 | 8:39:00
2018-05-01 00:00:00 | Efrain |  | Walmart | 19:55:00 | 18:39:00 | 0:00:00 | 20:51:00 | 7:26:00 |  | 9:22:00 | 8:18:00 | 0:00:00
2018-05-02 00:00:00 | Efrain |  | Walmart | 21:01:00 | 19:33:00 | 0:00:00 | 22:56:00 | 9:13:00 |  | 10:42:00 | 11:40:00
 | Efrain Total
2018-04-30 00:00:00 | Javarious | 8 | USPS | 6:06:00 | 6:39:00 |  | 7:58:00 | 15:29:00 |  | 16:35:00 | 16:30:00 | 0:00:00 |  | 4
2018-05-01 00:00:00 | Javarious | 8 | USPS | 6:00:00 | 7:08:00 |  | 8:12:00 | 11:39:00 |  |  |  |  |  | 4
2018-05-01 00:00:00 | Javarious | 8 | [NAME] |  |  |  | 12:39:00 | 15:52:00 |  | 16:31:00 | 16:39:00 |  |  | 4
2018-05-02 00:00:00 | Javarious | 15 | Ashton | 6:08:00 | 8:14:00 |  | 10:34:00 | 14:15:00 |  | 15:04:00 | 15:48:00 | 0:00:00 |  | 7 | 1
 | Javarious Total
2018-04-30 00:00:00 | [NAME] |  | GA | 4:51:00 |  | 0:00:00 |  |  |  |  | 17:18:00 | 0:00:00
2018-05-03 00:00:00 | [NAME] |  | I-295 | 19:36:00 | 19:40:00 |  | 20:03:00 | 12:10:00 |  | 12:21:00 | 12:24:00 |  |  | 6
 | [NAME]
2018-04-29 00:00:00 | [NAME] | 10 | South and [NAME] | 5:48:00 | 6:53:00 |  | 8:20:00 | 16:32:00 | 0:00:00 | 3:22:00 | 3:28:00 |  |  | 8
2018-04-30 00:00:00 | [NAME] | 10 | South and [NAME] | 19:47:00 | 20:10:00 |  | 21:00:00 | 6:06:00 |  | 6:34:00 | 6:45:00 |  |  | 8
2018-05-01 00:00:00 | [NAME] | 10 | South and [NAME] | 19:30:00 | 19:36:00 |  | 20:28:00 | 3:08:00 |  | 3:33:00 | 3:28:00 | 0:00:00 |  | 8
2018-05-02 00:00:00 | [NAME] | 10 | South and [NAME] | 19:06:00 | 19:37:00 |  | 20:24:00 | 4:07:00 |  | 4:28:00 | 4:36:00 |  |  | 8
2018-05-03 00:00:00 | [NAME] | 10 | South and [NAME] | 18:47:00 | 18:59:00 |  | 19:37:00 | 2:30:00 |  | 2:50:00 | 2:53:00 |  |  | 8
 | [NAME]
2018-04-30 00:00:00 | Kenny | 7 | USPS | 5:50:00 | 6:41:00 |  | 9:19:00 | 14:42:00 |  | 17:53:00 | 18:00:00 |  |  | 8
2018-05-01 00:00:00 | Kenny |  | Animal | 5:40:00 |  | 0:00:00 |  |  |  |  | 15:35:00 | 0:00:00 |  | 5
2018-05-02 00:00:00 | Kenny | 2 | Animal | 5:58:00 | 6:47:00 |  | 8:04:00 | 14:15:00 |  | 15:23:00 | 15:32:00 |  |  | 3
2018-05-03 00:00:00 | Kenny | 15 | Legacy | 5:50:00 | 7:58:00 |  | 9:42:00 | 10:08:00 |  |  |  |  |  | 8
2018-05-03 00:00:00 | Kenny | 15 | USPS |  |  |  | 10:52:00 | 13:47:00 |  | 15:33:00 | 15:41:00 |  |  | 5
2018-05-04 00:00:00 | Kenny | 15 | Adventist | 5:52:00 | 7:41:00 |  | 8:09:00 | 10:25:00
2018-05-04 00:00:00 | Kenny | 15 | The Strand |  |  |  | 13:48:00 | 16:42:00 |  | 16:45:00 | 16:48:00
 | Kenny Total
2018-04-29 00:00:00 | Logan | 5 | Walmart | 19:29:00 | 19:42:00 |  | 22:30:00 | 4:52:00 |  | 6:16:00 | 6:20:00 |  |  | 36
2018-04-30 00:00:00 | Logan |  | Walmart | 20:24:00 | 22:19:00 |  | 12:19:00 | 9:02:00 |  | 10:39:00 | 10:56:00
2018-05-01 00:00:00 | Logan |  | Walmart | 20:10:00 | 22:19:00 |  | 12:19:00 | 9:02:00 |  | 10:39:00 | 10:56:00
 | Logan Total
2018-04-29 00:00:00 | Nick | 6 | USPS | 6:03:00 | 6:53:00 |  | 8:20:00 | 16:32:00 |  | 17:37:00 | 16:43:00 | 0:00:00 |  | 7
2018-04-30 00:00:00 | Nick | 8 | USPS | 6:05:00 | 6:39:00 |  | 7:58:00 | 15:29:00 |  | 16:35:00 | 16:37:00 |  |  | 4
2018-05-01 00:00:00 | Nick | 8 | USPS | 5:54:00 | 7:08:00 |  | 8:12:00 | 11:39:00 |  |  |  |  |  | 4
2018-05-01 00:00:00 | Nick | 8 | [NAME] |  |  |  | 12:39:00 | 15:52:00 |  | 16:31:00 | 16:37:00 |  |  | 4
2018-05-02 00:00:00 | Nick | 8 | AFGO | 5:55:00 | 6:19:00 |  | 7:23:00 | 9:56:00 |  |  | 14:45:00 | 0:00:00 |  | 4
2018-05-02 00:00:00 | Nick | 8 | Ashton |  |  |  | 10:17:00 | 14:01:00 |  | 14:37:00 | 14:45:00 |  |  | 4
2018-05-03 00:00:00 | Nick | 8 | Ashton | 5:55:00 | 6:45:00 |  | 7:35:00 | 9:30:00 |  |  |  |  |  | 8
2018-05-03 00:00:00 | Nick | 8 | Bainbridge |  |  |  | 9:40:00 | 11:00:00 |  |  |  |  |  | 1
2018-05-03 00:00:00 | Nick | 8 | The Strand |  |  |  | 11:49:00 | 12:58:00 |  | 13:06:00 | 13:58:00 |  |  | 2
2018-05-04 00:00:00 | Nick | 8 | BVL | 5:57:00 | 6:29:00 |  | 7:23:00 | 9:41:00 |  |  |  |  |  | 2
2018-05-04 00:00:00 | Nick | 8 | Retreat |  |  |  | 11:13:00 | 12:41:00 |  | 13:29:00 | 14:11:00 |  |  | 2
 | Nick Total
2018-04-30 00:00:00 | [NAME] | 15 | Adventist | 6:01:00 | 10:38:00 |  | 11:28:00 | 14:04:00 |  | 14:59:00 | 17:08:00 |  |  | 8
2018-05-01 00:00:00 | [NAME] | 10 | Murphy Oil | 6:06:00 | 7:05:00 |  | 9:07:00 | 13:49:00 |  | 14:49:00 | 16:04:00 | 0:00:00 |  | 8
2018-05-02 00:00:00 | [NAME] | 2 | Animal | 6:05:00 | 6:47:00 |  | 8:04:00 | 14:15:00 |  | 15:23:00 | 16:07:00 |  |  | 3
2018-05-03 00:00:00 | [NAME] | 2 | [NAME] | 6:12:00 | 6:46:00 |  | 9:30:00 | 14:02:00 |  | 14:47:00 | 16:57:00 |  |  | 8
2018-05-04 00:00:00 | [NAME] | 7 | Family Dollar | 6:05:00 | 7:20:00 |  | 9:12:00 | 13:23:00 |  | 14:15:00 | 16:22:00
 | Patrick Total
2018-04-29 00:00:00 | Ricky | 5 | Walmart | 19:32:00 | 19:42:00 |  | 22:30:00 | 4:52:00 |  | 6:16:00 | 6:21:00 |  |  | 36
2018-04-30 00:00:00 | Ricky |  | Walmart | 20:25:00 | 22:19:00 |  | 12:19:00 | 9:02:00 |  | 10:39:00 | 11:01:00
2018-05-01 00:00:00 | Ricky |  | Walmart | 20:10:00 | 22:19:00 |  | 12:19:00 | 9:02:00 |  | 10:39:00 | 10:56:00
 | Ricky Total
2018-04-29 00:00:00 | [NAME] |  | Walmart | 17:37:00 | 17:51:00 |  | 21:58:00 | 12:39:00 |  | 12:46:00 | 12:51:00 |  |  | 36
2018-04-30 00:00:00 | [NAME] |  | Walmart | 20:30:00 | 20:39:00 |  | 20:44:00 | 6:12:00 |  | 6:23:00 | 6:37:00
2018-05-01 00:00:00 | [NAME] |  | Walmart | 19:15:00 | 19:22:00 |  | 19:31:00 | 6:11:00 |  | 8:00:00 | 8:30:00
2018-05-02 00:00:00 | [NAME] |  | Walmart | 17:57:00 | 18:11:00 |  | 18:32:00 | 6:42:00 |  | 6:48:00 | 6:52:00
2018-05-03 00:00:00 | [NAME] |  | Walmart | 17:30:00 | 18:03:00 |  | 18:24:00 | 5:41:00 |  | 11:30:00 | 12:26:00
 | Rocco Total
2018-04-29 00:00:00 | [NAME] | 3 | Walmart | 17:53:00 | 18:59:00 |  | 20:18:00 | 6:12:00 |  | 7:35:00 | 8:03:00 |  |  | 36
2018-04-30 00:00:00 | [NAME] |  | Walmart | 17:55:00 | 20:03:00 |  | 21:52:00 | 7:22:00 |  | 8:28:00 | 9:40:00
2018-05-01 00:00:00 | [NAME] |  | Walmart | 18:05:00 | 18:39:00 |  | 20:51:00 | 7:26:00 |  | 9:22:00 | 11:10:00
2018-05-02 00:00:00 | [NAME] |  | Walmart | 18:07:00 | 19:33:00 |  | 22:56:00 | 9:13:00 |  | 10:42:00 | 11:15:00
2018-05-03 00:00:00 | [NAME] |  | Walmart | 18:09:00 | 19:28:00 |  | 22:42:00 | 7:35:00 |  | 9:28:00 | 10:12:00
 | [NAME]
2018-04-29 00:00:00 | TJ | 6 | USPS | 7:40:00 | 7:40:00 |  | 10:23:00 | 16:09:00 |  | 17:58:00 | 18:25:00 |  |  | 7
2018-04-30 00:00:00 | TJ | 7 | USPS | 6:22:00 | 6:41:00 |  | 9:19:00 | 14:42:00 |  | 17:53:00 | 18:00:00 |  |  | 8
2018-05-01 00:00:00 | TJ |  | Animal | 5:58:00 |  | 0:00:00 |  |  |  |  | 15:36:00 | 0:00:00 |  | 5
2018-05-02 00:00:00 | TJ |  |  | 6:12:00 |  | 0:00:00 |  |  |  |  | 13:10:00 | 0:00:00
2018-05-03 00:00:00 | TJ | 2 | [NAME] | 6:10:00 | 6:46:00 |  | 9:30:00 | 14:02:00 |  | 14:47:00 | 15:07:00 |  |  | 8
2018-05-04 00:00:00 | TJ | 7 | Family Dollar | 5:56:00 | 7:20:00 |  | 9:12:00 | 13:23:00 |  | 14:15:00 | 16:27:00
 | TJ Total
2018-04-29 00:00:00 | [NAME] | 3 | Walmart | 18:55:00 | 19:42:00 |  | 22:30:00 | 4:52:00 |  | 6:16:00 | 6:22:00 |  |  | 36
2018-04-30 00:00:00 | [NAME] |  | Walmart | 19:14:00 | 20:03:00 |  | 21:52:00 | 7:22:00 |  | 8:28:00 | 9:37:00
2018-05-01 00:00:00 | [NAME] |  | Walmart | 19:55:00 | 22:19:00 |  | 12:19:00 | 9:02:00 |  | 10:39:00 | 9:26:00 | 0:00:00
2018-05-02 00:00:00 | [NAME] |  | Walmart | 18:52:00 | 19:33:00 |  | 22:56:00 | 9:13:00 |  | 10:42:00 | 11:08:00
2018-05-03 00:00:00 | [NAME] |  | Walmart | 18:23:00 | 19:28:00 |  | 22:42:00 | 7:35:00 |  | 9:28:00 | 10:29:00
 | [NAME]
2018-04-30 00:00:00 | Willie | 10 | Adventist | 6:00:00 | 7:57:00 |  | 10:11:00 | 13:46:00 |  |  |  |  |  | 8
2018-04-30 00:00:00 | Willie | 10 | Bainbridge |  |  |  | 8:29:00 | 9:31:00 |  | 14:57:00 | 15:07:00 |  |  | 8
2018-05-02 00:00:00 | Willie | 10 | Animal | 7:30:00 | 8:56:00 |  | 9:48:00 | 11:02:00 |  |  | 15:30:00 | 0:00:00 |  | 3
2018-05-03 00:00:00 | Willie | 10 | Heritage ills | 5:52:00 | 7:08:00 |  | 9:03:00 | 15:20:00 |  | 16:24:00 | 16:30:00 |  |  | 8 | 1
2018-05-04 00:00:00 | Willie | 10 | Family Dollar | 6:00:00 | 6:32:00 |  | 8:58:00 | 13:55:00 |  | 15:59:00 | 16:30:00 |  |  | 6
 | Willie Total
2018-04-30 00:00:00 | [NAME] | 15 | Adventist | 6:03:00 | 10:38:00 |  | 11:28:00 | 14:04:00 |  | 14:59:00 | 15:07:00 |  |  | 8
2018-05-02 00:00:00 | [NAME] | 15 | Ashton | 5:51:00 | 8:14:00 |  | 10:34:00 | 14:15:00 |  | 15:04:00 | 15:00:00 | 0:00:00 |  | 7
2018-05-03 00:00:00 | [NAME] | 15 | Legacy | 6:00:00 | 7:58:00 |  | 9:42:00 | 10:08:00 |  |  |  |  |  | 8
2018-05-03 00:00:00 | [NAME] | 15 | USPS |  |  |  | 10:52:00 | 13:47:00 |  | 15:33:00 | 16:33:00 |  |  | 5
2018-05-04 00:00:00 | [NAME] | 15 | Adventist | 5:58:00 | 7:41:00 |  | 8:09:00 | 10:25:00
2018-05-04 00:00:00 | [NAME] | 15 | The Strand |  |  |  | 13:48:00 | 16:42:00 |  | 16:45:00 | 16:17:00 | 0:00:00
 | Willie S Total
 | Grand Total