Sorry, it accrues every pay-period (14 days). Also, I don't need to start at
the beginning of their hire date. What I'm trying to do is figure out a
formula that will take the current balance and add 5.85 hours for a new
current balance every 14 days, also deducting any time used. I know how to
add them up, just don't know how to set a formula to auto-calculate every 14
days. If it helps, our current columns a Employee name; Accrual Rate (5.85
hrs / 14 days); Previous Balance; PTO Used this pay period; Current Balance.
I'm not against having additional columns if needed. We just started this
report, and would prefer not having to access each timecard & manually enter
PTO accrued up to current date. I just tried out "previous
balance+accrual-taken=current balance" but I'm looking for something that the
previous balance would not have to be updated each time. Thanks.
--
~*Heather*~


"Bob Phillips" wrote:

What constitutes 2 weeks (14 days, 10 working days)? What happens if they
started 2 weeks and 3 days ago?

--

HTH

Bob

"Heather" wrote in message
...
Good morning! I have searched for this, and couldn't find anything that
satisfied what I'm looking for. I'm hoping to find some help with this. I
need a formula that will auto calculate time accrued (PTO) at a rate of
5.85
hours every 2 weeks. I know employee start dates, and have the current
balance of PTO, just need to be able to add to it w/ out having to go
through
our payroll system & manually update for each person. Thank you!
--
~*Heather*~


.