salary calculation

  1. S

    Rate Calculation on basis of working hours

    Hello, I have an excel that contains total month wise time for each employee in columns. Total amount for each employee needs to be as calculated based on a slab. The slab is For 0-20 Hours: $8200 + $50 Per Hour For 21-40 Hours: $9200 + $60 Per Hour Now if a person has worked 38:55 Hours in...
  2. K

    Basic Salary Sheet

    Hi, My first post and I would request the esteemed members to provide me with a basic Salary Sheet in Excel for my salary calculation purposes. I run a Take-away, online ordering and delivery ******* and my basic requirements for salary calculations are:- 1) CTC 2) Number of days absent. (To...
    • kmital
    • Thread
    • net payable salary salary calculation salary sheet
    • Replies: 2
    • Forum: Excel Questions
  3. N

    Salary slip components

    I work in a small office in Pune with 11 employees I need to know the various components of a typical salary slip; with various percentages of basic salary. Eg If someone needs to have a take home salary of 20060.00; how would the salary slip look if basic salary is to be 50% of above?
  4. S

    Salary Sheet Problems

    I have my CSE-101 Exam ahead and all I know can do in MS Excel is simple summations and deductions. I would be really grateful if someone helps me out with my following problem. Consider the following payroll information of a company and write the formula asked. House Allowance: 40% of Basic...
    • shujon
    • Thread
    • house allowance medical allowance salary calculation salary sheet
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top