Hello,
I am trying to find a formula that will do the following tell me whether or not an event happened during Business Hours or Non-Business Hours.
If it happened during business hours, then it would have to occur during the time range: 8:30:00am to 17:00:00pm. Anything outside of that time range would be considered Non-Business Hours.
I attached an example to better display what I am looking for.
I believe that an IF/ELSE formula should work for this, but I am unsure how to get Excel to work between the certain range that I mentioned above.
Any help with this is appreciated!
Bookmarks