Chef --
I'm not sure what the rest of your worksheet is like, but this might work:

P Q R
1 54 =MIN(P1,40) =P1-Q1

Hope that helps.

"ChefFrank" wrote:

I have the employees time for the week add up in P and I need regular time in
Q and overtime in R.
something like hours reg ot
54 40 14