title: Access VBA round by the quarter of the hour
body: <p>I want to be able to round time by the quarter of the hour, so when it is 3 minutes past the quarter of the hour it rounds up and when it's within the 3 minutes it rounds down.  Like below:</p>
  
  <pre><code>08:01 (will be 08:00)
  08:03 (will be 08:00)
  08:04 (will be 08:15)
  </code></pre>
  
  <p>Managed to get it working in excel but cannot get it working in Access.</p>
  
  <p>Here is the excel formula:</p>
  
  <pre><code>=(TRUNC((VALUE("08:03")+VALUE("00:11"))*96)*VALUE("00:15"))
  </code></pre>