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?
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?
On Mon, 20 Feb 2006 19:06:31 -0800, "daduce_2"
<[email protected]> wrote:
>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?
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
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
"Ron Rosenfeld" wrote:
> On Mon, 20 Feb 2006 19:06:31 -0800, "daduce_2"
> <[email protected]> wrote:
>
> >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?
>
> 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
>
On Tue, 21 Feb 2006 03:08:28 -0800, "daduce_2"
<[email protected]> wrote:
>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
>
>"Ron Rosenfeld" wrote:
>
>> On Mon, 20 Feb 2006 19:06:31 -0800, "daduce_2"
>> <[email protected]> wrote:
>>
>> >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?
>>
>> 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
>>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks