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