0
How in excel would you calculate the total pay for an employee who receives regular time for 40 hours time and a half for 40-50 hours and double-time for hours over 50?
Wiki User
∙ 14y ago
-- The number of hours will be entered in Column-A.
Type in B1: " =if(A1<=40,A1,"") "
Type in C1: " =if(and(A1>40, A1<=50),A1-40,"") "
Type in D1: " =if(A1>50, A1-50,"") "
Type in E1: " = F1 * (B1 + 1.5*C1 + 2*D1) "
Type in F1: the employee's regular hourly rate of pay
Copy (B1 through D1) down some handy distance.
========================================
When you enter the number of hours worked in the week in Column-A,
the employee's total pay for the week appears in Column-E.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Calculate the measure of a central angle of a regular nine-sided polygon?
40
How is overtime pay usually calculated?
Example: Employee works a total of 55 hours during the week. The employee had 40 hours of "Regular Time" (sometimes called "straight-time") and 15 hours of "Overtime."
How do you calculate huminity?
Huminity is a social networking, chat and Blog software. Like any other networking site you can calculate it in terms of the number of members, numbers of "regular" users, etc.
How do you calculate degrees of the inner angles of a regular polygon?
n=number of sides [180(n-2)] / n
How do you calculate the volume of a ten sided dice?
That depends on what the shape of the faces of each side of the polyhedron is - since a ten-sided figure does not create a regular polyhedron, it is impossible to calculate its volume based simply on this information.
When you work for regular pay.. what are you called?
Employee.
What is minimum wage for bartender in New Hampshire?
The Federal Labor Standards Act allows employees who receive regular tips to be paid less than minimum wage, as low as $2.13 per hour. A tipped employee is defined as any employee who receives at least $30 in tips a month. So it could be as low as $2.13.
How would you define employee benefits?
Employee benefits are compensations given to employees in addition to regular salaries or wages.
What is a part time employee?
An employee who works part-time hours on a regular, long-term, continuous basis.
What the employee discount at garage?
50% off regular price !
Is distance course is equivalent to a regular course for an govt employee?
no
What is the difference between an annuitant and a beneficiary?
An annuitant is a person who receives regular sums of money that was earned by them. A beneficiary is a person who receives regular sums of money from someone else who has past away and selected them to receive the funds.
Employee regular earnings are calculated as?
Number of regular hours worked in pay period x hourly rate
Is it legal for an at will employee not to get paid for staying past their regular work hours?
yes
How do you calculate the volume of a regular shaped object?
conclusion
How much do cooks make per hour?
it depends if your status is contractual or if you are a regular employee.
What is the definition of regular employee?
An employee that is hired by a company, worked for at least 90 days and upon hiring had no specific end date of employment. An independent contractor would not be a regular employee because they are under a contract where at some point in the future the job would be considered to be completed or the contract must be renewed. Other types of non-regular employees would include temporary and seasonal employees.
