I am looking for a formula in a scheduling template I have created. Currently I have a formula that fills time cells between two times a color, but I need a formula that changes the lunch and breaks to a differently value. My currently formula is =IF(AND(N1>=B3,N1=<C3,"yes","") I want to add if a formula to this that says "no" during the break and lunch times.
Hi, Welcome to the forum,
You mean this
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Hmm…nothing shows up
can you post your req in excel with expected outputs
Here's the problem in a workbook...example 1.xlsx
in J2 and drag it across
Formula:Please Login or Register to view this content.
Hi, Ref the attachment
The only problem is now when I change the End Lunch cell it doesn't show in the time line correctly.
efb.xlsx
fg3- showing - 12:15 PM
u1- showing -12:30 PM - which means the lunch will be from 12 to 12.15 pm (15 min) so the result will be "yes"
so the result will be yes, if you change the cell U1 to 12:15 pm the result will show- no
I see where I went wrong, but why doesn't it work this way? One of the "No" is missing?efb-2.xlsx
Ok try the below in J2 (will put everything into round to avoid decimal prob's in time value)
Formula:Please Login or Register to view this content.
I did that and checked sometimes it still applies yes, even when it should be a no.
HI, Refer the attachment, check which cell giving the wrong results
Thank you for your help this worked out amazing for me!
If the suggestion helps you, then Click * to Add Reputation and you can mark the thread as Solved
When I put this formula in actual spreadsheet for some reason it doesn't work again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks