Thanks everyone I suppose the trick is to know that all these functions
exist!




"Franz Verga" wrote in message
...
daddylonglegs wrote:
Hi Frank

My name is Franz... :-)

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


Sorry, you're right, but when I read the post this morning, I think I was
still sleeping, so I read it in the way the OP wanted to round 13:15 to
13:30... :-)


--
Ciao

Franz Verga from Italy