Hi,

I have a list of times, automatic data was taken every 15 seconds (I have
over 5,000 rows of data).

I need to show only times that end in 00, so a whole minute.

Column A
row 1 Time
row 2 00:00:00
row 3 00:00:15
row 4 00:00:30
row 5 00:00:45
row 6 00:01:00

In this example only rows 2 and 6 would be returned.

Any suggestions.

Thanks