payroll issues, I cannot get overtime hours to calculate correctly

[Laurel Adams]

I feel I have complicated my payroll and now I cannot find the right format/formula to do what I believe to be a simple calculation.
cell J9 = total hours and is formatted as [h]:mm
the formula in cell O9 is =max(0,J9-40) it is formatted as [h]:mm
the hours in cell J9 for the week are 42:11, the return in cell O9 should be 2:11 but I get all sorts of crazy returns depending on the formatting ie 00\:00, hh:mm, under numbers formatting 2 decimal places but not a single result is close to 2:11, what have I done and where do I need to go from here, after finding the proper formula for this the final step is to calculate overtime pay.
I am a novice user, self taught and terrible with the lingo, but I do love Excel and hope to get answers to my dilemma.
Thaks in advance for any help you might offer - Laurel

 

[MARK858]

Have you tried...

=MAX(0,J9-(40/24))

or just

=J9-(40/24)

 

[Dave Patton]

=MAX(0,J9*24-40) format as number with 2 decimal places

This yields 2.18 hours which is equivalent to 2 hours and 11 minutes