Round time to nearest quarter hr

[John]

I need help with a function that will round time (hh:mm) to the nearest
quarter hour. Example:

10:08 AM = 10:15 AM
8:37 PM = 8:30 PM

The control is 7 minutes after the quarter round down and 8 minutes after
the quarter round up.

Any and all help is GREATLY appreciated!!!! Thanks in advance.

J

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.Rounding.html#time

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[John]

See http://www.xldynamic.com/source/xld.Rounding.html#time

Bob,
It appears you are an expert in this area of excel formula's. I have read
your website and it is likely that this is exactly what I am in need of.
Thanks for your quick response and website.

J