title: Count time if values are in 00:00 format (nvarchar SQL)
body: <p>I've got this table:</p>
  <p>table name: T</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>total_time</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>8:45</td>
  </tr>
  <tr>
  <td>2:45</td>
  </tr>
  <tr>
  <td>1:45</td>
  </tr>
  <tr>
  <td>5:43</td>
  </tr>
  <tr>
  <td>17:45</td>
  </tr>
  <tr>
  <td>10:54</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>etc.. etc...</p>
  <p>How can I count the total number of rows of over 8 hours (more than 8:00)?
  All values are nvarchar. How can I count the time in them?</p>
  <p>when I use count(*) where total_time &gt; '8:00' it counts the rows with more then 8:00 but less then 10:00.</p>