Hello,
I have the following formula and am trying to also add to this the condition that if Cell K and I are blank then the return would be ,"", blank

=IF(AND(K13>=0.479167,I13<=0.479167),K13-I13-"00:30",K13-I13)

I have tried adding the ,"" several places and adding more if and statement to no avail.

It is for adding hours and subtracting a 30 min lunch based on if before or after 11:30 the rest of the formula works as it should, however if my cells are blank it displays#Value and I want it to display blank.

Please help.

Thanks,
Cristy