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/