title: Day current time for function using excel vba
body: <p>searched on Google I found one. Is it possible to format time in [h]:mm format using VBA?</p>
  
  <pre><code>Dim currentTime As Date
  currentTime = TimeOfDay
  </code></pre>
  
  <p>I passed <code>currentTime</code> into database when I dumped data - showing put put as <code>00.00.00.000000</code>
  not understood why its showing different? Is there any other function to call current time <code>00.00 AM/PM</code></p>