title: Convert number of minutes to hh:mm
body: <p>I have a column in a table that stores the number of minutes as a <code>numeric(18,4)</code> field named <code>[course_access_minutes]</code>.</p>
  
  <p>The stored values come from a blackboard database and look like this:</p>
  
  <pre><code>0.0500
  0.0667
  0.3667
  up to 
  314.0833
  625.8167
  </code></pre>
  
  <p>How do I convert these to time hh:mm, I've had a good look at the database documentation and all I can find is</p>
  
  <p>course_access_minutes   numeric(18,4)   This is the number of minutes that the user accesses this course in total during this login session.</p>
  
  <p>Can I assume that I can make a direct conversion from minutes into hours? I think I will take any values below 1 as 0 minutes. What is the best way to do this in SQL? Thanks in advance for your help.</p>