Subtracting hours in a work schedule

Hello all,
Well, after a major meeting with the boss, guess what, she wants a change.
I have attached the new file.
She would like both the stores 93 and 15) on one sheet (which I have done).
I have the totals for (Grand Total) AR:AT completed correctly. However, in the employee "#day" and "#night" in columns AV:AY are not. I have tried a couple of different things to no avail. The total in AV:AM need to show the number of day shifts and night shifts across both stores for each employee.
Would someone give me a hand on this?
I would really appreciate it.
Thanks!!!