overtime calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.....
 
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.....
Click to expand...

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)
 
Back
Top