answersLogoWhite

0

-- 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.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the difference between a worker and an employee?

A worker is a broad term that includes anyone who performs tasks or services for pay. An employee is a specific type of worker who is hired by a company or organization and receives regular wages or salary in exchange for their work.


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.


What is a part time employee?

An employee who works part-time hours on a regular, long-term, continuous basis.


How would you define employee benefits?

Employee benefits are compensations given to employees in addition to regular salaries or wages.


Is distance course is equivalent to a regular course for an govt employee?

no


What the employee discount at garage?

50% off regular price !


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.