Formula to ignore blank cells

[MRSWIN2709]

I am working on an excel time sheet. I have 2 groups of time in/time out and I have a column where X = no lunch (+30 mins) and blank/no X = lunch (-30 mins). I cannot figure out how to get it to skip blank cells (i.e. days not worked) and not return an error in the total column.

=IF(O12="X", ((E12-C12)+(K12-I12))+TIME(0,30,0), (((E12-C12)+(K12-I12))-TIME(0,30,0)))

Thank you in advance

 

[Joe4]

Welcome to the Board!

Wrap it in another IF, first checking for values in column C and E, i.e.

=IF(AND(C12<>"",E12<>""),your original formula,"")