Round to the nearest minute if more than 6 seconds

B

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.
 
J

John C

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

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding Time to Nearest 5 Minutes 1
Round Up Time IF 4
How do I round to the nearest 5? 2
How can you round a number to the nearest 900? 3
Round to nearest 5000? 2
Round time to nearest 15 minutes in decimal format 4
in access, round up to nearest fraction(.5) 1
Rounding numbers up or down in same formula 6

Top