Rounding Time?

1. 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.)

ChrisW

2. Re: Rounding Time?

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.)
>
>
> ChrisW
>

3. Re: Rounding Time?

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)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1