Replicating a time as a single digit

[MarkoGreenio]

Hi all,

I hope you all well and keeping safe!

I am not sure how to explain this problem in the title so please feel free to recommend if required.

What I would like to do is represent someone's shift as a '1' in a single cell for the length of his shift. I used to have a formula for this but lost it somewhere, any help would be hugely appreciated.

The attached document represents what I need and I am sure you will get more from that than my explanation.

Thank you all in advance.

Mark

[Bo_Ry]

Please try at D2

=(--TEXT(D$1,"h:m")>=$B2)*(--TEXT(D$1,"h:m")<$C2)

and custom format 0;; to hide Zero

or
=IF((--TEXT(D$1,"h:m")>=$B2)*(--TEXT(D$1,"h:m")<$C2),1,"")

[MarkoGreenio]

Thank you Bo, both work a treat

Thanks again Mark