Help with completeing my production report.

dkellch

New Member
Joined
Jul 18, 2014
Messages
2
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. [TABLE="width: 741"]
<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>[TR]
[TD="class: xl66, width: 82, bgcolor: #F4F0E6"]7/8/2014[/TD]
[TD="class: xl67, width: 57, bgcolor: #F4F0E6"]120[/TD]
[TD="class: xl67, width: 51, bgcolor: #F4F0E6"]16[/TD]
[TD="class: xl67, width: 61, bgcolor: #F4F0E6"]104[/TD]
[TD="class: xl69, width: 67, bgcolor: #F4F0E6"]17.27[/TD]
[TD="class: xl68, width: 48"]13%[/TD]
[TD="class: xl65, width: 63"]TM3[/TD]
[TD="class: xl65, width: 106"]Eric Cole[/TD]
[TD="class: xl65, width: 33"]B[/TD]
[TD="class: xl65, width: 45, align: right"]10687[/TD]
[TD="class: xl63, width: 55, align: right"]4.5[/TD]
[TD="class: xl63, width: 68, align: right"]11.6[/TD]
[TD="class: xl63, width: 82"]LC[/TD]
[TD="class: xl63, width: 73, align: right"]6.95[/TD]
[TD="class: xl70, width: 94"]Qep[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/8/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]67[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]67[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]25.12[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM1[/TD]
[TD="class: xl63"]Will Conway[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl65, align: right"]10687[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]LC[/TD]
[TD="class: xl63, align: right"]2.6666667[/TD]
[TD="class: xl70"]Qep[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/9/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]19[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]19[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]17.54[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM1[/TD]
[TD="class: xl63"]Will Conway[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl65, align: right"]10687[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]LC[/TD]
[TD="class: xl63, align: right"]1.0833333[/TD]
[TD="class: xl70"]Qep[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/2/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]192[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]192[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]26.48[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM6[/TD]
[TD="class: xl63"]Eric Cole[/TD]
[TD="class: xl63"]B[/TD]
[TD="class: xl63, align: right"]12734[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]7.25[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/3/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]33[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]4[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]29[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]22.00[/TD]
[TD="class: xl68"]12%[/TD]
[TD="class: xl63"]TM6[/TD]
[TD="class: xl63"]Chris Ray[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl63, align: right"]12734[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]1.5[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/3/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]36[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]36[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]24.00[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM5[/TD]
[TD="class: xl63"]Chris Ray[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl63, align: right"]12734[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]1.5[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/2/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]45[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]2[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]43[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]24.55[/TD]
[TD="class: xl68"]4%[/TD]
[TD="class: xl63"]TM6[/TD]
[TD="class: xl63"]Chris Ray[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl63, align: right"]12734[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]1.8333333[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/9/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]115[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]1[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]114[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]21.90[/TD]
[TD="class: xl68"]1%[/TD]
[TD="class: xl63"]TM5[/TD]
[TD="class: xl63"]Chris Ray[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl63, align: right"]12760[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]5.25[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/9/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]128[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]2[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]126[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]18.73[/TD]
[TD="class: xl68"]2%[/TD]
[TD="class: xl63"]TM5[/TD]
[TD="class: xl63"]Eric Cole[/TD]
[TD="class: xl63"]B[/TD]
[TD="class: xl63, align: right"]12760[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]6.8333333[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/9/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]118[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]118[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]21.78[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM6[/TD]
[TD="class: xl63"]Chris Ray[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl63, align: right"]12761[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]5.4166667[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/10/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]14[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]14[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]14.00[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM6[/TD]
[TD="class: xl63"]Josh Hicks[/TD]
[TD="class: xl63"]B[/TD]
[TD="class: xl63, align: right"]12761[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/10/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]170[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]2[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]168[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]21.94[/TD]
[TD="class: xl68"]1%[/TD]
[TD="class: xl63"]TM6[/TD]
[TD="class: xl63"]Chris Ray[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl63, align: right"]12761[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]7.75[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/10/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]40[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]40[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]8.89[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM4[/TD]
[TD="class: xl63"]Tom Jackson[/TD]
[TD="class: xl63"]B[/TD]
[TD="class: xl63, align: right"]12762[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/10/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]101[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]2[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]99[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]21.26[/TD]
[TD="class: xl68"]2%[/TD]
[TD="class: xl63"]TM5[/TD]
[TD="class: xl63"]Eric Cole[/TD]
[TD="class: xl63"]B[/TD]
[TD="class: xl63, align: right"]12762[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]4.75[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/10/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]148[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]148[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]23.68[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM5[/TD]
[TD="class: xl63"]Chris Ray[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl63, align: right"]12762[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]6.25[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/9/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]14[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]14[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]20.00[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM5[/TD]
[TD="class: xl63"]Eric Cole[/TD]
[TD="class: xl63"]B[/TD]
[TD="class: xl63, align: right"]12762[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]0.7[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/11/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]120[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]120[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]23.23[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM6[/TD]
[TD="class: xl63"]Chris Ray[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl63, align: right"]12763[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]5.1666667[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/10/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]181[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]1[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]180[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]28.65[/TD]
[TD="class: xl68"]1%[/TD]
[TD="class: xl63"]TM6[/TD]
[TD="class: xl63"]Josh Hicks[/TD]
[TD="class: xl63"]B[/TD]
[TD="class: xl63, align: right"]12763[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]BC[/TD]
[TD="class: xl63, align: right"]6.3166667[/TD]
[TD="class: xl70"]PPES[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/10/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]42[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]42[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]21.54[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM1[/TD]
[TD="class: xl63"]Will Conway[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl63, align: right"]12767[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]10.5[/TD]
[TD="class: xl63"]SC[/TD]
[TD="class: xl63, align: right"]1.95[/TD]
[TD="class: xl70"]Ciatation[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F4F0E6"]7/9/2014[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]16[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]0[/TD]
[TD="class: xl67, bgcolor: #F4F0E6"]16[/TD]
[TD="class: xl69, bgcolor: #F4F0E6"]21.33[/TD]
[TD="class: xl68"]0%[/TD]
[TD="class: xl63"]TM3[/TD]
[TD="class: xl63"]Tom McCaffrey[/TD]
[TD="class: xl63"]A[/TD]
[TD="class: xl63, align: right"]12769[/TD]
[TD="class: xl63, align: right"]4.5[/TD]
[TD="class: xl63, align: right"]11.6[/TD]
[TD="class: xl63"]LC[/TD]
[TD="class: xl63, align: right"]0.75[/TD]
[TD="class: xl70"]TPS[/TD]
[/TR]
</tbody>[/TABLE]
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top