Question about Business & Productivity Software

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

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)

If you need more help, please ask.

Posted on Sep 15, 2008

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

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

You've got some parenthesis in the wrong place. Try this:

=(86.01*(Log10(B2-B3)))-(70.041*(Log10(B4)))+36.76

=(86.01*(Log10(B2-B3)))-(70.041*(Log10(B4)))+36.76

Apr 06, 2009 | Microsoft Office Excel 2003 for PC

www.google.com

Jan 14, 2009 | Microsoft Office Excel 2003 for PC

www.youtube.com/watch?v=xOU_hL2_zBo

i havent watched it, but i think it might help. hope it helps, enjoy

i havent watched it, but i think it might help. hope it helps, enjoy

Nov 16, 2008 | Microsoft EXCEL 2004 for Mac

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

Loringh

Loringh

Nov 12, 2008 | Microsoft Excel for PC

I found some excellent links to excel formulas for you:

This link lists excel formulas by category:

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

This link has some custom formulas for excel that you can download:

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

This link lists excel formulas by category:

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

This link has some custom formulas for excel that you can download:

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

Sep 20, 2008 | Microsoft Business & Productivity Software

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

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

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.

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

hiiiiiii

u know vlookup function,then piviot table

u know na tell short formula

genious...

u know vlookup function,then piviot table

u know na tell short formula

genious...

Dec 14, 2007 | Microsoft Excel for PC

Nov 29, 2016 | Toshiba Business & Productivity Software

695 people viewed this question

Usually answered in minutes!

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

how do you create a formula for wages earn by commision

×