declare @s1 nvarchar(400),@s2 nvarchar(400),@result nvarchar(400)
declare @t1 int,@t2 int
set @s1='152:29'
set @s2='126:56'
set @t1=left(@s1,charindex(':',@s1)-1)
set @t2=left(@s2,charindex(':',@s2)-1)
set @result=ltrim(@t1+@t2)
set @t1=right(@s1,len(@s1)-charindex(':',@s1))
set @t2=right(@s2,len(@s2)-charindex(':',@s2))
declare @s1 nvarchar(400),@s2 nvarchar(400),@result nvarchar(400)
declare @t1 int,@t2 int,@t3 int ,@t4 int,@t5 int ,@t6 int
set @s1='152:29'
set @s2='126:56'
set @t1=left(@s1,charindex(':',@s1)-1)
set @t2=left(@s2,charindex(':',@s2)-1)
set @t3=right(@s1,len(@s1)-charindex(':',@s1))
set @t4=right(@s2,len(@s2)-charindex(':',@s2))
set @t5=ltrim(@t3+@t4)/60
set @t6=ltrim(@t3+@t4)%60
set @result=ltrim(@t1+@t2+@t5)
set @result=@result+':'+ltrim(@t6)