Formula to Identify Out Of Hours

[djfatboyfats]

Good afternoon,

I need to design a formula that will tell me if some inbound calls that come into my call centre are within working hours

I have created a formula

Please Login or Register  to view this content.

that will tell me between to static times weather its inside or outside of normal office hours giving it a value of 0 or 1.

In column AA i have the day of the week and want to add this into the formula, so i now want to say if basically if its Saturday

Please Login or Register  to view this content.

but if any other day than

Please Login or Register  to view this content.

Thanks in advance

DJ

[daddylonglegs]

Try this version

=IF(AND(Y2>=8,Y2<=IF(AA2="Saturday",13,20)),0,1)

[djfatboyfats]

Thank you very much. A quick question is it easy to add if Sunday than 1 as Sunday will always be out of hours?

[daddylonglegs]

You could check that first, i.e.

=IF(AA2="Sunday",1,IF(AND(Y2>=8,Y2<=IF(AA2="Saturday",13,20)),0,1))

[djfatboyfats]

Thank you, much appreciated.