Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Excell 2013 Compare two time values +/- 1 minute 1

Status
Not open for further replies.

puforee

Technical User
Oct 6, 2006
741
US
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top