Rounding Time?

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/