Timesheet calculation

MY time sheet calculates the hours worked correctly, and the hours worked after removing luch breaks correctly.

Then I limit the number of hours to 40 per week using =MIN($H$3,M15) with $H$3 representing 40, which does what it is supposed to, however when I calculate OT for all hours greater than 40, using this formula =MAX(0,M24-$H$3) the calculation ends up to be 3.3 instead of 3.25


Hrs wkd actual limit OT
45.75 43.25 40 3.25

You can try formatting the cell with the formula to Number with 2 decimals. It may simply be a rounding issue (rounding .25 to one place will give you .3)

Good Luck

Bruce

There has to be something else going on with your formulas, as there is no way 3.6 should be returned.

I don't know what formulas are behind the scenes to H3 or M15, but it may be that they need to be rounded to two decimals, e.g.

=Round(your current formula here,2)

Give that a try. Also, if this doesn't work, you should post more specific data so we can evaluate your issue.

Good Luck

Bruce