How to calculate per hour salary in Excel

The basic pay is usually 40% of gross income or 50% of an individual’s CTC. Basic salary = Gross pay- total allowances (medical insurance, HRA, DA, conveyance, etc.)

In order to calculate an hourly rate based upon your monthly salary, multiply your monthly figure by 12 and then divide it by the number of hours you work per week . Divide this resulting figure by the number of paid weeks you work each year to get your hourly rate.