Thread: How do I round time to the nearest quarter of an hour
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bearacade Bearacade is offline
external usenet poster
  
Posts: 1
Default How do I round time to the nearest quarter of an hour

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

Reply With QuoteReply With Quote