I am trying to compile a time card in excel for the employees in the shop. I
have it set up to enter the hours worked per day and then at the end of the
week calculate total hours, regular hours(40 if in overtime) and overtime.
Overtime is a regular occurance, but some don't even hit 40 hours. how do I
make a calculation in the overtime box that will not be affected by those
that did not reach overtime for the week????
Any help would be great.....

=MAX(0,A1-40)

where A1 is total hours

"alli" wrote:

I am trying to compile a time card in excel for the employees in the shop. I
have it set up to enter the hours worked per day and then at the end of the
week calculate total hours, regular hours(40 if in overtime) and overtime.
Overtime is a regular occurance, but some don't even hit 40 hours. how do I
make a calculation in the overtime box that will not be affected by those
that did not reach overtime for the week????
Any help would be great.....

On 1 Aug, 16:08, alli wrote:
I am trying to compile a time card in excel for the employees in the shop. I
have it set up to enter the hours worked per day and then at the end of the
week calculate total hours, regular hours(40 if in overtime) and overtime.
Overtime is a regular occurance, but some don't even hit 40 hours. how do I
make a calculation in the overtime box that will not be affected by those
that did not reach overtime for the week????
Any help would be great.....

Not clear from the post, but SUMIF might do it? Or just an IF
statement (eg if you have a regular hours box and an overtime box,
then the overtime would be =if(regular<=40,"",calculation)

Thanks!!! That worked just how I needed it to!

Thanks a ton!!!

alli

"Toppers" wrote:

=MAX(0,A1-40)

where A1 is total hours

"alli" wrote:

I am trying to compile a time card in excel for the employees in the shop. I
have it set up to enter the hours worked per day and then at the end of the
week calculate total hours, regular hours(40 if in overtime) and overtime.
Overtime is a regular occurance, but some don't even hit 40 hours. how do I
make a calculation in the overtime box that will not be affected by those
that did not reach overtime for the week????
Any help would be great.....