• declare @time int

    set @time = 70

    select cast((@time / 60) as varchar(2)) + ':' + cast((@time % 60) as varchar(2))