title: Convert Int into time
body: <p>I'm trying to convert a field into the correct format that I would like. 
  The field is suppose to keep track of time, but it does it in military time and it is set as an Int.</p>
  
  <p>Can anyone help me in finding a solution for this</p>
  
  <p>I need to do this so I can eventually track the length it took a record to go from one status to another.</p>
  
  <pre><code>LTRIM(RIGHT(CONVERT(varchar, [POSTTIME], 100),7)) 
  </code></pre>
  
  <p>I tried this, but no luck.</p>
  
  <p>here is an example of what the values are and what I would like to change them into:</p>
  
  <pre><code>945 = 9:45
  
  1516= 3:16
  </code></pre>