I cannot get this to work =if(E3=E2),IF(AND(D3="Closed",D2="Opened",C3>C2),C3-C2,"")
Cells E3 and E2 are txt strings, so
if they are the same,
then
if Cell D3 contains string "Closed"
and Cell D2 contains string "Open"
and Time value in cell C3 is greater than Time value in C2
Then elapsed time will be C3-C2
Otherwise leave blank.
Missing something but just stuck.
Anyone advise?
Bookmarks