I have a list of times, 10:00 AM to 5:00 PM and these numbers will change. The issue I have is setting it up, so that I can say if(Cell B"X"=(TIME),"Yes","no"). I do not know what to insert in the parenthesis time spot.
Thanks for any help. Attached is the file. Cell F1 is an exampleI want to find the function that lets me say if(B1=10:00 AM, "yes","no")
Last edited by JoshF; 11-28-2011 at 10:10 AM. Reason: Answered
Hi,
Regards=IF(B1=TIME(10,0,0),"yes","no")
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
I'd suggest you put a time selection in another cell (I used D1) and then reference it in the formula as follows:
=IF(B1=D1,"yes","no")
I'm not totally sure what else you want to do with this...
---Edit---
oh, didn't see the first reply from RBthat is pretty slick.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Thanks a lotOriginally Posted by Richard Buttrey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks