Sum Total of Time in SQL Server

Refer this i

Declare @Time int,@LoginTime datetime = '2013-10-02 23:00:00',@LogoutTime datetime = '2013-10-03 01:08:00'
 
Set @Time = DATEDIFF(Minute,@LoginTime,@LogoutTime)
 
SELECT CAST( @Time/60 AS VARCHAR(5))+ ' Hrs' + ':'+ RIGHT('0' + CAST( @Time%60 AS VARCHAR(2)), 2)+' Min' AS 'WorkingTime'

Hi satabeach,

Refer the below code.

SQL

DECLARE @tbl TABLE(CheckTime DATETIME)
INSERT INTO @tbl
SELECT '4:06' UNION ALL
SELECT '8:56' UNION ALL
SELECT '6:46' 
SELECT DATEADD(ms, SUM(DATEDIFF(ms, '00:00:00.000', CheckTime)), '00:00.000') AS SumTime FROM @tbl