title: Convert HHH:MM:SS to seconds
body: <p>From the source database, I am getting HH:MM:SS as 832:24:12</p>
  
  <p>Currently I am using below statement which is working fine for most of the cases hh:mm:ss but it fails when hours are more than 99</p>
  
  <pre><code>ISNULL(LEFT(COLUMN,2) * 3600  + RIGHT(LEFT(COLUMN,5),2) * 60 + RIGHT(COLUMN, 2) ,0)
  </code></pre>