so if i add*.4 to the end of this formula will it produce an answer of .1
or.2 or .3 as thiese aee the increments i need the hour is split inot
quarters and these numbers designate .25 .50 and .75

" wrote:

T wrote...
Ok - Within this formula i would need to add cell "d"
what this formiula does is calculate 6+2-1.2= 6.2
6= hours plus 2 accrued - 1.2=one and a half hours used = six and half
hours
I need it be able to read a negative value such as 8 +(-2) -1.2 +(-2)
=4.2

You're not going to get there with Bernie's formula if you need to sum
over an arbitrary number of cells. If you had entries like this in
A1:A20, e.g.,

6.2
-2.2
-1
-6.2
1.3
5.2
5
8.3
7.1
7.1
7.3
4.1
-6.1
5.3
1.2
-3.1
-4
-9.3
-6
0.2

The formula

=SUMPRODUCT(SIGN(A1:A20)*(INT(ABS(A1:A20))+MOD(ABS (A1:A20),1)*2.5))
returns 22.5.