title: Sum of hour and minutes in SQL Server 2008
body: <p>I have written one query,but it not giving correct answer.I want to display like this
   5 Hour 58 minutes + 7 Hour 58 minutes=13 hour 56 minutes(answer should <code>13.56</code>),but this below query giving <code>15.09</code> .</p>
  
  <p>Please reply me with any other solution.(here <code>Effort1</code> is 5 Hour column,<code>Effort1Minutes</code> is 58 minute column and same  <code>Effort2</code>  is 7 Hour column,<code>Effort2Minutes</code> is 58 minute column .</p>
  
  <pre><code> 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
  </code></pre>