title: How to get sum of hours and minutes in sql
body: <pre><code>SELECT LEFT(CONVERT(VARCHAR(10), OutTime - InTime, 108), 5) 
  FROM Attendance 
  WHERE InTime BETWEEN '01-01-2016' AND '01-31-2016' 
  AND Employee=63 
  ORDER BY InTime
  </code></pre>
  
  <p>I have got this result.</p>
  
  <p>[<img src="https://i.stack.imgur.com/WkuLh.png" alt="table screenshot[1]"></p>
  
  <p>What I want is the sum of all the hours. And how can I write the same query in Linq?</p>