#query {background: #ebf5fd; color: #4f4f4f; letter-spacing: 1px; padding: 5px; border: 1px #001b31 solid; text-indent: 3%; font-size: small;} form#search_query { color: #FDFCFB; text-align: left; margin: 0px; }
Can any body help me regrding the calculation of salry in excel sheet.
I am working in HR & processing salary in excel sheet.
I am having doudts as follows.
1. How can we calculate salary in a month where 30 days is to pay. eg: Salary Rs.10000/30 X Number for days worked = salary payable.
As per the above case Loss of pay can be calculated as, per day salary X number of LOP (Salary /30*number of LOPdays=Net salary)
2.What will be in a month where 31 days is to pay : whether it is eg: 10000/31 X Number of days worked = salary paybale.
If Loss of pay is there , whether it is 10000/31 = per day salary ( normally per day salary is calculated by considering 30days.) .
If it is that case, per day salary, deduction of salary may be vary & Total salary may be less -
Can any body help me out with the correct method of calculation
Raju
7th June 2010 From India, Ernakulam
HIii... Rajesh,, I just give small example..Think per month salary is1000,Toget one day salary 1000*12/365=x.X is the one day salary...
7th June 2010 From India, Bangalore
hi..
can be done..first check if the month is for 28,29,30 or 31 days..
can be done using if statement.
then simply apply the formula..
got it!!!!!!!!!!!!1
or u want detailed solution...
regards
rashmi
7th June 2010 From India, Hyderabad
HI
AM IN IT COMPANY. I WANT TO KNOW HOW MANY DAYS WE WANT TO CONSIDER FOR SALARY. WHETHER 30/31 OR 26(EXCLUDING 4 SUNDAYS) OR 22 (EXCL SAT & SUN).DAYS. FOR EX. mr.A getting salary for Rs.15000 for dec 2010.
for this how we calculate and any1 can send me some excel formats to my mail id
28th December 2010 From India, Hyderabad
Hi Rajesh,
I am an HR Freelancer, Call me on 9820233738. Can help you with all necessary format, to make your work easy on best cost possible.
My Profile is as below:
Job Profile:
 Organizational Design And Structuring
 HR Development (Planning, Communication, And Analyzing)
 Job Profiling, Manpower Planning, Recruitment And Hiring
 Workforce Analysis
 Compensation, Rewards, And Benefits Management
 Time Office Attendance & Leave Records Management
 Payroll Management, CTC, Bonus, Leave Encashment, Full And Final And TDS Calculation.
 Creating HR & Administrative Policy, Organization & System Designed.
 Guide To Create Positive Work Environment To Achieve Organizational Vision.
 MIS Management & Analyzes
 KRA & Goal Setting
 PMS Management
 Statutory Compliances
 Resume Writing
 PPT Presentations
28th December 2010 From India, Mumbai
my salary was rs.8500, in our company my salary is normally calculated for 26 days, if there is month of 27 days of working period, how can i calculate my salary amount. regards mahi
8th January 2011 From India, Coimbatore
in the initial steps convert the gross salary into earned salary
form earned salary to break up which includes basic, da and othere allowances
if any lop exists salary varies from gross to earned
make the statutory deductions from earned salary
some times you may consider gross salary for some statutory deductions. so, be cautious.
be versed with excel formulas like if statement.
8th January 2011 From India, Warangal

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)