alter function dbo.ConvertToTime(@val as int =0) returns nvarchar(10) as begin declare @min int = 0; declare @hour int = 0; declare @hourCount int = 2; SET @min = @val % 60; SET @hour = @val / 60; SET @hourCount = (@val / 1440) + 1; if(@val < 6000) begin set @hourCount = 2 end else if(@val >= 6000 and @val < 60000) begin set @hourCount = 3 end else begin set @hourCount = len(@val)-1; end declare @res as nvarchar(10)= right('0000'+cast(@hour as varchar),@hourCount) + ':' + right('0'+CAST( @min as varchar) , 2); return @res; end