# Is there a simpler way to calculate accrued sick time?

1. ## Is there a simpler way to calculate accrued sick time?

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

2. ## Re: Is there a simpler way to calculate accrued sick time?

Try this formula

Formula:
`Please Login or Register  to view this content.`

If this doesn't work, some sample data with desired result would help.

3. ## Re: Is there a simpler way to calculate accrued sick time?

Thank you! It is cleaner than mine and does what I need it to do!

4. ## Re: Is there a simpler way to calculate accrued sick time?

If this works please mark the thread as "SOLVED"

Also, if you wish, you can say thanks by clicking the STAR bottom at bottom left.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1