Have cell return a 1 or 0 based on time of day

I need to show a 1 or a 0 in cell D1 based on the time of day the report is ran. If the report is opened between 5 am and 7am I need cell D1 to have a value of 1, if not have a value of 0
Who is Participating?
spattewarConnect With a Mentor Commented:
one way to do it. put this formula in D1


hope this helps.
wilpitzAuthor Commented:
Looks great! Thanks for the fast help!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.