=Lookup(Multiple names in a array) return the number of hours between 2 times

I uploaded the workbook and I need to solve for Q2 and all the other empty cells around there.

THE formula goes somthing like this

P2-P7 is the list name we are looking up under that list is the diffrent positions that are listed in the S colunmb starting at S19.

The list names are listed in the data page

so basied of the List name we need to find all the Positions names listed, and returns how many of thier hours fall between 5am-4pm, and how many of thier hours fall between 4pm-1am Basicly calculating how much labor hours are spent for the day shift and how much labor hours are spent for the night shift.

So in this example Lets take "Line" we have

1 Appetizer S29
1 Grill S39
3 Assembler S26, S31, S38
2 Saute S36, S37
1 Pasta S25,

now form there I just need total hours used before 4pm in Q2, and the hours used after 4pm in S2, for each of the above names using the list lookup name as the referance.


Sorry for the short story 5th time I posted....