FORMULA FOR MONTHLY ACCRUAL...... HELP

[Alexwolfey]

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!

 

[James006]

Hello,
You could test

=MONTH(TODAY())*TIME(3,33,0)

with custom format hh:mm

 

[Fluff]

Duplicate to: Calculating Monthly PTO Accrual Formula Help

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.