请参阅此 Stack Overflow 的问题：如何总结sql server中的时间字段 [ ^ ]。

See this Stack Overflow's question: "How To sum up time field in sql server"[^].

这是另一种选择。

This is another alternative.

select convert(varchar(3),SUM(s)/60) + ':' +  convert(varchar(3),SUM(s)%60)
from(
select convert(int,substring('01:25',1,2))*60 + convert(int,substring('01:25',4,2)) s
union all
select convert(int,substring('01:25',1,2))*60 + convert(int,substring('01:25',4,2)) s

) p

DECLARE @Minute1 INT
SET @Minute1 = ( SELECT DATEDIFF(MINUTE,GETDATE(),GETDATE()))
SELECT CAST( @Minute1/60 AS VARCHAR(5))+ ' Hrs' + ':'+ RIGHT('0' + CAST( @Minute1%60 AS VARCHAR(2)), 2)+' Min' AS 'WorkingTime'