Subtracting hours in a work schedule

Hi all,
I am still working with the schedule and I have made some headway.
However, there are time that an employee may not be scheduled and we need to put VAC, HOL, etc. in a time cell. How can I get this to not populate in the total? Also, when an employee is sheduled like at 2:15-9:15 the totals do not populate correctly. I FIXED THIS
Also, I am still stuck on one more problem:
If I may impose one more question?
With having 2 stores (2 sheets to do and print) with the same employees working at both store on any given day, how would you have the hours of the employees add up from one store to the other (a running total when we are inputting hours, on both schedules) making sure they do not have more than 40 hours? Some are part-time, so they would only be allowed 30 hours per week (Nick, Lynn, Bill and Troy). Should I have another sheet making a list of the employees names and coming up with someway to show how many hours we are scheduling them with the rules of no more than 40 and no more than 30 for part time? Or could I put it on the side of each store sheet (outside the print area) to show the hours being scheduled?
If I am imposing too much I completely understand.
Thanks again!!