time difference - conditional formatting and fix

Thanks, this one is worksbetter, I just had to change It to :

=IF(OR(B3=0,C3=0),0,C3-B3+(C3<B3))

But now I have problem with CF formula. I changed It to :

=10/24>=IF($C3>$D3,1,0)+$D3-$C3

because 11 hours between times is still allowed, but not 10 hours.

Problem now are night shifts. If I select for example a 18:00-06:00 on Sunday, CF should immediately highlight If I try to select start time cell value on Monday that is less than 11 hours after that time interval on Sunday. Current Cf does that too, but start time cell value has to be larger than end time of previous day. However, It highlights properly for 10 hours If value is higher.

I guess like I'm not making myself clear, so please take a look at attached sample, and focus only on cell C3 & D3. I set solution like a night shift on Sunday, and day shift on Monday was to be entered. That can be allowed only If 11 hours time difference between shifts.

Can this be even fixed ??


Thanks for all your help !!