View Single Post
  #5   Report Post  
leo leo is offline
Junior Member
 
Posts: 6
Default

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.