try this:
=SUMPRODUCT(--(A2:A120),--(A2:A12<40),(A2:A12))

Regards,
Ryan--


--
RyGuy


"Luke M" wrote:

You will need to use two formulas.
First column formula:
=if(sum(a1:a5)<=40,sum(a1:a5),40)
Second column:
=if(sum(a1:a5)40,sum(a1:a5)-40,"")

The second column will be blank if there is no overtime.
--
Best Regards,

Luke M


"justnotgettingit" wrote:

I am trying to sum a column of hours and minutes to calculate straight hours
and overtime. If the sum is <=40, then sum; otherwise move excess to the
next column. What is the foluma I should use to do this. I'm stumped.