Thanks for posting this. It realy seems a lot better then I had. however. somehow the copy paste in MY question got corrupted on the "" and "" signs.
I believe your answer did too.
Here's the formula I tried pasting;
=+IF(+IF(A3D2;0;MAXA(D1;A3))=0;+D2-MAXA(+IF(A3D2;0;MAXA(D1;A3));IF(B3<D1;0;MINA(B3;D 2)));D2-IF(A3D2;0;MAXA(D1;A3)))-(D2-MAXA(+IF(A3D2;0;MAXA(D1;A3));IF(B3<D1;0;MINA(B3;D 2))))+IF(A3=A3;+D$2-A3;+"0:00")
Could you post the "<" and/or "" somewhere in the formula too?
A minor change in settings is the 0.5 in the formula for me is 0,5 but I got that sorted. not the final formula result though.
thx
BTW, the preview again got rid of these <'s.(greater/smaller then signs)
I'll try again with immediat submittal.
|