The easiest way would be to just add 24 minutes like so:

=ROUND(A1/(1/1440)+24/60,0)*1/1440
--
John C


"bbarkman" wrote:

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.