﻿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