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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.