Basic equation (reference):

=INT(SUMPRODUCT(SIGN(A2:B2)*(INT(ABS(A2:B2))+(MOD( ABS(A2:B2),1)*2.5)))
-(INT(ABS(C2))+(MOD(ABS(C2),1)*2.5))
+(SIGN(D2)*(INT(ABS(D2))+MOD(ABS(D2),1)*2.5)))+

MOD(SUMPRODUCT(SIGN(A2:B2)*(INT(ABS(A2:B2))+(MOD(A BS(A2:B2),1)*2.5)))
-(INT(ABS(C2))+(MOD(ABS(C2),1)*2.5))
+(SIGN(D2)*(INT(ABS(D2))+MOD(ABS(D2),1)*2.5)),1)*0 .4


Adjusts for negative balance:

=IF(G2<0,IF(G2<INT(G2),0.6+G2,G2),G2)

Cell A is hours cellB is hours earned cell C is used hours(leave) Cell D is
a plus or minus of donated hours.
A B C D BALANCE
(-) reference
40.3 4.2 1.1 0.3 44.3 44.3
41 4.3 1.1 1 45.2 45.2
41.1 5 1.2 1.1 46 46
41.2 5.1 1.3 1.2 46.2 46.2
41.3 5.2 2 1.3 47 47
42 5.3 2.1 2 47.2 47.2
42.1 6 2.2 2.1 48 48
42.2 6.1 2.3 2.2 48.2 48.2

-7.2 4 0 0 -3.2 -3.8
-3.2 4 0 0 0.2 0.2
-26 4 0 0 -22 -22
-0.1 0 0 0 -0.1 -0.7
-0.2 0 0 0 -0.2 -0.8
-0.3 0 0 0 -0.3 -0.9
-1 0 0 0 -1 -1
-1.1 0 0 0 -1.1 -1.7

iT ADJUSTS FOR NEGATIVES IN ORDER TO READ .25 AS .1, .50 AS .2 AND .75 AS .3

IF YOU CAN'T HELP -- SHORTEN THIS -- I WOULD LIKE TO THANK ALL OF YOU FOR
THE HELP THAT YOU GAVE IN ORDER FOR US TO COME UP WITH A SOLUTION THAT
WORKS...

THANKS
T