How would you write a formula to calculate the total hours in sheet1. Thanks
in advance!! I'm trying to match whats on sheet2 with the part number on
sheet1. Example: Once RT-005 is entered on sheet1 it will automatically
calculate the hours on sheet1 using the information on sheet2
Sheet1
Part # Qty Needed Qty in Stock Hours
RT-005 70 100 ?

Sheet2
Part Number/ Ring Qty. / Qty. Per Ring /Tumblers Available/ Tumble Time in
Hours
RT-005 1 20 1
3