Sum Total of Time in SQL Server

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