Quote Originally Posted by MoFaSa View Post
Attachment 295773

I found a formula for colomn P and Q
It's works fine.

issue No. 2 (highlighted in red)
Column P and Q is 00:00. Is it possible that this is an empty box?
If you can see in week 1 and 2 (Red marked)

Colomn P:
I found the problem about 00:00 mark.
problem is this character =

before in colomn P:
ALS(OF(O3>N3;N3="");"";ALS(N3-O3>TIJD(2;0;0);TIJD(2;0;0);N3-O3))

after in colomn P::
ALS(OF(O3>=
ALS(OF(O3>=N3;N3="");"";ALS(N3-O3>TIJD(2;0;0);TIJD(2;0;0);N3-O3))

Problem for colomn P is solved.

the same formula i tried in colomn Q:

ALS(OF(P3="";P3<TIJD(2;0;0));"";N3-O3-TIJD(2;0;0))
ALS(OF(P3>="";P3<TIJD(2;0;0));"";N3-O3-TIJD(2;0;0))
problem is this character >

If i change it, I get diffrent figures??
If i restore the box, there is no recalutation of it.[ctrl+Z]


Map3-dibbins.xlsm


regards,
Mofasa