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)
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks