I have a small sheet that I would like to use for my employees hours.
So what I want is a formula that will do the following.
I want it to work out that if I have 45hours or less it will place that amount in the hours cell and place "0" in the overtime cell, but if it is more than 45hours, to place "45" in the hours cell and what is left, the difference, in the overtime sell. 45 being the hours per week before overtime is calculated.
I know it is probably some simple formula but my brain is stuck on this one.
At the bottom is the hours cell and overtime cell. Please note that the left side is days of the week, it is just in another language. Monday to Sunday.
=if( SUM(E2:E8)<=45, 0, SUM(E2:E8)-45 ). (Note that this does not adjust for weekend hours counting as 150% or 200%, but neither does just sum in cell E7).