LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
payroll calculation Bernie Excel Discussion (Misc queries) 4 February 29th 08 10:01 PM
PAYROLL CALCULATION Bernie Excel Discussion (Misc queries) 4 February 22nd 08 08:28 PM
Payroll calculation sgl Excel Worksheet Functions 2 May 14th 07 04:59 PM
Adding payroll stubs payroll calculator Sable New Users to Excel 2 August 5th 06 05:37 PM
need spreadsheet for the calculation of FUTA & SUTA payroll taxes [email protected] Excel Discussion (Misc queries) 0 December 22nd 05 08:53 PM


All times are GMT +1. The time now is 01:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"