+ Reply to Thread
Results 1 to 3 of 3

Need help for vacation accrual

  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    san jose, CA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Need help for vacation accrual

    Hello,

    I am hoping someone could be of assistance. Does anyone know how to create a maximum amount in the sum from a formula. I am creating a vacation accrual spreadsheet where the number of hours worked dictate the amount accrued, but the problem I am running into is that some employees work a lot of overtime and with the formula I am using to sum up the total for each year ( =40/2080* # of hours) some of the employees worked over 2080 hours, so they are accruing more than one week (40 hours)

    YEAR Hours Worked Vacation Hours Accrued Vacation Taken Vacation Paid ACCRUED
    2010 3020 58.08 0 0.00 23.44



    Please help!

    Thanks,
    Ernie
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Need help for vacation accrual

    Put this in D2:

    =MIN(40,40/2080*C2)

    It will ensure that D2 never exceeds 40.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    04-18-2012
    Location
    san jose, CA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Need help for vacation accrual

    This was exactly what I needed. Thanks again Pete!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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