I am working on the FY19/20 budget and I need help writing a formula to calculate PTO.
0-2 years .05770 p/hr worked
3-7 years .07693 p/hr worked
8+ years .09615 p/hr worked
2019-03-04_9-20-06.png
Any Suggestions?
THANK YOU
I am working on the FY19/20 budget and I need help writing a formula to calculate PTO.
0-2 years .05770 p/hr worked
3-7 years .07693 p/hr worked
8+ years .09615 p/hr worked
2019-03-04_9-20-06.png
Any Suggestions?
THANK YOU
Hello atadam and Welcome to Excel Forum.
I suggest that you upload a small fictionalized sample of your data along with manually produced expected results that we can attempt to replicate using formulas/code. The data and results should reflect the three categories (0-2, 3-7 and 8+) stated in post #1. Also be sure to show us any 'special cases' if applicable.
To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks