+ Reply to Thread
Results 1 to 6 of 6

Percentage Formulas

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Percentage Formulas

    I am new to this community and need help creating this spreadsheet. Our employees accrue time based on percentages, and this spreadsheet would be great to represent their accruals for time tracking and vacation. This workbook was created by an unknown person and is based on hours, but we need help making this work for our percentage based system. We want to track our employees' sick time, but they do not get penalized for them. We like the technology that this excel workbook offers to track their vacation accruals, but we are having trouble converting it for percentage representation. Attached is a sample worksheet and a table showing the vacation/accrual rates and parameters. Please help!!
    Last edited by nishi23; 10-10-2013 at 05:53 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,906

    Re: Need Help with Formulas for Spreadsheet

    thanks for the change.

    Looking at your files, could you show (even if calc'd manually) what your expected outcome would look like, and how you arrived at that?
    Last edited by FDibbins; 10-10-2013 at 06:04 PM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-10-2013
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Need Help with Formulas for Spreadsheet

    We are trying to use formulas to create a spreadsheet that keeps track of time off allowed for employees who work different percentage amounts of time. Let's use a hypothetical example.

    From the previous fiscal year I carried over 3 days of vacation.
    I work 100% time and accrue 1.7 month, and have accrued 6.8 days vacation this fiscal year (starting July 1, 2013). I will be taking off 5th-8th in November. How much available vacation time will I have at the end of November?
    The max number of days that I can carry forward are 35 at 100% time, and I accrue 20 days per fiscal year.
    100% X (1.7(12)) <= 35
    3 + (1.7 X 5) – 4 days = 7.5 available vacation days at the end of November

    Hope this clears things up!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,906

    Re: Percentage Formulas

    Does this relate to any info/cells in the workbook you provided? Im trying to follow along and see the logic

  5. #5
    Registered User
    Join Date
    10-10-2013
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Percentage Formulas

    We were given a spreadsheet that keeps track of employees' time off and right now the formulas used are calculated using hours, however we want to keep track using percentages rather than hours. The calculation above is a hypothetical example of an employee who's time off we would plug into the worksheet and then get the number of hours he or she would be allowed to take off. Basically we are just trying to convert the spreadsheet so that it works for our desired percentage based system rather than pre-existing hourly based system.

  6. #6
    Registered User
    Join Date
    10-10-2013
    Location
    California, USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Percentage Formulas

    Here is an example of a spreadsheet that works exactly how we want it to for employees that work 100%. However, we are having a hard time making it work for employees who work other percentages such as 80%, 60%, and so on. I would greatly appreciate it if you could help us make it work for the other percentages.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Time Sheet (Tie in extra spreadsheet to existing spreadsheet with formulas)
    By Eddie Elvis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-12-2013, 04:27 AM
  2. [SOLVED] Copying formulas from one spreadsheet to another...
    By Finalfrontier1976 in forum Excel General
    Replies: 0
    Last Post: 04-13-2012, 06:12 AM
  3. Formulas for Sales spreadsheet
    By RainLove in forum Excel General
    Replies: 2
    Last Post: 06-20-2010, 08:14 PM
  4. Locking all Formulas on a spreadsheet
    By Satanscat in forum Excel General
    Replies: 6
    Last Post: 01-30-2010, 01:15 PM
  5. [SOLVED] formulas in spreadsheet do'nt resond to changes
    By scuba51 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2005, 06:06 PM

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