Spreadsheet: 789175d1658982667-trying-to-figure-out-job-costs-using-an-export-from-a-time-sheet-time-export2
Sheet: Sheet1

Period 6/1/2022-7/14/2022
User ID | Name | Day | Job | Time In | Note In | Time Out | Note Out | Regular | Total
16 | [NAME] | Wed June 1/2022 | Travel | 09:11:00 |  | 10:48:00 |  | 01:37:00 | 01:37:00 | ACME
16 | [NAME] | Wed June 1/2022 | ACME | 10:48:00 |  | 16:44:00 |  | 05:56:00 | 05:56:00
16 | [NAME] | Wed June 1/2022 | Travel | 16:44:00 |  | 17:57:00 |  | 01:13:00 | 01:13:00 | Acme
16 | [NAME] | Thu June 2/2022 | Travel | 08:52:00 |  | 11:31:00 |  | 02:39:00 | 02:39:00 | Door Repair
16 | [NAME] | Thu June 2/2022 | Door Repair | 11:32:00 |  | 16:29:00 |  | 04:57:00 | 04:58:00
16 | [NAME] | Thu June 2/2022 | Travel | 16:29:00 |  | 18:56:00 |  | 02:27:00 | 02:27:00 | Door Repair
16 | [NAME] | Fri June 3/2022 | CBT Suite 103 | 09:02:00 |  | 12:18:00 |  | 03:16:00 | 03:16:00
16 | [NAME] | Fri June 3/2022 | [NAME] | 12:19:00 |  | 14:45:00 |  | 02:26:00 | 02:27:00
16 | [NAME] | Fri June 3/2022 | New Building | 14:45:00 |  | 16:28:00 |  | 01:43:00 | 01:43:00
16 | [NAME] | Sat June 4/2022 | Travel | 12:00:00 |  | 18:00:00 |  | 06:00:00 | 06:00:00 | City Doors
16 | [NAME] | Sat June 4/2022 | City Doors | 21:30:00 |  | 00:30:00 |  | 03:00:00 | 03:00:00
16 | [NAME] | Sun June 5/2022 | Travel | 11:16:00 |  | 16:22:00 |  | 05:06:00 | 05:06:00 | City Doors
16 | [NAME] | Tue June 7/2022 | Training | 09:20:00 |  | 11:29:00 |  | 02:09:00 | 02:09:00
16 | [NAME] | Tue June 7/2022 | CC Fire Job | 11:30:00 |  | 16:38:00 |  | 05:08:00 | 05:09:00
16 | [NAME] | Tue June 7/2022 | Travel | 16:39:00 |  | 17:23:00 |  | 00:44:00 | 00:45:00 | Door Repair
16 | [NAME] | Tue June 7/2022 | Door Repair | 17:57:00 |  | 19:19:00 |  | 01:22:00 | 01:50:00
16 | [NAME] | Wed June 8/2022 | Travel | 09:02:00 |  | 10:47:00 |  | 01:45:00 | 01:45:00 | Fire Issues
16 | [NAME] | Wed June 8/2022 | Fire Issues | 10:48:00 |  | 15:47:00 |  | 04:59:00 | 05:00:00
16 | [NAME] | Wed June 8/2022 | Travel | 17:41:00 |  |  |  | 00:00:00 | 00:29:00 | Fire Issues
16 | [NAME] | Thu June 9/2022 | CC Fire Job | 09:25:00 |  | 13:58:00 |  | 04:33:00 | 04:33:00
16 | [NAME] | Thu June 9/2022 | CC Fire Job | 18:26:00 |  | 19:51:00 |  | 01:25:00 | 01:25:00
16 | [NAME] | Thu June 9/2022 | organ Emergency | 21:56:00 |  | 22:35:00 |  | 00:39:00 | 00:39:00
16 | [NAME] | Fri June 10/2022 | Travel | 09:53:00 |  | 15:12:00 |  | 05:19:00 | 05:19:00 | Unknown
16 | [NAME] | Fri June 10/2022 | Travel | 15:12:00 |  | 18:49:00 |  | 03:37:00 | 03:37:00 | Unknown
16 | [NAME] | Tue June 14/2022 | [NAME] | 08:34:00 |  | 11:28:00 |  | 02:54:00 | 02:54:00
16 | [NAME] | Tue June 14/2022 | Travel | 11:28:00 |  | 11:28:00 |  | 00:00:00 | 00:00:00
16 | [NAME] | Tue June 14/2022 | Travel | 12:58:00 |  | 12:58:00 |  | 00:00:00 | 00:00:00
16 | [NAME] | Tue June 14/2022 | Don't Know | 12:59:00
11 | [NAME] | Tue June 14/2022 | Addtl access | 14:20:00 |  | 14:23:00 |  | 00:03:00 | 00:03:00
11 | [NAME] | Tue June 14/2022 | Fire Inspection | 16:42:00 |  | 16:43:00 |  | 00:01:00 | 00:01:00
11 | [NAME] | Tue June 14/2022 |  | 18:00:00 |  | 18:01:00 |  | 00:01:00 | 00:01:00
11 | [NAME] | Tue June 14/2022 | Bad Fixture | 19:45:00 |  | 19:45:00 |  | 00:00:00 | 00:00:00
11 | [NAME] | Tue June 14/2022 | Travel | 20:29:00 |  |  |  | 00:00:00 | 00:00:00
11 | [NAME] | Wed June 15/2022 | Bad Fixture | 09:27:00 |  | 13:53:00 |  | 04:26:00 | 04:26:00
11 | [NAME] | Wed June 15/2022 | Travel | 13:53:00 |  | 15:09:00 |  | 01:16:00 | 01:16:00 | 3 items
11 | [NAME] | Wed June 15/2022 | 3 items | 15:09:00 |  | 16:41:00 |  | 01:32:00 | 01:32:00
11 | [NAME] | Wed June 15/2022 | Travel | 16:41:00 |  | 17:47:00 |  | 01:06:00 | 01:06:00 | 3 items
11 | [NAME] | Thu June 16/2022 | Travel | 09:32:00 |  | 11:03:00 |  | 01:31:00 | 01:31:00 | 3 items
11 | [NAME] | Thu June 16/2022 | 3 items | 11:03:00 |  | 15:42:00 |  | 04:39:00 | 04:39:00
11 | [NAME] | Thu June 16/2022 | Travel | 15:43:00 |  | 17:25:00 |  | 01:42:00 | 01:43:00
11 | [NAME] | Fri June 17/2022 | P Doors | 09:43:00 |  | 13:05:00 |  | 03:22:00 | 03:22:00
11 | [NAME] | Fri June 17/2022 | Travel | 13:06:00 |  | 15:10:00 |  | 02:04:00 | 02:05:00
11 | [NAME] | Fri June 17/2022 | Shore Pointe | 15:11:00 |  | 17:27:00 |  | 02:16:00 | 02:17:00
11 | [NAME] | Fri June 17/2022 | Travel | 17:27:00 |  | 18:34:00 |  | 01:07:00 | 01:07:00
11 | [NAME] | Mon June 20/2022 | Travel | 13:55:00 |  | 15:48:00 |  | 01:53:00 | 01:53:00
11 | [NAME] | Mon June 20/2022 | CC Fire Job | 15:48:00 |  | 21:18:00 |  | 05:30:00 | 05:30:00
11 | [NAME] | Tue June 21/2022 | CC Fire Job | 09:00:00 |  |  |  | 00:00:00 | 00:00:00
11 | [NAME] | Wed June 22/2022 | CC Fire Job | 09:30:00 |  | 15:20:00 |  | 05:50:00 | 05:50:00
11 | [NAME] | Wed June 22/2022 | Quote Job | 15:21:00 |  | 16:07:00 |  | 00:46:00 | 00:47:00
11 | [NAME] | Wed June 22/2022 | Travel | 16:08:00 |  | 17:24:00 |  | 01:16:00 | 01:17:00
11 | [NAME] | Thu June 23/2022 | Deal Fire | 12:31:00 |  | 14:21:00 |  | 01:50:00 | 01:50:00
11 | [NAME] | Thu June 23/2022 | Fire Iss | 14:22:00 |  | 16:15:00 |  | 01:53:00 | 01:53:00
11 | [NAME] | Thu June 23/2022 | Travel | 16:16:00 |  | 17:12:00 |  | 00:56:00 | 00:56:00
11 | [NAME] | Thu June 23/2022 | Acme Cameras | 17:12:00 |  | 17:27:00 |  | 00:15:00 | 00:15:00
11 | [NAME] | Thu June 23/2022 | Travel | 17:27:00 |  | 17:44:00 |  | 00:17:00 | 00:17:00
11 | [NAME] | Fri June 24/2022 | Deal Fire | 09:30:00 |  | 18:42:00 |  | 09:12:00 | 09:12:00