Ok. Here is an example, again using the same hack. I am hoping someone else will have a better solution than this, but this does work:CREATE TABLE #tmp(d TIME);
INSERT INTO #tmp VALUES ('14:00:20'),('16:39:53'),('16:39:53')
SELECT DATEDIFF(dd,0,col1) AS Days, CAST(col1 AS TIME) AS HoursMinutesSeconds
FROM
(
SELECT CAST(SUM(CAST(CAST(d AS DATETIME) AS FLOAT)) AS DATETIME) AS col1
FROM #tmp
) s