Thread: Rounding up a cell to the next ¼ hour.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Rounding up a cell to the next ¼ hour.
=ROUNDUP(A1*96,0)/96


"Pasquale" wrote:

I have a column that is tracking time spent on projects and an auto summation
at the bottom. However I would like to know how to formulate a cell that
take the total time and rounds it up to the next ¼ hour?
Reply With QuoteReply With Quote