Calculate Sum of total Time (Working Hours) in SQL Server

Hi Danny,

 Please refer below Query.

 SQL

DECLARE @Temp AS TABLE (Time VARCHAR(20))
INSERT INTO @Temp VALUES('04.00.00')
INSERT INTO @Temp VALUES('03.06.00')
INSERT INTO @Temp VALUES('03.09.00')
SELECT  
REPLACE(CAST(DATEADD(MILLISECOND, SUM(DATEDIFF(MILLISECOND, 0, CAST(REPLACE(Time,'.',':') AS DATETIME))), 0) AS TIME(0)),':','.') AS SumTime
FROM @Temp

Output

Sum time

10.15.00