One way:

=CEILING(NOW()+"0:0:29","0:1")

In article ,
"carl" wrote:

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