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)


"PaRtaP" wrote in message
...
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.

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.




"PaRtaP" wrote in message
...
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.

That will return for instance 37 if the hours worked is 37
when it should return zero

--
Regards,

Peo Sjoblom

(No private emails please)


"Barb Reinhardt" wrote in message
...
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.




"PaRtaP" wrote in message
...
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.

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.

"Barb Reinhardt" wrote:

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.




"PaRtaP" wrote in message
...
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.

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)


"PaRtaP" wrote in message
...
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.

"Barb Reinhardt" wrote:

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.




"PaRtaP" wrote in message
...
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.

Yea, I figured thanx again it would take me forever to do by hand now I have
a template made.

"Peo Sjoblom" wrote:

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)


"PaRtaP" wrote in message
...
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.

"Barb Reinhardt" wrote:

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.




"PaRtaP" wrote in message
...
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.