title: Removing seconds from the time field in MS Access without updating the table
body: <p>Good day</p>
  
  <p>I have a table that has users and time-stamps. I need to calculate how many users used a system at any given time. This will help to see peak hours. The problem is that seconds are separating my count(s). For instance, I'll have 4 of the same time-stamps[11:45,11:45, 11:45] because for the different seconds. Is there a way to remove them without updating the table. All the formatting functions don't work! Thanks in advance</p>
  
  <p>The code is as follows;</p>
  
  <pre><code>SELECT distinct mid(Format (u.time), 1,5) as Time,
  (select count(u1.student_id) from uselog u1 where u1.time = u.time) as users FROM uselog u
  </code></pre>