I work for a company that has a lot of employees. I maintain accrual records for the hourly staff until we can import them into our payroll platform. Excel is what I use. I built the identical workbook in Google Sheets so that it can be accessed by other departments.
I have attached a sample of the sheet. The sheet tracks accrued sick time in hours and vacation time in days. The vacation time is straight forward. It is the sick time formula I that I am looking to improve. This would be column F - Accrued Sick Days.
The formula is as follows -
=IF((E2/22) *8, "80")
Column E - Worked days keeps track of the total worked shifts for an agent.
For every worked shift, an agent accrues 1 day of paid sick time. This is then converted to 8 hours. The maximum hours that an agent can accrue is 80 hours per year. Our HR doesn't care if you work part time, full time, or splits. Every 22 shifts, an employee would be eligible for 1 day or 8 hours of sick paid time.
Is there an easier way for me to do up the formula or is what I have sufficient? I am trying to clean up the formulas in my workbook.
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Is there a simpler way to do this?" does not tell us about your question. I have updated it for you this time because you are a new member. --6StringJazzer
Bookmarks