Lookup date/ time in range of dates and return binary value

[Woofy_McWoof_Woof]

Hi, I'm attempting to return a binary 1 or 0 value where a look up of a date/time matches a date in string of dates. In the attached picture where the date and time (30 minute slots) matches the time that falls within that 30 minutes then it returns a value of 1, otherwise zero.

The date and time could contain seconds as well butstill falls within the 30 minutes and should be counted.

I've tried few things but it doesn't seem to work, any ideas? Thanks.

 

[StuLux]

I'd suggest starting a new thread with your solution so far and this additional requirement. It might also help if you:
a) download the XL2BB Excel add in so you can post usable example and formulas etc in this forum (the link to download the add in appears when you are posting)
b) explain a bit more about your data and what you are trying to do as this may help a responder better understand the problem and possibly approach with a different solution.