Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PAYROLL CALCULATION
I am calculating a 40 hour week payroll and need to lets say take data from
E8 thru K8 and have them add in S8 but if it goes over 40 to show only 40 and the remainder in T8 whick would be overtime |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
PAYROLL CALCULATION
You can use the formulas I posted to your similar question over in
microsoft.public.excel.worksheet.functions as a basis for this (put the sum in for A1 in my first formula and use S8 in place of A1 for my second formula). For you future consideration regarding multi-posting... From a post by Jeff Johnson: "You have posted this question individually to multiple groups. This is called Multiposting and it's BAD. Replies made in one group will not be visible in the other groups, which may cause multiple people to respond to your question with the same answer because they didn't know someone else had already done it. This is a waste of time. If you MUST post your message to multiple groups, post a single message and select all the groups (or type their names manually in the Newsgroups field, separated by commas) in which you want it to be seen. This is called Crossposting and when used properly it is GOOD." Some additional comment previously posted by me: "You may not see this as a problem, but those of us who volunteer answering questions on newsgroups do see it as a problem. You can't imagine how annoying it is for a volunteer to read a question, research background material, test sample code and then formulate and post an answer to the original question only to go to another newsgroup and find the question posted and ALREADY answered over there. On top of that, if you cross-post your question, all of the readers in all the newsgroups it is cross-posted to see both the original question and all of the answers given to it. This is beneficial to you because then we can add additional material to, add clarification to, as well as add additional examples to an answer you have received previously... that means you end up with a more complete solution to your problem. This is a win-win situation for all of us." Rick "Bernie" wrote in message ... I am calculating a 40 hour week payroll and need to lets say take data from E8 thru K8 and have them add in S8 but if it goes over 40 to show only 40 and the remainder in T8 whick would be overtime |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
PAYROLL CALCULATION
In S8 =MIN(40, SUM(E8:K8)
In T8 =MAX(0, SUM(E8:K8)-40) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bernie" wrote in message ... I am calculating a 40 hour week payroll and need to lets say take data from E8 thru K8 and have them add in S8 but if it goes over 40 to show only 40 and the remainder in T8 whick would be overtime |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
PAYROLL CALCULATION
In S8 type in
=IF(Sum(E8:K8)<40,Sum(E8:K8),40) in T8 type =IF(Sum(E8:K8)40,Sum(e8:k8)-40,0) See if that works "Bernie" wrote: I am calculating a 40 hour week payroll and need to lets say take data from E8 thru K8 and have them add in S8 but if it goes over 40 to show only 40 and the remainder in T8 whick would be overtime |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
PAYROLL CALCULATION
Assuming your values are in NUMBER (or GENERAL) format: ( 8 not 8:00)
Try these: S8 = reg hours =MIN(SUM(E8:K8),40) T8 = OT hours =MAX(SUM(E8:K8)-40,0) -- Biff Microsoft Excel MVP "Bernie" wrote in message ... I am calculating a 40 hour week payroll and need to lets say take data from E8 thru K8 and have them add in S8 but if it goes over 40 to show only 40 and the remainder in T8 whick would be overtime |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Payroll calculation | Excel Worksheet Functions | |||
Payroll | Excel Discussion (Misc queries) | |||
Adding payroll stubs payroll calculator | New Users to Excel | |||
Payroll | New Users to Excel | |||
need spreadsheet for the calculation of FUTA & SUTA payroll taxes | Excel Discussion (Misc queries) |