Help with completeing my production report.

[dkellch]

I currently make a production report for my company. I want to be able to calculate the down time per machine per day. I would also like to be able to filter it per operator. I do not have these sorted by day because i enter them in as a work order gets completed. The second to last column is hours worked and the forth column is the total good parts. Basicly i need to add up the time per machine per day and subtract that from 8 since we run 8 hr shifts with a day and night shift. I have a few other sheets in my workbook but this is where all the data comes from.

7/8/2014	120	16	104	17.27	13%	TM3	Eric Cole	B	10687	4.5	11.6	LC	6.95	Qep
7/8/2014	67	0	67	25.12	0%	TM1	Will Conway	A	10687	4.5	11.6	LC	2.6666667	Qep
7/9/2014	19	0	19	17.54	0%	TM1	Will Conway	A	10687	4.5	11.6	LC	1.0833333	Qep
7/2/2014	192	0	192	26.48	0%	TM6	Eric Cole	B	12734	4.5	11.6	BC	7.25	PPES
7/3/2014	33	4	29	22.00	12%	TM6	Chris Ray	A	12734	4.5	11.6	BC	1.5	PPES
7/3/2014	36	0	36	24.00	0%	TM5	Chris Ray	A	12734	4.5	11.6	BC	1.5	PPES
7/2/2014	45	2	43	24.55	4%	TM6	Chris Ray	A	12734	4.5	11.6	BC	1.8333333	PPES
7/9/2014	115	1	114	21.90	1%	TM5	Chris Ray	A	12760	4.5	11.6	BC	5.25	PPES
7/9/2014	128	2	126	18.73	2%	TM5	Eric Cole	B	12760	4.5	11.6	BC	6.8333333	PPES
7/9/2014	118	0	118	21.78	0%	TM6	Chris Ray	A	12761	4.5	11.6	BC	5.4166667	PPES
7/10/2014	14	0	14	14.00	0%	TM6	Josh Hicks	B	12761	4.5	11.6	BC	1	PPES
7/10/2014	170	2	168	21.94	1%	TM6	Chris Ray	A	12761	4.5	11.6	BC	7.75	PPES
7/10/2014	40	0	40	8.89	0%	TM4	Tom Jackson	B	12762	4.5	11.6	BC	4.5	PPES
7/10/2014	101	2	99	21.26	2%	TM5	Eric Cole	B	12762	4.5	11.6	BC	4.75	PPES
7/10/2014	148	0	148	23.68	0%	TM5	Chris Ray	A	12762	4.5	11.6	BC	6.25	PPES
7/9/2014	14	0	14	20.00	0%	TM5	Eric Cole	B	12762	4.5	11.6	BC	0.7	PPES
7/11/2014	120	0	120	23.23	0%	TM6	Chris Ray	A	12763	4.5	11.6	BC	5.1666667	PPES
7/10/2014	181	1	180	28.65	1%	TM6	Josh Hicks	B	12763	4.5	11.6	BC	6.3166667	PPES
7/10/2014	42	0	42	21.54	0%	TM1	Will Conway	A	12767	4.5	10.5	SC	1.95	Ciatation
7/9/2014	16	0	16	21.33	0%	TM3	Tom McCaffrey	A	12769	4.5	11.6	LC	0.75	TPS

<colgroup><col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;" width="57"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" width="51"> <col style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61"> <col style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;" width="67"> <col style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;" width="48"> <col style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;" width="63"> <col style="width: 80pt; mso-width-source: userset; mso-width-alt: 3876;" width="106"> <col style="width: 25pt; mso-width-source: userset; mso-width-alt: 1206;" width="33"> <col style="width: 34pt; mso-width-source: userset; mso-width-alt: 1645;" width="45"> <col style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;" width="55"> <col style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" width="68"> <col style="width: 62pt; mso-width-source: userset; mso-width-alt: 2998;" width="82"> <col style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;" width="73"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;" width="94"> <tbody>
</tbody>

 

[dkellch]

Also I am not an advanced user if you can't tell so i have no clue how to use visual basic.