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.