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
Bookmarks