I need to develop a tracking spreadsheet (for 12 employees) that will calculate accruing vacation time (on one worksheet) based on the following parameters:
Employees who have worked less than 3 years with the company:
- 2.91 hours biweekly
Employees who have worked more than 3 years but less than 8 years with the company:
- 4.38 hours biweekly
15 years and over with the company:
- 6.41 hours biweekly
In addition I need to be able to deduct vacation time used. Does anyone have any suggestions for layout or for a formula that can do part of these functions? I appreciate any advice!
Bookmarks