logical test problems creating formula

[xcelvogelsong]

I have multiple time frames and am trying to create a logical test that will return true if the time given is within the two times. any ideas

 

[mgirvin]

Something like this gives you the idea of how to check whether a time is between an upper and lower time:

Excel Workbook
	A	B	C	D
1	Time	Is Time Between Upper and Lower		Lower Time
2	2:00 AM	FALSE		4:15 AM
3	5:15 AM	TRUE		Upper Time
4	6:00 PM	TRUE		7:33 PM
5	2:33 PM	TRUE
6
...

Cell Formulas
Range	Formula
B2	=AND(A2>=$D$2,A2<=$D$4)
B3	=AND(A3>=$D$2,A3<=$D$4)
B4	=AND(A4>=$D$2,A4<=$D$4)
B5	=AND(A5>=$D$2,A5<=$D$4)

 

[xcelvogelsong]

you are right, this formula does work for one time frame, I have multiple time frames that i need to find out if one given time fits into any of them

 

[mgirvin]

Maybe this:

Here is the data, assumptions and formulas (formulas in green cells):

Excel Workbook
	A	B	C	D	E	F
1	Time	Is Time Between Upper and Lower		Lower Time	Lower Time	Lower Time
2	2:00 AM	FALSE		4:15 AM	4:15 PM	5:53 PM
3	5:15 AM	TRUE		Upper Time	Upper Time	Upper Time
4	6:00 PM	TRUE		7:33 AM	5:33 PM	7:33 PM
5	2:33 PM	FALSE
6
...

Enter this formula in B2 and copy down:

=OR(AND(A2>=$D$2,A2<=$D$4),AND(A2>=$E$2,A2<=$E$4),AND(A2>=$F$2,A2<=$F$4))



Picture of formula:

Excel Workbook
	B
2	FALSE
...

Cell Formulas
Range	Formula
B2	=OR(AND(A2>=$D$2,A2<=$D$4),AND(A2>=$E$2,A2<=$E$4),AND(A2>=$F$2,A2<=$F$4))