Round to the nearest minute if more than 6 seconds

[bbarkman]

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.

 

[John C]

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

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

 

[Infinitogool]

Hi bbarkman
Try
=TIME(HOUR(A1),MINUTE(A1)+(SECOND(A1)>6),0)
o
=TIME(HOUR(A1),MINUTE(A1)+(SECOND(A1)>=6),0)

Regards,
Pedro J.