Thank you Roger for a quick answer but I don't understand the formula very
well. I'm sorry, I just don't use excel very much.

"Roger Govier" wrote:

Hi Diana

Try
=MIN(40,your_sum_formula)


Regards

Roger Govier


Diana wrote:
I was wondering if someone could help me. I was needing a formula that could
count how many hours someone has but for it to stop counting at 40. I hope
someone understands me. Thank You.