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

--

HTH

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


"John" wrote in message
.16...
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