Round Up and Round Down Time

[DaveMoore]

Good Morning & a Happy New Year to all subscribers in this group.

I want to round up Start times and round down Finish times to the next
or previous 15 minutes in my spreadsheet.
I have found MROUND but this does not work for me in all cases.
There does not seem to be MROUNDUP or MROUNDDOWN available.

I can get the results I want using a VLOOKUP table but is there
another way?

Regards to all,
Dave Moore

 

[David Biddulph]

=FLOOR(A1,TIME(,15,))
=CEILING(A1,TIME(,15,))

 

[DaveMoore]

Beautiful!!
Thank You David

=FLOOR(A1,TIME(,15,))
=CEILING(A1,TIME(,15,))
--
David Biddulph







- Show quoted text -