title: Format from normal numbers to time in [hh]:mm format
body: <p>I usually have this nice way in <strong>Excel</strong> to convert normal number format to hour and minutes format using simple cell custom formatting <strong>[HH]:mm</strong> which turns out like this:</p>
  
  <p><img src="https://i.stack.imgur.com/B5V7v.png" alt="excel sheet"></p>
  
  <p>Now I can't seem to find a similar to do this in visual basic 2010 or in sql 2000 so does any one know of a way to do it.
  Thanks in advance.</p>
  
  <p><strong>Note:</strong> the brackets in <strong>[</strong> HH <strong>]</strong>:mm are to keep the hours figure from rounding to 0 after every 24 hour lap.</p>