Sumproduct

P

Pete

I wish to be able to sum the downtime incurred on shift
for each product. I can do this if we only manufacture
the particular product once per shift. What I would like
is to sum the downtime incurred between a particular time.

e.g

Driwall 22:00 - 23:00
Hardwall 23:00 - 01:00
Driwall 01:00 - 05:00

In between these times there may be some downtime so I
want to know the actual time run on each product each time

Hope this makes sense

Pete
 
J

JulieD

Hi Pete

need more details - where/how is your downtime listed? ...

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if night shift by start & end time 2
SUMPRODUCT 2
Sum 7
Calculating Times for Pay Rates 4
Pls help for Simple Calculation 1
LOOKUP PROBLEM 7
Formatting Date Field 5
Sum product 3

Top