VBA autofilter time > greater than 15 secconds

[logandiana]

I have a column that is in text format with entries like 00:01:22, 00:00:38, 00:10:55, 00:00:09, etc.
These are times as in hours:minutes:seconds.
I need to put a filter on these and filter anything that is greater than 15 seconds, i.e. ' > 00:00:15 '
I tried the recorder, but couldn't make it work.

Thank

 

[CalcSux78]

try:

Sub SetFilter()

ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=1, Criteria1:=">00:00:15"
End Sub