Need Help with IF formula in Function in Excel Please
Hello and Happy Thursday!!!!
Hoping someone can help me.
Column A displays Date
Column B displays Time
Would I would like in column C is this
If date is a Weekend then show "Weekend"
If time is between 10AM to 7PM then show "Normal Business Hours"
If time is between 7:01 PM to 9:59 then show "After Hours"
Column D is just an example of how the output should look.
Please let me know if you need anything additional
Thanks in advance
Try
Formula:
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
You are truly a wizard!!!! Worked perfectly John thank you!!!!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks