Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set a rule to add a number, but only if it is positive?
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. |
#2
|
|||
|
|||
How do I set a rule to add a number, but only if it is 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. |
#3
|
|||
|
|||
How do I set a rule to add a number, but only if it is 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. |
#4
|
|||
|
|||
How do I set a rule to add a number, but only if it is 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. |
#5
|
|||
|
|||
How do I set a rule to add a number, but only if it is positiv
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. |
#6
|
|||
|
|||
How do I set a rule to add a number, but only if it is positiv
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. |
#7
|
|||
|
|||
How do I set a rule to add a number, but only if it is positiv
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preceding a number by zeros, that is still a number | Excel Worksheet Functions | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
get lowest positive number | Excel Discussion (Misc queries) | |||
how do you get a positive number payment with a mortgage payment . | Excel Worksheet Functions |