I want to calculate the difference in time.
example:
col a= time sent and col b= time replied.
what i want to do is : if b-a is less than 1 hour and col C=1, then OK, OR if b-a is less than 4 hours and C=2 then Ok...
I tried to use this :=IF(OR(AND(B1-A1<TIMEVALUE("1:00"),C1=1),AND(B1-A1<TIMEVALUE("4:00"),C1=2)),"OK","Not OK?")
But it seems that it is not calcultating the time correctly, the formula is fine, i may think that it is a format issue. can you help
thanks
example:
col a= time sent and col b= time replied.
what i want to do is : if b-a is less than 1 hour and col C=1, then OK, OR if b-a is less than 4 hours and C=2 then Ok...
I tried to use this :=IF(OR(AND(B1-A1<TIMEVALUE("1:00"),C1=1),AND(B1-A1<TIMEVALUE("4:00"),C1=2)),"OK","Not OK?")
But it seems that it is not calcultating the time correctly, the formula is fine, i may think that it is a format issue. can you help
thanks