Sumproduct-um the downtime

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

I would use an array formula (ctrl+shift +enter)

A=Product
B=Start time
C=end time

=SUM(IF(A1:A10="driwall",IF(C1:C10<B1:B10,(1+C1:C10)-B1:B10,C1:C10-B1:B10)))

=SUM(IF(A1:A3="hardwall",IF(C1:C3<B1:B3,(1+C1:C3)-B1:B3,C1:C3-B1:B3)))


let me know if this works

Hi Pete

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

Cheers
JulieD

"Pete" <[email protected]> wrote in message
news:[email protected]...
>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