sum and subtract hours
What's in N4?
If you just want to calculate hours over 44
=MAX(total hours-44/24,0)
"D." wrote:
Hi,
I am trying to create a formula
=IF(SUM(H7:H13)44,SUM(H7:H13)-44,SUM(H7:H13))
these are hours being added
anything over 44 hrs a wk is overtime so I need the formula to be
something like this:
=IF(SUM(H7:H13)44,SUM(H7:H13)-N4,SUM(H7:H13))
+IF(SUM(H14:H20)44,SUM(H14:H20)-N4,SUM(H14:H20))
even the formula
=SUM(H7:H13)-44
gives me
###########
|