View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WizTech WizTech is offline
external usenet poster
 
Posts: 1
Default How do I calculation vacation accrual?

I am attempting to calculate vacation accrual so that I can enter into
QuickBooks.

Vacation accrues as follows:
1) employee gets 1 week (40 hrs) after 6 month employment
2) employee receives 1 week vacation for every 6 months worked or portion
thereof
3) maximum vacation an employee can accrue is 4 weeks (160 hrs)
4) employee is paid bi-weekly (26 pay periods/2080 hrs annually)

I am attempting to create a formula to calculate the bi-weekly accrual rate
based on the above information.

Thank you