How do I round time to the nearest quarter of an hour
Thank you
"SteveW" wrote:
On Thu, 06 Jul 2006 16:39:53 +0100, Bearacade
wrote:
I am assuming from you example that you are rounding up the time.
Here are the two solutions:
=CEILING(A1, TIME(0,15,0))*24
=TIME(HOUR(A1),CEILING(MINUTE(A1),15),0)*24
Not used Ceiling() before, why won't it accept negative numbers.
It is meant to round up to - no mention of only working with =0 numbers
--
Steve (3)
|