I am trying to make this formula work:
=IF(AND($A$1<=0.451388888888889,$A$1>=0.397916666666667),1,2)
$A$1 is the current time. The formula =now() . It is 1/25/2018 20:03 a the time of this post.
0.451388888888889 is one time. It is 1/0/00 10:50
0.397916666666667 is the other time. It is 1/0/00 9:33
Since the dates of the current time and the historic times do not match, the formula does not work properly. I am fine using dates, but do not need to. I really just need the times to align with the current time, so the formula will work.
I am open to changing the decimal times to something else, or arranging a new formula. Thank you.
=IF(AND($A$1<=0.451388888888889,$A$1>=0.397916666666667),1,2)
$A$1 is the current time. The formula =now() . It is 1/25/2018 20:03 a the time of this post.
0.451388888888889 is one time. It is 1/0/00 10:50
0.397916666666667 is the other time. It is 1/0/00 9:33
Since the dates of the current time and the historic times do not match, the formula does not work properly. I am fine using dates, but do not need to. I really just need the times to align with the current time, so the formula will work.
I am open to changing the decimal times to something else, or arranging a new formula. Thank you.