If statement for between to time stamps (Working hours)

[Danniii_]

Hi, 

I have had a look at a few other posts but none of them seem to bring back what I need. 

I am looking for somthing like an IF statement to tell me the following 

TIME = 15:36

Working hours = 07:00 till 17:00

IF 'TIME' is between 07:00 and 17:00, "In Day", "Out Of Hours"

Thanks 

[az38 · Accepted solution]

Hi @Danniii_ 

try

Column = IF(
[TIME] >= TIME(7, 0, 0) && [TIME] <= TIME(17, 0, 0),
"In Day", "Out Of Hours"
)

[Danniii_]

Perfect thank you, I kept trying "AND" and it wasn't working didn't think to use "&&"

[az38]

@Danniii_ 

so, does it work ok?

[Danniii_]

Yes it working perfectly thanks.