View Single Post
  #1   Report Post  
carl
 
Posts: n/a
Default Round Up Time IF

Hi. I have another roundup question dealing with time.

Can a roundup formula do the following:

If my time is past the 30 second threshhold, round up to the next whole
minute plas 1 minute. If the time os not past the 30 second threshold, round
up to the nearest minute. For example:

1:23:33 PM rounds up to 1:25:00 PM
1.23:15 PM rounds up to 1:24:00 PM

Thank you in advance again.