Date and Time auto filtering

[Thomas_angu]

Hi guys, I'm still new to excel VBA.

My excel consists of different days and different timing. I would like to auto-filter the same day but in different timing in one sheet and another day to another sheet. The time is at column L with the format (dd/mm/yyyy 5:48:58 AM).

 

[mole999]

In helper cells
=text(L(and the number),"dddd") will produce days spelt
=text(L(and the number),"mm") will produce month number
=text(L(and the number),"dddd") will produce month name
=text(L(and the number),"h") will produce hour of day

if you put them next to each other you could pull Thursday and 5pm for instance from filters

 

[Thomas_angu]

Thanks for the reply.

For example the data is shown like this. Can I know the coding to apply for auto filter the date as shown in the image?

 

[mole999]

you could use =text(L(and the number),"dd/mm/yyyy") or =text(L(and the number), "yyyy/mm/dd")