Answers.com > Wiki Answers > Categories > Jobs & Education > Jobs > Salary and Pay Rates > How do you calculate overtime pay on excel?

How do you calculate overtime pay on excel?

Answer:

Example:

Enter in cell:
A1 - Rate of pay
A2 - Hours worked
A3 - =(A2-8)
A4 - =(A1*8)+(A1*1.5*A3)

I double time is involed use A1*2 in Cell A4

This formula can be shortened but this is the simplest way I know.

First answer by ID1173802816. Last edit by ID1173802816. Question popularity: 2 [recommend question].

[report abuse]

Can you answer these Salary and Pay Rates questions?

	How much do professional soccer players win?	Answer it!
	Can someone be an underwater welder with a felony on their record?	Answer it!
	How much does Donovan Patton earn per episode?	Answer it!
	How much does an Essbase consultant earn?	Answer it!
	What qualifications are needed to be a mortuary makeup artist in Florida?	Answer it!

Relevant answers:

How do you calculate overtime pay?
Overtime pay... Most overtime hours are payed 1& 1/2 times your original hourly pay. SO if your payed $10.00 an hour you will be payed $15.00 for every overtime hour. $12.00 would be $18.00 an...
Explain how to calculate overtime pay?
If overtime pay is 1 1/2, then it would be calculated like so...(hours worked) x (regular pay) x 1.5
What is calculate in excel?
Calculate means Excel will evaluate formulas and functions to display the result. You can turn calculate to manual or auto. When it is on auto, everything is updated in real time. Manual will update...
How do you calculate overtime?
To calculate overtime, you multiply 1.5% times your hourly wage. When you get that, you multiply that times your overtime hours worked.
How is overtime rate and overtime pay calculated?
Overtime rate is 1.5. Overtime pay is standard pay (per hour) x number of overtime hours x 1.5. Overtime pay rate is then the standard pay (hourly wage) x 1.5. Example: If an employee has an 8-hour...