Is it Possible?
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
|