AND IF OR formula not quite working

[Weeble]

Could anyone please tell me what I am doing wrong?

=IF(AND(C2=C1,D2="LIS",D1="LIS")*OR(C2=C1,D2="LIP",D1="LIP")*NOT(F1="PL")*NOT(F2="PL"),TEXT(B2,"00\:00\:00")-TEXT(B1,"00\:00\:00"))*1440

I've tried doing it this way aswell.

=IF(AND(C2=C1,D2="LIS",D1="LIS",OR(C2=C1,D2="LIP",D1="LIP"))*NOT(F1="PL")*NOT(F2="PL"),TEXT(B2,"00\:00\:00")-TEXT(B1,"00\:00\:00"))*1440

My results for "LIS" works and does the job.
But the rows that contains "LIP" gives me 0 results.

Probably super easy, I am just not able to see it

 

[steve the fish]

I think your test needs to be this:

AND(F1<>"PL",F2<>"PL",C1=C2,OR(AND(D1="LIS",D2="LIS"),AND(D1="LIP",D2="LIP")))

 

[Weeble]

I think your test needs to be this:

AND(F1<>"PL",F2<>"PL",C1=C2,OR(AND(D1="LIS",D2="LIS"),AND(D1="LIP",D2="LIP")))

That solved it.
Thank you Steve!