# Excel formula Hello, I have an excel assignment that I am working on, and I am at an impass, I hoping that someone will be able to help me... I need to create a formula that calculates over time for anything over 40 hours. If the person has worked over 40hrs the formula will give you their overtime pay if they haven't the value will be 0. (C11+1.5*MAX(0,C11>40))*D11 (C11 hours worked D11 Hourly wage)this the formula that i have been trying to tweak for the last two hours, this formula gives me their regular rate of pay, which I do not require. Please help me.

Posted by on

• Anonymous Dec 26, 2008

Now I need to know how to added to the regular pay to the overtime formula to give me the total pay

• Anonymous Dec 26, 2008

how do you create a formula for wages earn by commision

×

• Level 1:

An expert who has achieved level 1.

• Contributor

HELLOW,

I have to calculate weekly overtime, anything over 48 hours, but the same time, if an approved leave is there, OT will be counted, similarly un approved leave , i.e. Absent, OT will not be counted.
I hve to calculate monday to saturday. 8 hours is the single working hours. Can anybody help me. sanjaydamodar@indiainfo.com

Posted on Apr 13, 2009

• Level 2:

An expert who has achieved level 2 by getting 100 points

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Expert

Hello,
The formula should go like this:
=IF(C11>40,(C11-40)*D11,0)
This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.
Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:
=IF(C11>40,(C11-40)*D11*1.5,0)

Posted on Sep 15, 2008

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What is the function of Microsoft excel?

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

### Excel 2003: Help with LOG formula

You've got some parenthesis in the wrong place. Try this:
=(86.01*(Log10(B2-B3)))-(70.041*(Log10(B4)))+36.76

Apr 06, 2009 | Microsoft Office Excel 2003 for PC

### Formulas in microsoft excel 2007

Excel 2007 has a rather elaborate formula pull down menu.it out,

Loringh

Nov 12, 2008 | Microsoft Excel for PC

### I need Excel's Furmula's

I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

http://www.techonthenet.com/excel/formulas/

http://www.ozgrid.com/VBA/Functions.htm

Sep 20, 2008 | Microsoft Computers & Internet

### Excel formula

I'm assuming you'd like to assign a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.).

Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.

Now click back to Sheet1 where your data is and in A2 put this formula:
=VLookup(A1, Sheet2!\$A\$1:\$B\$x, 2, FALSE)
Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.

You can copy and paste this formula down the column to calculate your other values.

Hope that helps!
Terry

Aug 30, 2008 | Microsoft Excel for PC

### How many formulas we can use at a time in Excel

That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

### EXCEL ALL SHORT FORMULA

hiiiiiii
u know vlookup function,then piviot table
u know na tell short formula
genious...

Dec 14, 2007 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

698 people viewed this question

Level 3 Expert

Level 3 Expert