Yes.
First, choose a date - the first of some month in the past where you know
what your leave balance was at that day. You must also know how many days
leavel you've taken since that date.
Put the date in cell A2
Put the leave balance you had on that date in B2
In C2 put this formula:
=((YEAR(NOW())-YEAR(A2))*12+MONTH(NOW())-MONTH(A2)) * 4
That is the formula that calculates the number of hours you have accrued
since the date you entered in A2, assuming 4 hours per month.
Keep up with the number of hours you have used in D2 and continue to update
the number in that cell as you use more leave.
In E4 put this formula:
=B2+C2-D2
That is like saying Available Hours = Starting Balance + Accrued - Used
and it will tell you how many hours you have available at any given moment
as long as you keep D2 updated with the number of hours you use. The formula
for calculating the months between dates comes directly out of Excel 2003
Help. You could also use the DATEDIF() function - see Chip Pearson's site
for more assistance in dealing with times and dates:
http://www.cpearson.com/excel/MainPage.aspx
HTH
