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

ultraman60 · Nov 1, 2004

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

Frank Kabel · Nov 1, 2004

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

David McRitchie · Nov 1, 2004

=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"))