Ok, good deal! Thanks for the feedback!

Biff

"Robb27" wrote in message
...
Thank you Biff. The light bulb came on after I worked with your formula
for
awhile. I can see how it works now.
I was right, I was making it more complicated than necessary.

Rob


"Biff" wrote:

"Robb27" wrote in message
...
Biff,
Thanks for the assistance. But, it's a bit complicated for me. <insert
sheepish grin here I'm probably over-complicating it. An employee
earns
6.16
hours of PTO every 2 weeks, so. can the formula maybe just add that
number
to
the previous 2 weeks amount AND subtract 8 hours when they put PTO in
the
cell?

Rob

Well, now I'm not following you. Either of those formulas does exactly
what
you asked for.

add that number [6.16] to the previous 2 weeks

But how did you calculate the total for the previous 2 weeks?

Biff