round time to nearest 15mins e.g. 16:12 to 16: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