title: How to convert number of minutes to hh:mm format in TSQL?
body: <p>I have a select query that has <strong><code>DURATION</code></strong> column to calculate number of Minutes . I want to convert those minutes to <code>hh:mm</code> format.</p>
  
  <p>Duration has values like <code>60, 120,150</code></p>
  
  <p><strong>For example:</strong></p>
  
  <p><strong>60</strong> becomes     <strong>01:00</strong> hours</p>
  
  <p><strong>120</strong> becomes    <strong>02:00</strong> hours</p>
  
  <p><strong>150</strong> becomes  <strong>02:30</strong> hours </p>
  
  <p>Also, this is how I retrieve <strong>DURATION</strong> (<code>Minutes</code>)</p>
  
  <pre><code>DATEDIFF(minute, FirstDate,LastDate) as 'Duration (Minutes)'
  </code></pre>