Alexwolfey
New Member
- Joined
- Oct 25, 2022
- Messages
- 3
- Office Version
- 365
- 2021
- Platform
- Windows
Hello,
Our employees receive PTO accrual per month. If they are entitled to 40 hours of PTO per year they accrue at a rate of 3.33 hours per month, and if they are entitled to 80 hours if PTO per year, they accrue at 6.66 hours per month.
I have my spreadsheet so far set up like this as an example:
PTO total hours per year PTO available balance PTO hours used
40 *Want this to auto calculate with formula based on monthly accrual* *When i add hours to this column i want it to subtract from the available balance*
For this example, I would like a formula to calculate automatically in the column "PTO available balance" to accrue at 3.33 hours per month then when I add "PTO hours used" the formula will subtract those hours from the "PTO available balance.
I just cant seem to figure this formula out and any help would be greatly appreciated!
Our employees receive PTO accrual per month. If they are entitled to 40 hours of PTO per year they accrue at a rate of 3.33 hours per month, and if they are entitled to 80 hours if PTO per year, they accrue at 6.66 hours per month.
I have my spreadsheet so far set up like this as an example:
PTO total hours per year PTO available balance PTO hours used
40 *Want this to auto calculate with formula based on monthly accrual* *When i add hours to this column i want it to subtract from the available balance*
For this example, I would like a formula to calculate automatically in the column "PTO available balance" to accrue at 3.33 hours per month then when I add "PTO hours used" the formula will subtract those hours from the "PTO available balance.
I just cant seem to figure this formula out and any help would be greatly appreciated!