Help! I am new to all of this and need a formula to calculate the number of hours and vacation payout amount using the company seniority schedule, max roll over from prior year (40) hrs, used and unused hours.
I have explained what i have come up with an employees unused vacation payout and what other person got in my team in payroll. I know i am paying them double for some reason my calculation has been coming out wrong and i want to get this calculator right to be able to plug in the data from HRIS system and calculate it right. I have included policy and schedule as well.
Any help or guidance you could give me would be appreciated!
Thanks!
I have explained what i have come up with an employees unused vacation payout and what other person got in my team in payroll. I know i am paying them double for some reason my calculation has been coming out wrong and i want to get this calculator right to be able to plug in the data from HRIS system and calculate it right. I have included policy and schedule as well.
Any help or guidance you could give me would be appreciated!
Thanks!
Attachments

60.4 KB Views: 7