How do I set a rule to add a number, but only if it is positive?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add hours together using Excel, the problem is if the hours
are greater than 40 then I have to subtract 40 hours and add the remaining
number to the O.T Hours. How do I set a rule to add a number, but only if it
is positive?
For example 43.56 hours - 40.00 = 3.56 hours add to O.T. hrs which = O.T. +
3.56 this is okay because the first number is greater than 40.00 so the
result is positive but what if it was 36.42 - 40.00 = -3.56 add to O.T. hrs
which = O.T. - 3.56 this is not what I want because I don't want to subtract
hours I only want to add the hours if positive.
 
One way

=MAX(0,C2-40)

where C2 holds 3.56

--
Regards,

Peo Sjoblom

(No private emails please)
 
Have you tried using the MOD function.

=MOD(A1,40)

I'm not exactly clear on what you want, so please come back and let us know
what else you might want.
 
That will return for instance 37 if the hours worked is 37
when it should return zero

--
Regards,

Peo Sjoblom

(No private emails please)
 
Thank you for your help!!!! You guys solved one of my big problems trying to
orgnize hours for employees, I wasn't sure if I was clear when posting, but
Peo Sjoblom your way worked perfectly, I haven't tried the MOD way but I
will, once again thank you both for ur help.
 
I had a typo but I assume you figured that out, C2 would obviously hold
43.56 not 3.56

--
Regards,

Peo Sjoblom

(No private emails please)
 
Yea, I figured thanx again it would take me forever to do by hand now I have
a template made.
 
Back
Top