I have a sheet with a list of part numbers and the time it takes to make each
part. On another sheet, I have a list of part numbers with the quanity due
and and due date. I am trying to find out a way to calculate the total hours
need to make all parts in a given week, month, quarter, etc...

Ktran -

You say you have the part numbers and the time it takes to make each one.
How is this time stored? If it is in decimal hours (e.g. 2.5 = 2 hours 30
minutes, 0.75 = 45 minutes, etc.), then you can multiply the number of parts
needed by the hours per part. You can do a VLOOKUP from the sheet giving the
quantity and due date into the sheet with the part numbers and time to get
the time per part, and multiply it by the number needed.

If you need more help, give us more details, and where your struggle is.
--
Daryl S


"Ktran" wrote:

I have a sheet with a list of part numbers and the time it takes to make each
part. On another sheet, I have a list of part numbers with the quanity due
and and due date. I am trying to find out a way to calculate the total hours
need to make all parts in a given week, month, quarter, etc...