Hi Frank

I think my suggestion does what the poster required, see here...

John Wrote:

One small thing I've noticed is that when my time is exactly on the
Qtr
hour, say 13:15 this also rounds to the next 15 i.e. 13:30. Is there a
way
to leave these as 13:15?

Just a note if it is 15:31, then this should ound to 15:45 - as it does
with
your existing formula



--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=555039