I have a table of times, server names, and error counts. The time
stamps are by the second. How do I round times to the nearest 15
minutes? (Really, I need to the next 15, so I suspect this is a ceiling
function.)
Thanks in advance,
ChrisW
I have a table of times, server names, and error counts. The time
stamps are by the second. How do I round times to the nearest 15
minutes? (Really, I need to the next 15, so I suspect this is a ceiling
function.)
Thanks in advance,
ChrisW
Excel stores date-time values as a whole number for the date and a
fraction for the time. 15 minutes is 15/60 * 1/24 = 0.01041666666667.
But you can put your value into cell A1, and 0:15 into cell B1, and use
this formula to get a rounded up value. Format as time to read it.
=CEILING(A1,B1)
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
ChrisW wrote:
> I have a table of times, server names, and error counts. The time
> stamps are by the second. How do I round times to the nearest 15
> minutes? (Really, I need to the next 15, so I suspect this is a ceiling
> function.)
>
> Thanks in advance,
>
> ChrisW
>
Oh! Yes, that works. Thank you very much.
ChrisW
Jon Peltier wrote:
> Excel stores date-time values as a whole number for the date and a
> fraction for the time. 15 minutes is 15/60 * 1/24 = 0.01041666666667.
>
> But you can put your value into cell A1, and 0:15 into cell B1, and use
> this formula to get a rounded up value. Format as time to read it.
>
> =CEILING(A1,B1)
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks