I have two cells on my spreadsheet that have time values HH:MM. Formatted [h]:MM. I have a third cell that uses a formula to show OK if they compare and NO if they don't. However one of the cells could be 1 minute +/- from the other. If this occurs I still want to show OK. So,I need a formula that checks that the two cell times are the same +/- 1 minute. I have searched and found +/- for numbers but not time.
Here is the third cell formula =IF(L2=L3,"OK","NO")
How do I get the +/- 1 minute into this formula
Can anyone help?
Here is the third cell formula =IF(L2=L3,"OK","NO")
How do I get the +/- 1 minute into this formula
Can anyone help?