Weeble
Board Regular
- Joined
- Nov 30, 2016
- Messages
- 95
- Office Version
- 365
Could anyone please tell me what I am doing wrong?
I've tried doing it this way aswell.
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
Code:
=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.
Code:
=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