"Bob Phillips" wrote in message
...


"R.P.McMurphy" wrote in message
...
Ok, Now I've got -

=MIN(C4,SUM(G4,L4,Q4,V4,AA4,AF4,AK4,AP4,AU4,AZ4,BE 4,BJ4))

i take it this will add up G4,L4,Q4,V4,AA4,AF4,AK4,AP4,AU4,AZ4,BE4,BJ4 as
long as each of these doesnt go over C4, and if any do, then they are
counted as the value in C4?

As long as the sum of those cells does not exceed C4.


If it does thats great! Next problem is how do i divide the answer by
0.09615 in the same formula?

Ooh, watch carefully, it's tricky <vbg

=MIN(C4,SUM(G4,L4,Q4,V4,AA4,AF4,AK4,AP4,AU4,AZ4,BE 4,BJ4))/0.09615

but are you sure you shouldn't multiply? I assume they get 0.09615 hours
per
hour worked so that would be multiply

=MIN(C4,SUM(G4,L4,Q4,V4,AA4,AF4,AK4,AP4,AU4,AZ4,BE 4,BJ4))*0.09615


Ah yes...you spotted the deliberate mistake! ;-)

so, just going back to the first calculation... if C4(the contracted hours)
= 39 and G4(actual hours worked) was 41 and L4(actual hours worked) was 33
(and all the others were zero) the outcome would be 39+33?

ta

steve