Rounding times to the nearest 15 minutes in Excel
Try one of these:
For a time in A1
This one rounds to the NEAREST multiple of 15 minutes
B1: =MROUND(A1,1/24/4)
If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.
or
This one does the same thing as the MROUND function, but doesn't need the
ATP installed:
B1: =ROUND(A1*(24*4),0)/(24*4)
or
This one rounds UP to the NEXT multiple of 15 minutes
B1: =CEILING(A1,1/24/4)
Note:
24*4 equals the number of 15 min intervals in a day
1/24/4 equals on fourth of one 24th of a day
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"BuckeyeWMV" wrote:
How do I round times to the nearest 15 minutes. I have a time in cell A1
(7:53) and would like the rounded time to be in B2 (rounded to 8:00).
|