Please refer below code
SQL
DECLARE @TABLE AS TABLE(id VARCHAR(50),[time] VARCHAR(50))
INSERT INTO @TABLE VALUES('1.','5:30')
INSERT INTO @TABLE VALUES('2.','5:32')
INSERT INTO @TABLE VALUES('3.','5:35')
INSERT INTO @TABLE VALUES('4.','5:37')
INSERT INTO @TABLE VALUES('5.','5:40')
SELECT * FROM @TABLE
WHERE (SUBSTRING([time],(PATINDEX('%:%',time)+1),DATALENGTH([time])) % 5) = 0
I hope this will help you out.