title: How to get a time between two columns of type time?
body: <p>I have a table in SQL Server</p>
  
  <pre><code>id int, 
  enters time, 
  left time, 
  date datetime,
  user varchar(50)
  </code></pre>
  
  <p>Now I want to get the time difference between <code>enters</code> and <code>lefts</code> but I get this error message:</p>
  
  <blockquote>
    <p>Msg 8117, Level 16, State 1, Line 1<br>
    Operand data type time is invalid for subtract operator.</p>
  </blockquote>
  
  <p>How can I to get the time has passed?<br>
  For example, if user enters at 8.00 and leaves at 9.15 I need to get 1.15.<br>
  How can I do this?</p>