I manage over 200 individual's paid time off and am sick of having to answer questions about their hours remainingSo 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!
Bookmarks