I have a policy to deduct lateness from employee salary. The formula is for example,
Lateness charge per hour = (basic + meal + entertainment) / 234
Where contract.wage = gross salary of employee basic = contract.wage *0.20 meal allowance = contract.wage *0.10 entertainment = contract-wage * 0.15
I manually capture the no of hours employee is absent and for each employee I need to add this as input and get the formula to calculate the lateness charge by multiplying the hours inputed manually with the formula above. I need to do this for every employee who is later in the month. Remember that not all employees are late every month so the rule should work only on those whom I have entered input for no of hours late.
How do I use the salary rule to achieve this?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 7/13/13, 4:56 PM|
|Seen: 2647 times|
|Last updated: 3/16/15, 8:10 AM|