+ Reply to Thread
Results 1 to 2 of 2

Tricky PTO tracker question

  1. #1
    Registered User
    Join Date
    04-03-2013
    Location
    Bloomington, IL
    MS-Off Ver
    Excel 2010
    Posts
    2

    Tricky PTO tracker question

    I manage over 200 individual's paid time off and am sick of having to answer questions about their hours remaining So I am trying to create a tracker for the talent that will automatically tabulate their hours left. PTO works as followed: They begin to accumulate 6.67 hours after they have worked a FULL calendar month(i.e if they start April 5, they will accrue 6.67 in May, to be available on June 1) I created a simple tracker that automatically adds the 6.67 hours after the 1st of the month, but i also wanting to be able to add the employee's start date and have it check against that first, to make sure they are eligible to receive the PTO. I am only moderately skilled in excel and am not sure how to tackle this issue. Any help would be greatly appreciated!

  2. #2
    Registered User
    Join Date
    04-03-2013
    Location
    Bloomington, IL
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Tricky PTO tracker question

    PTO-TrackerForTalent.xlsx oops, i think i forgot to attach it

+ 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