+ Reply to Thread
Results 1 to 4 of 4

Is there a simpler way to calculate accrued sick time?

  1. #1
    Registered User
    Join Date
    11-18-2019
    Location
    Canada
    MS-Off Ver
    365
    Posts
    2

    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
    Attached Files Attached Files
    Last edited by 6StringJazzer; Yesterday at 12:06 AM.

  2. #2
    Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Nepal
    MS-Off Ver
    2010
    Posts
    169

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

    Try this formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If this doesn't work, some sample data with desired result would help.
    If helpful reward by clicking on star bottom left.

  3. #3
    Registered User
    Join Date
    11-18-2019
    Location
    Canada
    MS-Off Ver
    365
    Posts
    2

    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. #4
    Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Nepal
    MS-Off Ver
    2010
    Posts
    169

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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