Round to the nearest minute if more than 6 seconds
 

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.

Round to the nearest minute if more than 6 seconds
 

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.

Round to the nearest minute if more than 6 seconds
 

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.

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.