not sure, but this may help:

=MOD(SUM(A1:A100),40)

--


Gary


"BruceK" wrote in message
...
Dick Thank you is there a way to make it so it will only show postive (over
40 hours ) in another cell?

"Dick Kusleika" wrote:

On Sun, 3 Aug 2008 14:13:00 -0700, BruceK
wrote:

I need help figuring out a formula? Here is what I want to do

I want one cell to add up a column and if that number dosent reach 40 then
it takes more away from another cell but it only displays the 40 or lower
and
then anything over the 40 will be displayed in another cell

=MIN(40, SUM(A1:A100))
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com