Sum time with criteria of 3 arrays

On the Sunday page I need to solve Q2:Q8, and S2:S8 Using the Table Below

I need to extract into Q2 all the "Line" (pink) hours used between 5am-4pm

in S2 all the 'Line" (pink) hours used Between 4pm-1am

Job Class go into Detail on the Data page

P2:P8 all are the List Names for each Job class with is our lookup

Sum it up

Q2= find(Jobs in "(P2) Line" that are =>5am but <4pm), from "Positions(S19:S41)" Col, Sum all the time for that Job Class between =>5am but <4pm and put in Q2)

Q2=18.00 Hours

Is this too complex should I give up?

Here you go

that dosent matter those ones work right

its the ones to the left of that need help

I cut out that part of the work sheet because I could not change it to 03 and upload it.


replace the above example with B=Q and D=S

B2=Summproduct(--(if(and(match(List),within array,0),Time_in>5am,Time_out<4pm)

Problem is match only takes the first instance of the Job
so if i have 4 Assemblers then it only counts 1 in this formula

this should =18.00 hours

Bump I really need some help on this one.

try another bump