Spreadsheet: 721951d1614961607-formula-direction-needed-shop1
Sheet: data

date | invoice | name | job | time in | time out | total time
3-1-21 | 26193 | gage yount | full service | 13:17:07 | 13:54:13
3-1-21 | 26166 | [NAME] foulk | [NAME] service | 15:52:51 | 16:48:41 |  |  |  |  |  |  | gage
3-1-21 | 26199 | gage yount | [NAME] service | 14:20:58 | 15:00:00
3-1-21 | 26199 | gage yount | [NAME] service | 15:10:21 | 15:42:20 |  |  |  |  |  |  | start date | 2021-03-01 00:00:00
3-1-21 | 26216 | [NAME] | unit antifreeze leak | 15:20:16 | 16:40:06 |  |  |  |  |  |  | end date | 2021-03-01 00:00:00
3-2-21 | 26216 | [NAME] | [NAME] | 08:02:39 | 08:13:12
3-2-21 | 26225 | gage yount | [NAME] service | 08:01:37 | 09:03:16
3-2-21 | 26216 | [NAME] | belt check | 08:13:15 | 08:27:35
3-2-21 | 26219 | gage yount | [NAME] service | 13:34:09 | 14:40:00
3-2-21 | 26225 | gage yount | [NAME] service | 08:01:37 | 09:03:16
3-2-21 | 26240 | gage yount | [NAME] service | 09:18:30 | 09:55:50
3-2-21 | 26240 | gage yount | [NAME] service | 10:23:25 | 12:00:04
3-2-21 | 26252 | [NAME] | [NAME] | 10:28:52 | 11:59:05
3-2-21 | 26288 | [NAME] | warr grind | 14:43:37 | 14:43:37
3-2-21 | 26228 | tevor bock | basic serv | 15:17:49 | 15:53:00
2021-03-03 00:00:00 | 26319 | gage yount | full service | 11:03:00 | 11:06:03
2021-03-03 00:00:00 | 26319 | gage yount | full service | 11:20:04 | 11:47:14
2021-03-03 00:00:00 | 26323 | [NAME] | voltage reg | 03:39:15 | 04:10:52
2021-03-03 00:00:00 | 26327 | trevor bock | power steering | 13:15:14 | 13:54:25
2021-03-03 00:00:00 | 26327 | trevor bock | power steering | 14:14:25 | 16:57:56
2021-03-03 00:00:00 | 26327 | trevor bock | basic serv
2021-03-03 00:00:00 | 26331 | [NAME] | unit has a miss | 15:00:21 | 16:31:05
2021-03-03 00:00:00 | 26331 | trevor bock | unit has a miss | 08:23:19 | 09:52:30
2021-03-04 00:00:00 | 26331 | TREvor bock | unit has a miss | 11:17:45 | 11:40:41
2021-03-04 00:00:00 | 26331 | trevor bock | unti has a mi | 11:42:24 | 11:47:48
2021-03-04 00:00:00 | 26331 | [NAME] | unit has a miss | 13:10:27 | 14:35:03
2021-03-03 00:00:00 | 26331 |  | [NAME] service
2021-03-03 00:00:00 | 26333 | [NAME] | hydro service | 12:58:21 | 13:18:19
2021-03-03 00:00:00 | 26333 | [NAME] | hydro service | 13:35:01 | 14:21:31
2021-03-04 00:00:00 | 26340 | [NAME] | [NAME] service | 16:06:47 | 17:03:11
2021-03-03 00:00:00 | 26340 | gage yount | [NAME] service | 12:59:13 | 12:59:42
2021-03-04 00:00:00 | 26340 | [NAME] | shifting issue | 14:57:41 | 16:04:19
2021-03-05 00:00:00 | 26340 | [NAME] | shifting issue | 07:58:07 | 08:50:30
2021-03-03 00:00:00 | 26348 |  | [NAME] service
2021-03-03 00:00:00 | 26348 |  | check hyro [NAME]
2021-03-03 00:00:00 | 26348 |  | check headlights
2021-03-03 00:00:00 | 26349 |  | [NAME] making noise
2021-03-03 00:00:00 | 26349 |  | warranty decal
2021-03-03 00:00:00 | 26352 |  | [NAME] service
2021-03-03 00:00:00 | 26352 |  | check toe
2021-03-03 00:00:00 | 26362 | [NAME] | [NAME] | 16:11:08 | 16:20:42
2021-03-03 00:00:00 | 26373 | gage yount | basic serv | 16:07:56 | 16:25:01
2021-03-03 00:00:00 | 26376 |  | starter issue
2021-03-03 00:00:00 | 26380 |  | speedo and regulator
2021-03-03 00:00:00 | 26385 | [NAME] | torn boot | 08:31:56 | 08:58:54
2021-03-03 00:00:00 | 26385 | [NAME] | [NAME] service | 09:04:08