Try it like this:

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

(changes in red).

Hope this helps.

Pete