LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dillion23
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does the Data Analysis Toolbar Disappear Vinnie Excel Discussion (Misc queries) 1 October 7th 05 07:04 PM
data analysis option not visible Alok Excel Worksheet Functions 2 September 22nd 05 07:50 AM
Recalculating a Regression Output in Data Analysis karin Excel Worksheet Functions 1 August 23rd 05 03:40 AM
Why " data analysis plus " override " data analysis " once instal. Alfred H K Yip Excel Worksheet Functions 1 March 20th 05 08:10 AM
Analysis ToolPak installed but no Data Analysis option Eric Stephens Excel Discussion (Misc queries) 3 February 2nd 05 09:17 PM


All times are GMT +1. The time now is 10:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"