It's accurial world!

In A1 enter 4/15/2008
In B1 enter 0

In A2 enter:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) and copy down

In B2 enter:
=B1+4.62 and copy down.

You will see:

4/15/2008 0
5/15/2008 4.62
6/15/2008 9.24
7/15/2008 13.86
8/15/2008 18.48
9/15/2008 23.1
10/15/2008 27.72
11/15/2008 32.34
12/15/2008 36.96



--
Gary''s Student - gsnu200810


"MargaretA" wrote:

I need to be able to track accrued leave time, but have no idea how to set up
the formula. Here are the particulars:

Accrual rate = 4.62 hrs. of leave per month, # of months = 12

I occasionally use a few hours in a month.

This year, I began employment in mid-April, so would you be so kind as to
provide 2 different formulas? (1 for a regular year, Jan.- Dec., and another
for this year mid-April - Dec.).

Thanks, in advance, for help!

Margaret


--
MargaretA