It looks like Richard's is the problematic formula.

=IF(AND(ISBLANK,C9),IFERROR(IF((C$11<>"Yes")),"", C$9+((C$8-C$10)/24)),"")

ISBLANK,C9

IF((C$11<>"Yes")),"",