Hi, Could anyone help me with rounding time? I have a table containing in and out time of employees. I'd like to make a query which will round it to set interval of time and using median which again could be set. E.g. setting interval for 15mins and median for 4 mins, we should get: 7:03 7:00 7:04 7:15 7:18 7:15 7:19 7:30 Please help me with this issue!!!! Thanks in advance.