I am new to this community and need help creating this spreadsheet. Our employees accrue time based on percentages, and this spreadsheet would be great to represent their accruals for time tracking and vacation. This workbook was created by an unknown person and is based on hours, but we need help making this work for our percentage based system. We want to track our employees' sick time, but they do not get penalized for them. We like the technology that this excel workbook offers to track their vacation accruals, but we are having trouble converting it for percentage representation. Attached is a sample worksheet and a table showing the vacation/accrual rates and parameters. Please help!!
Bookmarks