Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am working on payroll calculation
The package is divided always divided by 31 days Example 10,000:31=322.6 and the total hours per day is 322.6/9=35.84 $ per hour I have creating this program that give you every month total hours and total working days Nb Of Required Working Days / Month:=Program!B38=18 Nb Of Required Working hours / Month=Program!G38=147 Payroll : K18= Total Package =10,000 $ T 18= Required working days for january = 18 U 18= Nb of working days for january = 0 V18=Required working hours=147 hours W18= Total Working hours= 0 Z=Total Deduction Amount = ????????? If i used (Total Hours Per Day) 35.84* (Number of required working hours)147=5269.133333 What can i do to have the total amount of 10,000 to be deducted if the employee missed the whole working days Help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
payroll calculation | Excel Discussion (Misc queries) | |||
PAYROLL CALCULATION | Excel Discussion (Misc queries) | |||
Payroll calculation | Excel Worksheet Functions | |||
Adding payroll stubs payroll calculator | New Users to Excel | |||
need spreadsheet for the calculation of FUTA & SUTA payroll taxes | Excel Discussion (Misc queries) |