Hello,
I need to calculate PTO accrual based on hire date and track PTO. An employee will accrue 120 hours of vacation for 1-5 years of service, 160 hours of vacation for 6-10 years of service, and 176 hours of service for 11+ years of service. Each employee has a separate work sheet. Can anyone help? (I think I attached a sample of the worksheet I'm trying to use.)
Thank you!
Welcome to Excel Forum.
If I understand correctly you want to automate the populating of cell C6 (monthly accrual). If so try the following formula:Let me know if you have any questions.Formula:
Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
did you get it fixed?
Hello jjmaddog9. Welcome to the forum.
You may not have noticed, but this thread is nearly 4 years old. It is doubtful any of the original participants are still monitoring activity on this. If you have a question and feel this thread is relevant to it start your own thread and reference this by title explicitly by title. You will be unable to post links for a while as a new member though.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks