how do i search for a specific time range in excel?

[Guest]

for example: i want to find items that are between 11:01 pm and 07:00 am

 

[Frank Kabel]

Hi
have you tried using a filter ('Data - filter')?

 

[David McRitchie]

=OR(MOD(A18,1)>TIME(23,1,0),MOD(A18,1)<=TIME(7,0,0))

or

=OR(MOD(A18,1)>TIMEVALUE("23:01"), MOD(A18,1)<=TIMEVALUE("7:00"))