JE McGimpsey wrote...
One way:

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

Quibble: this might depend on locale-specific time format. Also assumes
NOW() always returns values rounded to whole seconds. It doesn't.