Formula issue

Hi All,

In column A I have a list of times in this format 14:34:26.

What i want to do is have a formula in column b that rounds this time down to the nearest 15 mins, unless its within 60 seconds of the next 15 min.

EG.
7:13:59- round that down to 7:00:00.
7:14:02- Round that up to 7:15:00

The formula i am using to round down at the moment is =floor(a1,"00:15:00") but cant figure out how to do the rest.

Anyone got any ides??

Thanks

Try

=FLOOR(A1+"0:01","0:15")

Thanks for the quick reply!

That seems to do the trick so thanks a lot :-)