View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tia[_3_] Tia[_3_] is offline
external usenet poster
 
Posts: 79
Default Help Payroll calculation problem

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