View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bbarkman bbarkman is offline
external usenet poster
 
Posts: 10
Default Round to the nearest minute if more than 6 seconds

Using the following formula to round to the nearest minute:

=ROUND(A1/(1/1440),0)*1/1440

This one rounds up at the 30-second mark.

Need to make it so that after 6 seconds the time is rounded up to the next
minute.

Thanks in advance.