Time and text calculations

[jdubbs41]

I am trying to build a weekly time sheet with in and out times, as well as "vacation" and "off" text in the cells, but when I sum everything up, I get a value error. Is there a way to use a function in addition to the sum function to tell excel the text is either zero or a number?

 

[jdubbs41]

Thanks, I will try doing that. I appreciate the help.