Hi there...
try this solution,
UPDATE tbFormat
SET Duration =
(CASE
WHEN
((Duration%60)<10)
THEN
CONVERT(VARCHAR(10),Duration/60)+':'+ CASE WHEN CONVERT(VARCHAR(10),Duration%60)<10 THEN +'0'+CONVERT(VARCHAR(10),Duration%60) END
ELSE
CONVERT(VARCHAR(10),Duration/60)+':'+CONVERT(VARCHAR(10),Duration%60)
END
)
hope this helps..
plz revert back with ur comments...