LinkBack URL
About LinkBacks
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
IF Timestamps is Greater than and Less than two timevalues
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
It can't be both greater than 18:00 AND less than 7:30 at the same time - do you mean OR ?
Hope this helps.
Pete
If it is greater than 18:00 through 7:30. So I will be marking Yes if 18:00,01,02...to.....7:20,21,22,23,24..30.
I guess it can be IF(OR(TIMEVALUE>("18:00"),TIMEVALUE<("7:30")),"Yes","No")???
I need to mark all other time stamps with No in other words.
Thank you,
N
I assume your time range is 6:00 PM to 7:30 AM.Originally Posted by newbie4
In which case you'll have to use an OR comparison since the time "resets" to 0 at midnight.
Data Range
This formula entered in B2 and copied down:
=IF(OR(A2>D$1,A2<E$1),"Yes","No")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I didn't notice, but my timestamp has dates as well. Where would I put in the MON(""). I hate when excel leaves in the month even if you format to 13:30.
Thank you, Appreciate your help and support.
-N
In that case try this version:
=IF(OR(A2-INT(A2)>D$1,A2-INT(A2)<E$1),"Yes","No")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks