ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Timeshets (https://www.excelbanter.com/excel-worksheet-functions/119712-timeshets.html)

Holly

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

Corey

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