Adding negative numbers when the cell is blank

I have a formula to add different columns of clocking in and out times. I have it set up to show the Clock In times as negative and Clock Out times as positive in order to get the total for the day. However if the lunch time below are blank I get an #invalid operation. Guessing because the Lunch time in has the negative in front?

=-[Start Day - Time In Total Hours]@row + [Lunch - Time Out Total Hours]@row + -[Lunch - Time In Total Hours]@row + [End Day - Time Out Total Hours]@row

Any ideas on how to add when lunch times are blank?

Thank you!!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!