IF statement to use between 2 times

[JakeMann]

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?

[Kaper]

you can use TIME function
for instance

Please Login or Register  to view this content.

[JakeMann]

Thanks Kaper, just what I need.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.