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 |
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 |
All times are GMT +1. The time now is 10:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com