Hello,
I finally figured out the formula to calculate vacation time based on anniversary date for full-time employees.
Now, within the same sheet, I need to calculate vacation time based on anniversary date AND hours worked for part-time employees.
Here is the criteria:
0-3 years of service 1 hour for each 20 hours worked with a maximum of 4 hours
3-15 years of service 1 hour for each 13 hours worked with a maximum of 6 hours
15+ years of service 1 hour for each 20 hours worked with a maximum of 8 hours
Example: A part-time employee works 50 hours per pay period and his start date was 8/25/2002. Manually calculating, he would earn 3.8 biweekly
A part-time employee works 32 hours per pay period and his start date was 6/19/2011. He would earn 1.6 biweekly
Thanks!
Bookmarks