can someone work on this if(mod) code

[zilch4ry]

hi,

earlier i asked a question and had really helpful answers however not all worked. Peter_SS posted this answer for me

=IF(MOD(J3,1)<14/24,"Shift 1","Shift2")

J3 is the cell which had =NOW()
This worked well but can someone add onto this code stating that the times between 22:00 and 06:00 says "closed"

If anybody can do this it will be hugely appreciated

Thanks in advance,


tom

 

[jasonb75]

Maybe

=LOOKUP(HOUR(J3+"2:"),{0,8,16},{"Closed","Shift1","Shift2"})