finding night hours (0-day,1-night) between ranges of data

Hello, I am trying to resolve the problem of finding the night hours.

I have the range of data set for nine years (for each hour) in one column, and in another columns I have for each day: rising and setting time of the sun. What I am trying to get is eg. for each hour in column A, I am trying to get a value 0 (if it is between the rising and setting time)-day or value of 1 if it is a night (between setting and rising time). It should correspond to the same day in column A(that is hourly time step) and B (that is daily time step).


I attached also a draft xlsx file.

Hope that someone can help me to resolve this

Thanks a lot !

Mark