Forum Discussion
Calculating OT in Excel
Hello, I am making a spreadsheet to track hrs worked up to 40 at one rate and anything over 40 at a 1.5 rate. I am using the formula =sum(n6:n12) to total my regular hours. I display this value in ...
Hi Gene,
It could be: in N15
=MIN(SUM(N6:N12),40)
in N17
=MAX(SUM(N6:N12)-40,0)
and attached