![]() |
Timeshets
Our yearly timesheets are divided into bi-weekly worksheets, displaying the
whole year. How do I formulate a running total for sick and vacation days? Example: In January, we should start out with 5 sick days and 10 vacation days, if someone takes a sick day in Feb. I want the running total to show 4. When the number reaches 0, is there also a way in which to not allow an employee to input for another sick day? -- Thanks, Holly |
Timeshets
You will need to specify more how you identify SICK.
Is it selected from a drop down list? Or just typed in a cell? Corey.... "Holly" wrote in message ... Our yearly timesheets are divided into bi-weekly worksheets, displaying the whole year. How do I formulate a running total for sick and vacation days? Example: In January, we should start out with 5 sick days and 10 vacation days, if someone takes a sick day in Feb. I want the running total to show 4. When the number reaches 0, is there also a way in which to not allow an employee to input for another sick day? -- Thanks, Holly |
All times are GMT +1. The time now is 06:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com