+ Reply to Thread
Results 1 to 4 of 4

Calculate cost of PTO to reach a standard time

  1. #1
    Registered User
    Join Date
    10-19-2021
    Location
    Bowie, TX
    MS-Off Ver
    2016
    Posts
    8

    Calculate cost of PTO to reach a standard time

    Okay so I am trying to create a formula that can take calculate cost of a PTO program. Here is some info.

    We have a standard PTO plan that give 40 hour PTO per year 1, 1- 4 years is 80, 5-9 is 120, and 10+ is 160.

    We allow people to negotiate PTO so we have plans that are standard plus 1 or plus 2 or plus 3

    I need to calculate the cost for the remaining of the year and the cost until the person gets to where they should be.

    So if they are on the standard plus 1 plan and have less than 1 year at organization they get 40 plus an additional 40. I am attaching my spreadsheet that has the information. Any help would be great. I am trying to find the multiplier in column AC to get me there.

    Any Help is appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Calculate cost of PTO to reach a standard time

    Hello and welcome to the forum.
    With all these things we need to understand your terminology (PTO ???) and see some worked examples.

    Please manually add some sample results and distinguish result cells from data cells.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-19-2021
    Location
    Bowie, TX
    MS-Off Ver
    2016
    Posts
    8

    Re: Calculate cost of PTO to reach a standard time

    I can do that. PTO is Paid time off. But I can add the additional items.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,633

    Re: Calculate cost of PTO to reach a standard time

    I believe that Richard is asking you to manually put some manually calculated values into cells AC3:AC6 so that we see if the forumlas/code that we write to automate those cells are correct.
    Unless it is completely obvious, we also need you to tell us how you calculated the values.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Calculate Standard/Overtime Labor Time and per diem
    By myoung84 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2021, 04:01 PM
  2. Calculate total cost/time per completed project.
    By Vague-ly in forum Excel General
    Replies: 12
    Last Post: 02-18-2019, 08:40 PM
  3. Replies: 1
    Last Post: 03-14-2017, 08:12 PM
  4. [SOLVED] Writing IF (AND) Statement to Calculate Payroll Standard and Over Time
    By juancastro in forum Excel Formulas & Functions
    Replies: 43
    Last Post: 02-13-2017, 12:17 PM
  5. Macro to calculate minimum time, cash to reach a certain level
    By hyped78 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-09-2013, 09:36 AM
  6. Replies: 8
    Last Post: 06-05-2012, 01:16 PM
  7. Calculate time and cost
    By Sjoestaal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2005, 09:06 AM

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