| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Payroll analysis
Im trying to take a column of hours and figure the total net pay for a week, the problem is I need to seperate straight time from overtime. So say I have 54 hours I need to figure 40hrs @8.50 an hour and 14hrs @12.75 an hour. What type of formula can I use to accomplish this. -- Dillion23 ------------------------------------------------------------------------ Dillion23's Profile: http://www.excelforum.com/member.php...o&userid=28530 View this thread: http://www.excelforum.com/showthread...hreadid=481840 |
|
#2
|
|||
|
|||
|
Payroll analysis
If hours worked are in A1 and Rate is in B1 then: C1: =MIN(A1,40)*B1+MAX(A1-40,0)*1.5*B1 Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=481840 |
|
#3
|
|||
|
|||
|
Payroll analysis
Use IF formula for your calculation. For example if time is in cell A1, use
formula: =IF(A1<=40, A1*8.5, 40*8.5+(A1-40)*12.75) "Dillion23" wrote in message ... Im trying to take a column of hours and figure the total net pay for a week, the problem is I need to seperate straight time from overtime. So say I have 54 hours I need to figure 40hrs @8.50 an hour and 14hrs @12.75 an hour. What type of formula can I use to accomplish this. -- Dillion23 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does the Data Analysis Toolbar Disappear | Excel Discussion (Misc queries) | |||
| data analysis option not visible | Excel Worksheet Functions | |||
| Recalculating a Regression Output in Data Analysis | Excel Worksheet Functions | |||
| Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
| Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
Linear Mode
