lundi 10 août 2020

What is a working formula that can calculate to show if an appointment time has surpassed two hours by referencing the current time

I'm currently tying up a work project in Google Sheets, but I'm stuck on an addition that I would like to add. I had an idea to show whether an input appointment time had surpassed a 2 hour window while referencing the current time. I tried the code below but I keep getting N/A returns or #error. Any help would be appreciated.

"=IF(A2+TIME(2,0,0)<(TEXT(NOW()'HH:mm'), 'YES', 'NO')"

Basically if the input time in cell A2 plus two hours is less than the current time, it would state yes or no. I admit my knowledge although growing, is still a bit basic. Thanks for any advice or suggestions.

Aucun commentaire:

Enregistrer un commentaire