如何找到总小时数 [英] How to find sum total of hours

问题描述

我有一个数据类型为NUMERIC（5,2）的小时列，值为：01.25,02.30,05.56,00.50



现在我想要总时间和分钟的总结就像答案是：10.41使用sql server



任何人都能帮助我吗？

Hi,
I Have a Hours column with data type NUMERIC(5,2) and values are Like: 01.25, 02.30, 05.56, 00.50

Now I Want To SUM of This Total Hours and Minutes Like Answer is : 10.41 using sql server

Can anybody plz help me ?

推荐答案

请参阅此 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'

这篇关于如何找到总小时数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！