|
Posted to microsoft.public.excel.newusers
|
|
|
How do I round time to the nearest quarter of an hour
Thanks alot these should help
"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
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=558939
|