SQL Server 2008中小时和分钟的总和

Question

我已经写了一个查询，但它没有给出正确的答案。我想像这样显示5小时58分钟+7小时58 minutes=13小时56分钟(答案应该是13.56)，但下面的查询给出了15.09。

请回复我任何其他解决方案。(这里Effort1是5小时栏，Effort1Minutes是58分钟栏，同样的Effort2是7小时栏，Effort2Minutes是58分钟栏。

 select CAST((SUM(Effort1)*60+SUM(Effort1Minutes))/60 as float) +  
       (CAST((SUM(Effort1)*60+SUM(Effort1Minutes))% 60 as float)) / 100 +   
        CAST((SUM(Effort2)*60+SUM(Effort2Minutes))/60 as float) +  
       (CAST((SUM(Effort2)*60+SUM(Effort2Minutes))% 60 as float)) / 100               
 from TimesheetDetails

Answer 1

请在以下查询中尝试

    select CONVERT(decimal(18,2),SUM(Effort1 + Effort2)) + 
    SUM(Effort1Minutes + Effort2Minutes) / 60 + 
    CONVERT(decimal(18,2), (SUM(Effort1Minutes + Effort2Minutes) % 60) / 100.00)
from TimesheetDetails

我用SQL server 2008和SQL Fiddle对这个查询进行了测试。