I have a excel calendar that we use for vacation days. Our leave year is April through the following March. I would like to add a 13^{th} sheet where in Column A would be an employee's name, Column B would be their starting leave balance. Column C is where I would like to have a formula that would subtract 8 hours of leave from Column B and put that result in Column C whenever the employees name is added anywhere in the first 12 sheets. Too make it a little more difficult, at times an employee would only take part of a day off. It would be put on the calendar as "Johnson 2L" meaning that Johnson took 2 hours of late leave. In that situation then Column C should only subtract 2 hours from Column B.
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

On Sheet13, paste each of these lines into C2 through O2, but make sure to press Ctrl+Shift+Enter rather than just Enter. Then you can fill down with that formula.
Some assumptions:
This will make a monthly total, and then a grand total in the O column. 

