Thread: Round time up to nearest :15
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Round time up to nearest :15
Try

=CEILING(D2,1/ (24*4))

Mike

"Amy" wrote:

I am currently using this formula to round to the nearest :15 --
MROUND(D2,0.25/24)
However I Need it to round UP to the nearest :15.

Any suggestions?
Reply With QuoteReply With Quote