D
Dipwind
I work with a workbook where I register the time used by each worker.
I intend to obtain the totality of hours for each employee a day. th
number of employees can vary a day, but they are usually 30.
Rate for employee varies and I have that information in another tabl
that is constituted like this: base + skill + indirect + tax
overtime.
All the employees have an only badge what allows me to know that th
employee 27 receives x skill or x base.
my problem is to collect information on overtime, because the rat
overtime is only valid after they do 40 hours.
If the employee 27 on Friday has already done 40 hours, the hours tha
he does beyond will have the rate overtime. now I make that manually
there is some formula for I get that information in an automatic way?
can anybody help?
many thanks
João Pedro
Dipwin
I intend to obtain the totality of hours for each employee a day. th
number of employees can vary a day, but they are usually 30.
Rate for employee varies and I have that information in another tabl
that is constituted like this: base + skill + indirect + tax
overtime.
All the employees have an only badge what allows me to know that th
employee 27 receives x skill or x base.
my problem is to collect information on overtime, because the rat
overtime is only valid after they do 40 hours.
If the employee 27 on Friday has already done 40 hours, the hours tha
he does beyond will have the rate overtime. now I make that manually
there is some formula for I get that information in an automatic way?
can anybody help?
many thanks
João Pedro
Dipwin