Filter/Search

[Austin Lang]

Hi all,

I need to create a formula to Filter a list and return all cleanings that took place between a certain time frame. How do I go about creating a search within the filter function that will search between the two times on a certain day? Do I need to bring in an Index-Match?

This is what I have so far..

=FILTER(Form!$A$5:$AU$3000,ISNUMBER(SEARCH(

Date: 12/6/22
Time: 6:00
Time: 1800

TIA,

 

[Austin Lang]

To elaborate on the issue...

I have a master file that is used to enter in all cleans that take place within a month. On a separate tab, I want the file to create a table with all cleans that happened on a specific day and shift. Ideally, the date will always be the current date. The shifts are 0600-1800 and 1800-0600. I have created a formula that does pull all cleans conducted on the date specified. That is this:

=FILTER(Form!$A$5:$AU$3001,ISNUMBER(SEARCH('Trial Failures'!AX11,Form!$R$5:$R$3001)))

I cannot seem to find the way to add additional criteria, more specifically two times, in a way that the formula doesn't return a #value error. I have also converted the times to numbers and attempted to not reference the time cells since they will not change and I still get an error. It seems like my issue is how I am entering my additional criteria. I am not sure If I can use some other lookup function to include all the criteria I am looking for. That or find out where my mistake is currently.

This is a failed attempt. This one however does not return #value. It returns the exact same table I get on the above formula. It is ignoring the additional criteria added...

=FILTER(Form!A5:AU3001,ISNUMBER(SEARCH('Trial Failures'!AX11,Form!$R$5:$R$3001)*(Form!$S5:$S3000>AX12)*(Form!$T5:$T3000<AX13)))

Any help is strongly appreciated.