Forum Discussion

Deleted's avatar
Deleted
Jan 03, 2019

Formula HELP!!

I am needing to calculate how much PTO time has been accrued. The monthly rate varies depending on years of service. 1-4 years get 6.67 hours per month, 5-14 years get 10 hours per month, 15-24 years get 13.3 hours per month 25 and up get 16.67 per month. Cell B7 is hire date R7 is Years of service if that helps.

Resources