IF EXISTS(SELECT NAME FROM sysobjects s WHERE s.name='fCalculateWatch') DROP FUNCTION fCalculateWatch GO CREATE FUNCTION fCalculateWatch(@StringSaat nvarchar(5), @Tedad INT) RETURNS nvarchar(5) AS BEGIN declare @Res nvarchar(5); declare @Saat int; declare @Min int; declare @MinTemp int; set @Saat = cast( left( @StringSaat ,2 ) as int) * @tedad; set @Min = cast( right( @StringSaat ,2 ) as int) * @tedad; if( @min = 60) begin set @res = RIGHT('00' + (cast(@Saat as nvarchar) + 1) , 2) + ':00'; end else if(@min < 60 ) begin set @res = RIGHT('00' +cast(@Saat as nvarchar), 2) + ':' + RIGHT('00' + cast(@min as nvarchar) , 2) ; end else if( @min > 60 ) begin set @MinTemp = @min / 60; set @Saat = @Saat + @MinTemp; set @MinTemp = @min % 60; set @Res = RIGHT('00' + cast(@Saat as nvarchar) , 2) + ':' + RIGHT('00' + cast( @MinTemp as nvarchar) , 2) end return @res ; END --select dbo.fCalculateWatch('01:00', 10 );