Hello, Can someone kindly help me with this trouble.

I have a few columns formatted as h:mm.

Start Time = A2
End Time = B2
Result = C2

I want to subtract A2 from B2 (B2 - A2) and show the difference in C2.

I then want to say if C2 = 0:00 then display "Full".

If C2 0:00 then display "Available".

If C2 < 0:00 the display "Overbooked"


Although I do see 0:00 in the result column (C2), the logic does not work

I would greatly appreciate any help on this.