T
Tia
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
If the employee worked less than 18 days i want to deduct from his
salary as if he worked 31 days wich means i will divide 1000:31=32$
per day
than i want to calculate the 32$per day * total worked days if the
emplpoyee didnt work the full 18 days
and i want him to take the full salary whenever he works 18 days as if
he worked 31
Example : An employee have worked 18 days from the whole month
he should get the whole 1000$ not 518
And if he worked 10 over 18 days from the whole month
1000/31=32
32*total working days 10=323
Z=Total salary with Deduction Amount = ?????????
Kindly help me
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
If the employee worked less than 18 days i want to deduct from his
salary as if he worked 31 days wich means i will divide 1000:31=32$
per day
than i want to calculate the 32$per day * total worked days if the
emplpoyee didnt work the full 18 days
and i want him to take the full salary whenever he works 18 days as if
he worked 31
Example : An employee have worked 18 days from the whole month
he should get the whole 1000$ not 518
And if he worked 10 over 18 days from the whole month
1000/31=32
32*total working days 10=323
Z=Total salary with Deduction Amount = ?????????
Kindly help me