Excel formula if time fall between

[Mihailovskii]

I have current time [=NOW()] in cell D5, and i have 2 times in cells A1 & A2.

D5 = NOW()
A1 = 07:00
A2 = 15:00

I need formula in "B5", if time from D5 fall between A1 & A2 to be 1, if time is greater or lower to be 0.

I try it with =IF(D5=MEDIAN(A1:A2);1;0) but it don't work.

Please help me

 

[azumi]

in B5:

=IF(AND(D5-INT(D5)>=A1,D5-INT(D5)<=A2),1,0)

 

[Mihailovskii]

in B5:

=IF(AND(D5-INT(D5)>=A1,D5-INT(D5)<=A2),1,0)

Thanks brother,
It's work!