Filter time on one column between 05:00 AM to 00:00 AM (exclude time between 5AM-00AM)

[Gwhaou]

Hi,

I need some help I know, it's possible to use macro to filter data from one column actualy I use this type of code to filter one specific data from one column

Sheets("Sheet_1").Range("A1").AutoFilter Field:=1, Criteria1:="05:00"

With this code I can took all the data with the time 5 AM from the column, And It works. But in my data sheet on this column i have a bunch of time data. I want a macro to filter only data between 05:00 AM to 00:00 AM. Is possible to tell that with AutoFilter ?

 

[Anthony47]

Maybe:

Sheets("Sheet_1").Range("A1").AutoFilter Field:=1, Criteria1:=">=" & TimeValue("05:00"

This should show all the times between 5:00 and 23:59:59

 

[Gwhaou]

Maybe:

Sheets("Sheet_1").Range("A1").AutoFilter Field:=1, Criteria1:=">=" & TimeValue("05:00"

This should show all the times between 5:00 and 23:59:59

Thanks it works perfectly , got a last question, just to understand the code.
If I want time between 5 AM an 22:59:59 PM how would you write that ?

 

[Alex Blakenburg]

    Sheets("Sheet_1").Range("A1").AutoFilter Field:=1, Criteria1:=">=" & TimeValue("05:00"), _
                    Operator:=xlAnd, Criteria2:="<" & TimeValue("23:00")