title: How to select total time from three time columns (SQL Server 2008)
body: <p>I have table with columns of <strong>time(0)</strong> datatypes:</p>
  
  <pre><code>Name   TimeOne          TimeTwo          TimeThree
  ------ ---------------- ---------------- ----------------
  Sarah  06:45:00         03:30:00         NULL
  John   06:45:00         NULL             NULL
  </code></pre>
  
  <p>How to make SELECT statement so that the "CalculatedTotal" column is total from TimeOne, TimeTwo and TimeThree per row?</p>
  
  <p>What I'd like to have is select query like this:</p>
  
  <pre><code>SELECT
      Name,
      TimeOne,
      TimeTwo,
      TimeThree,
      TimeOne + TimeTwo + TimeThree As CalculatedTotal
  FROM 
      MyTable
  </code></pre>
  
  <p>I'd like to get back resultset like this:</p>
  
  <pre><code>Name   TimeOne          TimeTwo          TimeThree        CalculatedTotal
  ------ ---------------- ---------------- ---------------- ---------------
  Sarah  06:45:00         03:30:00         NULL             10:15:00
  John   06:45:00         NULL             NULL             06:45:00
  </code></pre>
  
  <p>Just using plus operator in select statement gives you an error:</p>
  
  <p><em>Operand data type <strong>time</strong> is invalid for add operator.</em></p>