round time to nearest 15mins e.g. 16:12 to 16:15

**jlgopurdue** · 01-25-2010, 01:09 AM

If I use the formula : =(ROUND((I6*24)/0.25,0)*0.25)/24 , it will round to the nearest 1/4 hour. What should I use to always round UP to the next 1/4 hour for example, 4:16 becomes 4:30?

**ConneXionLost** · 01-25-2010, 01:40 AM

Hi jlgopurdue,

Try:

=(ROUNDUP((I6*24)/0.25,0)*0.25)/24

Cheers,

**contaminated** · 01-25-2010, 01:45 AM

Also

=ROUND(A1*24/0.25,0)*0.25/24

Or

=MROUND(A1,"00:15")

**jlgopurdue** · 01-25-2010, 02:13 AM

Yes.. I'm an idiot...Thanks!

**ConneXionLost** · 01-25-2010, 02:34 AM

It's okay, everyone misses now & then.

Please mark your thread [SOLVED]

To mark your thread solved do the following: - Go to the first post - Click edit - Click Advance - Just below the word "Title:" you will see a dropdown with the word No prefix. - Change to Solve - Click Save

**atzerv** · 02-13-2014, 09:13 PM

According this issue I have a similar one.
I am trying to make a formula rounding the time to the closest 1/4 of the time.
So, I have already done this, so far. My problem is how to put a brake on this formula.
Could you please help me?
Formula:
=IF((ROUND((((C12-B12)+IF(C12<B12,1))*24)/0.25,0)*0.25)-0.5=5,ROUND((((C12-B12)+IF(C12<B12,1))*24)/0.25,0)*0.25,IF((ROUND((((C12-B12)+IF(C12<B12,1))*24)/0.25,0)*0.25)-0.5>=8,8,ROUND((((C12-B12)+IF(C12<B12,1))*24)/0.25,0)*0.25))

I want to count and the "IN(2)" and the "OUT(2)". Also, in the formula I have a "-0.5" because I subtract the 1/2 hour of the brake.

I am sending and my time sheet to take a look.

Thank you very much in advanced! Please, reply to me as soon as you can!

Capture_1.PNG

**FDibbins** · 02-13-2014, 09:21 PM

Hi and welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

**atzerv** · 02-13-2014, 09:27 PM

Hello and thank you for the welcome!!!
I like very much your forum!

Thank you!
I read your comment and I opened already my own thread!
I hope to receive an answer soon!