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