title: VBA Excel create hour column (like in a calendar) according to given time resolution
body: <p>I need to create some sort of a calendar in VBA.
  I need to create a column of hours. The time difference between 2 adjacent cells is determined by an integer read from a text file, which represents the time resolution in minutes.</p>
  
  <p>For example - if Res = 60, the hour column should look like this:</p>
  
  <pre><code>12:00
  13:00
  14:00
   ...
  </code></pre>
  
  <p>if Res = 30, the hour column should look like this:</p>
  
  <pre><code>12:00
  12:30
  13:00
  13:30
  14:00
   ....
  </code></pre>
  
  <p>I've calculated the number of cells according to the given resultion (if Res = 60, nCells = 24, if Res = 30 nCells = 48 and so on). I just don't know how to create the hour column (in VBA code of course).</p>
  
  <p>Thanks,
  Li</p>