Can you put two functions in one cell?

D

daduce_2

I am trying to get one cell to add hours worked, and if over 40 hours, add
the number of hours to that cell. The only way I can see to do it is to have
2 functions in one cell. Is this possible?
 
R

Ron Rosenfeld

I am trying to get one cell to add hours worked, and if over 40 hours, add
the number of hours to that cell. The only way I can see to do it is to have
2 functions in one cell. Is this possible?
Click to expand...

What do you want to have show in the cell if there are 40 or fewer hours?

If you just want to count overtime hours, then

=MAX(0,Hrs_Worked - 40)

You can format to not show the zero, if you wish.


--ron
 
D

daduce_2

Yes, your right I left that part out. Can you get the same cell to put
overtime hours or if less than 40, put those hours also.
Thanx for the response
chris
 
R

Ron Rosenfeld

Yes, your right I left that part out. Can you get the same cell to put
overtime hours or if less than 40, put those hours also.
Thanx for the response
chris
Click to expand...

Well, you could do something like:

=IF(Hrs_Worked>40, Hrs_Worked-40, Hrs_Worked)

but how would you know if the number being displayed was the regular time or
the overtime hours. IOW, how would you want to differentiate between the
person who worked 20 hrs and the person who worked 60 hrs. Using your
specifications, the cell would show 20 in both instances.


--ron
 
Top