Laurel Adams
New Member
- Joined
- May 8, 2015
- Messages
- 1
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
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