IF/ELSE Formula

[KoolKatelyn]

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!

[Miskondukt]

A really easy way to do this would be to separate your time dates via "Text to Columns" then you have your defined range to easily pluck from.

[JohnTopley]

Assuming time is separated into column B

=IF(AND(B2>=TIME(8,30,0),B2<=TIME(17,0,0)),"Business hours","Non_business hours")

[Raphaelp]

You can just put this in C1:

Please Login or Register  to view this content.

[KoolKatelyn]

All of them work perfectly! Thank you so much for your help!