Selecting business hours via date / if function?

[Rhiannon]

Hello

Is there a formula that can be used to return a "true" or "out of hours"
value if the date/ time of a particulr cell is outside of (my) business hours
please? (say 7am to 5:30pm). Does the date/ time need to be entered in a
certain way ? (currently date is in one column and time is in another - in
h:mm:ss AM/PM format.

Thanks

 

[Rick Rothstein \(MVP - VB\)]

Give this formula a try...

=IF(AND(B1>=TIME(7,0,0),B1<=TIME(17,30,0)),"In time","Out of time")

Rick

 

[Rhiannon]

Thanks; that worked perfectly! (very speedy answer too - thanks)