Excel Time Sheet - Error in calculating total hours
I have this set up pretty basically, I believe. Column C are the days of the week, Column D is the date, Column E is the time clocked in, Column F is the time clocked out and Column G are the total hours worked for that day. In G18, I've set up (or so I think) the formula to calculate this employees total hours for the work week =(G4+G6+G8+G10+G12+G14+G16). As of now, my employee has worked 32 hours but it is showing only 7 hours total. Our work week runs from Sunday to Saturday and not all of the employees work the weekends. This employee did not work Sunday and after reading another discussion question, I've come to realize that the time in and time out for Sunday cannot just be blank. If that is the reason for my error in total hours, what formula or word or WHATEVER can I type in to make the value 0?
(I thought a visual may help)
-----C-----D-----E-----F-----G-----
Sunday 1-Nov