+ Reply to Thread
Results 1 to 2 of 2

Calculate PTO Time by Start Date

  1. #1
    Registered User
    Join Date
    10-07-2007
    Posts
    88

    Calculate PTO Time by Start Date

    PTO Calculation.xlsI am making a spreadsheet that calculates PTO for employees. Employees with 0-5 yrs get 2.308 hours a week up to 120 hrs/year. Employees with 5+ yrs get 3.077 hours a week up to 160 hrs/year. I am attaching the setup that I would like to use. I came up with a formula that works except for 1 problem:
    If the employee reached their 5 yr mark during the year,such as employee #2 does in the attachment, how can I formulate 2.308hrs/week up until they reach their 5yr mark and then do 3.077hrs/week from then on out?

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Red face Re: Calculate PTO Time by Start Date

    Some of these posts .... Hope you like it.

    This will give you the PTO as per today.
    Input is start date.
    This can be anything < today (also yesterday)

    Please Login or Register  to view this content.
    This is my test
    HTML Code: 
    It works, but I hope someone will find a lookup table approach.
    Last edited by rwgrietveld; 01-18-2010 at 06:00 PM.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

+ 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