Thread: what is the formula for rounding time up to 1/4 hr?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default what is the formula for rounding time up to 1/4 hr?
The following formula will do what you asked...

=IF(MOD(A4,TIME(0,15,0))=0,A4,MROUND(A4+TIME(0,7,0 ),TIME(0,15,0)))

It requires the Analysis ToolPak Add-in to be selected in the Tools/Add-Ins
option on Excel's menu bar.

Rick


"Rosemary" wrote in message
...
Does anyone know the formula for rounding up time to the next 1/4
increment?

Reply With QuoteReply With Quote