I have a list of timestamps and want to mark yes if the timestamp is >18:00 and <7:30.

I can't figure it out and keep getting value string as the result.

=IF(AND(TIMEVALUE>("18:00"),TIMEVALUE<("7:30"))),"yes","no")

Thank you, Appreciate your help.

N