IF statement to identify >or < time values

[mattmac75]

I would like to write an IF statement that would allow me to identify the times great than :20 and less than 5:00

This would allow me to filter only on those entries

Between stops
0:03
0:12
0:00
1:59
0:28
0:15
0:14
0:00
0:06
0:09

 

[FormR]

Hi, try:

Excel 2012
	A	B
2	00:03	FALSE
3	00:12	FALSE
4	00:00	FALSE
5	01:59	TRUE
6	00:28	TRUE
7	00:15	FALSE
8	04:59	TRUE
9	00:00	FALSE
10	00:06	FALSE
11	00:09	FALSE
Sheet1

Cell Formulas
Range	Formula
B2	=AND(A2>"00:20"+0,A2<"05:00"+0)

 

[mattmac75]

Thanks, just what I needed