If Functions For Dyanmic Drop List

[MZING81]

Hello everyone,

Thanks for all the help that I have receievd since being a memeber.
have a 5 data validation lists on one sheet. They each have specifi
criteria referencing another sheet, but it only a small portio
functions. I have an if formula for an hourly staffing report, tha
refereneces each indivual day in the week, but only works on sunday.


=IFERROR(IF('SCHEDULE WEE
ONE'!$J5="","",IF(AND(ISNUMBER(SEARCH($P$15,'SCHEDULE WEE
ONE'!$L5)),SEARCH($P$19,'SCHEDULE WEEK ONE'!$C5),SEARCH($P$23,'SCHEDUL
WEEK ONE'!$E5),SEARCH($P$27,'SCHEDULE WEE
ONE'!$F5),SEARCH($P$31,'SCHEDULE WEEK ONE'!$G5)),(RIGHT('SCHEDULE WEE
ONE'!$J5,1))+0,"")),"")


I want it to pull a start shift time and end shift time to match th
criteria. I have two columns that are one for start time, and end tim
and another thats combined. the one shown is combined. This one doesn
not pull the end shift time! Hopefully I explained this properly. Als
should I use something other than data validation list

 

[MZING81]

Hello everyone,

Thanks for all the help that I have receievd since being a memeber.
have a 5 data validation lists on one sheet. They each have specifi
criteria referencing another sheet, but it only a small portio
functions. I have an if formula for an hourly staffing report, tha
refereneces each indivual day in the week, but only works on sunday.


=IFERROR(IF('SCHEDULE WEE
ONE'!$J5="","",IF(AND(ISNUMBER(SEARCH($P$15,'SCHEDULE WEE
ONE'!$L5)),SEARCH($P$19,'SCHEDULE WEEK ONE'!$C5),SEARCH($P$23,'SCHEDUL
WEEK ONE'!$E5),SEARCH($P$27,'SCHEDULE WEE
ONE'!$F5),SEARCH($P$31,'SCHEDULE WEEK ONE'!$G5)),(RIGHT('SCHEDULE WEE
ONE'!$J5,1))+0,"")),"")


I want it to pull a start shift time and end shift time to match th
criteria. I have two columns that are one for start time, and end tim
and another thats combined. the one shown is combined. This one doesn
not pull the end shift time! Hopefully I explained this properly. Als
should I use something other than data validation list?


Here's a sample, it should have start and times based on criteri
selected from the data validation lists. Also I would like to add
selection for ALL criteria's, and to calculate the number of individual
on the right side beside and below the times.

Solved the main issue with the function, but for whatever reason th
times that were extraced are about a minute and some seconds off.

MZING8

+-------------------------------------------------------------------
+-------------------------------------------------------------------