title: Convert HH:MM:SS string to number of minutes
body: <p>I have the below query.</p>
  
  <pre><code>select cast(dateadd(minute, datediff(minute, TimeIn, TimeOut), 0) as time(0) )
  </code></pre>
  
  <p>I get the results from two columns in the format of hrs-min-seconds.
  I would like it in the format of min only. So <code>02:47:00</code> will read <code>167</code>.</p>