Filter or Format to identify non-busness hours

[fgruhlke]

I have a large data set of Service tickets that can be created any time of the day. What I need to do is Separate the tickets that come in during non-business hours, ie: After 5:00pm and before 8:00am.

I attached a small sample with date time format I need to work with. I have figured out how to pull out the week-end calls with a basic =Weekday()>5 formula but dealing with the time part has me stumped so far!

Any suggestions would be most appreciated!

[Kaper]

Use something similar (try in C2 and copy down)

Please Login or Register  to view this content.

of course you could use this part:

Please Login or Register  to view this content.

to create conditional formatting rule based on formula

[fgruhlke]

Hummmm both are giving me errors so far...

[Kaper]

There is still one semicolon inside - change to comma - My excel uses semicolons as separators and I missed this one

Please Login or Register  to view this content.

Sorry!

[Kaper]

And the attachment just in case

[fgruhlke]

That did it! Thank you so much for your help!