title: How to adjust times by adding hours to every cell in a column VBS macro
body: <p>OK what i have is this: Our data system logs everything in UTC time, the reports that i need to write need to be in local time which is UTC+8 hours</p>
  
  <p>I can increase the time in a cell with this formula in VB</p>
  
  <pre><code>Sub UTC+8()
      With Range("A1")
          .Value = .Value + TimeSerial(8, 00, 0)
      End With
  End Sub
  </code></pre>
  
  <p>How do i apply this to a whole column of times? Ive tried ("A:A")
  but i couldn't get it to function correctly.</p>
  
  <p>The time values are stored as simple 00:00:00 with no dates involved.</p>
  
  <p>Any help would be greatly appreciated.</p>
  
  <p>J</p>