Time column

[jpereira]

Hello,

I am trying to remove from a 1 minute interval time column all the values but the values ending on 00. I just need to keep the rows which times are,ie,12:00, 12:10, 12:20, etc.

Can you guys help? I know there was a way to look up at specific sections of a value, but I really can not remember right now.

Thanks

 

[Andrew Poulsom]

Welcome to the Board.

You can use a formula like:

=MOD(MINUTE(A2),10)=0

AutoFilter that column for FALSE and delete the visible rows.

 

[jpereira]

Thanks for the great help, fast response better than a paid service.

thanks