Test Time Sheet 2013.zip
Here is the file I'm working in. the issue is perhaps better cleared up with this.
D5 has 1:00pm and G5 has 9:00pm.
Row 8 has the check boxes and row 37 is where I want my information to show.
If Sun and Monday are false, the in the corresponding boxes in row 37, it would show the shift hours for that day. if false as Tues and Wednesday show, then it would show no hours.