Thanks everyone, but I found my own solution. The formula I'm using follows:

In A1 (date): 1/1/2010
In B1 (Balance- will be hidden): 0
In C1 (PTO Used): 0
In D2 (Balance- shown): 0

In A2: =DATE(YEAR(A1),MONTH(A1),DAY(A1)+14)
Copied down.
In B2: =D1+5.85
Copied down.
In D2: =B1-C1
Copied down.

Example:
1/8/2010 41.78 0 41.78
1/22/2010 47.63 5 42.63
--
~*Heather*~


"Heather" wrote:

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*~


.