Round time in a query

William · Mar 9, 2005

How do you round time to the nearest quarter of an hour?

15,:30,:45)

JohnFol · Mar 9, 2005

? format (now(),"hh:" & cstr(round(minute(now())/15,0) * 15) & ":00")