IF statement for count of entries outside of specified time

[jdstuffel]

Trying to write an if statement giving a simple value of 1 if a time is outside of weekday hours 8am to 9pm. Cell formatted as (6/3/17 2:15 PM). Function should report "0" value as this is a Tuesday between 8am and 9pm.

A cell formatted as (6/3/14 7:54 AM) should result in "0" value.

Thanks!

[Ace_XL]

Try..

=--(OR(HOUR(MOD(A1,1))>21,HOUR(MOD(A1,1))<8))

A cell formatted as (6/3/14 7:54 AM) should result in "0" value.

isn't that outside of working hours?

[jdstuffel]

Correct. I meant the 7AM entry should be a value of "1".

[jdstuffel]

I believe that worked. Thank you sir!

[jdstuffel]

Sort of worked except it is excluding 8am-9PM on weekends. Weekends should always return a value of "1"

[Ace_XL]

Don't need the MOD function too..

Try
=--(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7,HOUR(A1)>21,HOUR(A1)<8))

[jdstuffel]

no luck. Still reporting "0" value for every other weekend date.