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

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.

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.

Hello mmouse2020.

Welcome to the forum.

You should be able to click the file in post #1 and download it.

If that does not answer your question please start your own thread making reference to this one. If necessary refer to this thread by its title as you are not yet permitted to post links.

Deleted by me.

Originally Posted by mmouse2020

Thanks for the reply.
It tells me I don't have permission to view or download it!
I did start a new thread...

I can see no reason that would prevent you from downloading that file

I will start a new thread and add that file to it, please open that thread, try and D/L the file and post back to me on the outcome.

new thread is titled https://www.excelforum.com/excel-gen...mouse2020.html