Round time in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you round time to the nearest quarter of an hour? (:15,:30,:45)
 
? format (now(),"hh:" & cstr(round(minute(now())/15,0) * 15) & ":00")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round hours to nears quarter or 1/2 hr 8
Excel Time Rounding in Excel 2
Calculate time difference 3
rounding to closest 15 minute increment 1
in access, round up to nearest fraction(.5) 1
Rounding to nearest quarter 2
How do you round time? 4
advice on rounding or ceilng a 24 hour time value 3

Back
Top