=IF(F5<(F5+TIME(F5+2, 0, 0)),"GOOD","CANCEL")
I'm attempting to input a time in F5(would be the current time Shift+CTRL+. I want for cell G5 to let me know when the original time is 2 hours past cell F5.
What am I doing wrong? I've attached the Excel sheet that I'm working on. Ideally what I'm looking to do is once it gives me a positive("GOOD") I want to set up an auto email sent to my outlook. Anyone that can help please and thank you.
Bookmarks