Hi. I need some help setting a formula for the following:

Info on Sheet1

Operation Item A Item B Item C
1.Cut 10 min 12 min 15 min
2.Trim 22 min 19 min 17 min
3. Polish 13 min 14 min 16 min

Info on Sheet2
01/11 02/11 03/11
Item A 9 units 5 units 5 units
Item B 0 units 2 units 3 units
Item C 0 units 2 units 1 unit

Info required on Sheet3
01/11 02/11 03/11
1. Cut (tot min) (tot min) (tot min)
2. Trim (tot min) (tot min) (tot min)
3. Polish (tot min) (tot min) (tot min)

Sheet1 contains the info for each operation for the different items
Sheet2 contains a schedule of how many per day of each item is built
Sheet3 must contain a daily summary of operations times per item x build
schedule.

Let me know if you need more info and I'll forward you a spreadsheet if have
been working on.

Thank you & kind regards
Greg