I am trying to determine if a time in the date/time format is after 5:00pm. If it is, the formula should return a "yes" in column C. If not, the formula should return a "no" in column C. I have tried many variations of what I've found in Google land, but nothing seems to be working. The formula appears to be working in the first row, but it is not working in the next one. The Date/Time column is formatted to mm/dd/yy hh:mm as date/time, not as text.
I am using =IF(B3>=TIMEVALUE("17:00"),"Yes", "No")
A2 value is 1/11/24 17:00
B2 value (the TIMEVALUE formula) returns "Yes"
A3 value is 1/11/24 13:09
B3 value (the TIMEVALUE formula) returns "Yes"
I can't figure out what I'm doing wrong.
Thanks in advance!
I am using =IF(B3>=TIMEVALUE("17:00"),"Yes", "No")
A2 value is 1/11/24 17:00
B2 value (the TIMEVALUE formula) returns "Yes"
A3 value is 1/11/24 13:09
B3 value (the TIMEVALUE formula) returns "Yes"
I can't figure out what I'm doing wrong.
Thanks in advance!