title: Convert UTC time to local
body: <p>I have an MS Access app which is used in two different time zones. The difference is 7 hours. I needed to find a time when the both of the offices are off so I can close their database and I can do compact and repair and do backup of them.</p>
  
  <p>So I will not need to create two separates front end and I tell close database one at 1000 PM and  another in 4 AM I figure out I can say Close database at 00:30 AM UTC.
  But I do not know how to convert the same one in Local.
  Right now my code for closing the database looks like this:</p>
  
  <pre><code>Private Sub Form_Timer()
  Dim RunAtLocalTime As String
  
  RunAtLocalTime = Format(Now(), "HH:MM:SS")
  If RunAtLocalTime = ("00:00:00") Then
          DoCmd.Quit
  End If
  End Sub
  </code></pre>
  
  <p>And I want to do something like this:</p>
  
  <pre><code>Private Sub Form_Timer()
  Dim RunAtLocalTime As String
  Dim UTCTIME As 
  
  '''RunAtLocalTime = Convert(UTCTIME)
   RunAtLocalTime = Format(Now(), "HH:MM:SS")
   If RunAtLocalTime = ("00:00:00") Then
          DoCmd.Quit
  End If
  End Sub
  </code></pre>