| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
payroll calculations
I do payroll where I list hours per day I need a formula that when the hours
go over 40 that it will put 40 in one cell and the ammout of overtime in a cell below it. Also a formula that will look at other cells such as sick and vacation to be part of the 40 hour week equation |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
payroll calculations
You could use this for the hours up to 40...
=MIN(40,A1) and this for the excess... =IF(A140,A1-40,"") Rick "Bernie" wrote in message ... I do payroll where I list hours per day I need a formula that when the hours go over 40 that it will put 40 in one cell and the ammout of overtime in a cell below it. Also a formula that will look at other cells such as sick and vacation to be part of the 40 hour week equation |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need payroll | Excel Discussion (Misc queries) | |||
| how do i set up payroll | Excel Worksheet Functions | |||
| Payroll | Excel Discussion (Misc queries) | |||
| Adding payroll stubs payroll calculator | New Users to Excel | |||
| Payroll | Excel Discussion (Misc queries) | |||
Linear Mode
