Tip Printed from ExcelTip.com

---

Rounding Times Down to a Specified Time Increment


Problem:

Rounding the times in column A down to the nearest 15 minute increment.

Solution:

Use the TIME, FLOOR, HOUR, and MINUTE functions as shown in the following formula:
=TIME(HOUR(A2),FLOOR(MINUTE(A2),15),0)