thanks for the help... i used this one and modify some part and it gives me the answer that i wanted. thanks a lot....

SELECT CONVERT(char(5),

DATEADD(minute, (u_techOutTime...