title: How to sum times from Time datatype columns in hh:mm:ss?
body: <p>I have a SQL Server table with 4 columns (<code>TIME(0)</code> datatype).</p>
  
  <p>Each row correspond to a day so I have:</p>
  
  <pre><code>Col Time 1 -------- Col Time 2 ------ Col Time 3
  
  '03:23:12' -------- '21:33:04' ------ '07:44:11'
  '21:14:45' -------- '12:43:44' ------ '01:56:43'
  '15:22:36' -------- '19:33:55' ------ '04:03:11'
  '08:21:46' -------- '01:23:14' ------ '06:09:11'
  </code></pre>
  
  <p>I want to <code>SUM</code> each column so I can get the <em>total hours, minutes and seconds</em> (<code>hh:mm:ss</code>).</p>
  
  <p>So for example for <code>Col Time 1</code> I should have:</p>
  
  <pre><code>48:54:46
  </code></pre>