Posted by Lori on February 05, 2002 1:25 PM
I need to set up a spreadsheet that tracks remaining sick-time for employees. I have been playing with this for days and can't come up with anything! This sheet will track time taken and available time remaining for the entire year. If they take more time than they have, it needs to split it into days and then hours.
Ex: Employee has 24 sick hours available. If he takes a day, we will key in 8 hrs taken and then it whould show 16 remaining hours.
Another scenario is if he takes 32 hours, it should show 0 remaining, and 8 hours in a "NO Pay" column.
Lastly, if he took 36 hours, it should show 0 time remaining, and 1 day in a "NO PAY" column, and 4 hours in another "NO PAY" column. Any ideas?