Hi All,

I need help with a formula.

In cell N1 I have a time.

In cell R1 I want a formula that says if R1 is between 6am and 10pm, then return a 7.

I'm not sure how to use time in a formula.

Any ideas?