Salary and Hourly Rate Converter

Who this is for

One pay figure, five ways. Enter your hours a week, paid weeks a year and days a week, then any pay figure with what it is per, and the sheet fills in the annual, monthly, weekly, daily and hourly equivalents. Put several offers or rates on the same sheet to compare them on the same basis.

Job seekers comparing an hourly rate with a salary, freelancers turning a day rate into an annual figure, and employees working out what a pay offer means per hour.

What this helps you track

• What a salary works out at per hour, day, week and month
• What an hourly or day rate adds up to over a year
• Several offers or rates set side by side on the same hours
• The highest annual and hourly figures among them
• The difference your own hours and weeks make to the result

How to use it

1. Enter the hours you work a week, the weeks a year you are paid for and the days you work a week.
2. Give each offer or rate a row, enter the figure and choose what it is per: year, month, week, day or hour.
3. The other four columns are worked out in the browser and the workbook; on paper, convert to annual first, then divide.
4. If two offers have different hours, use a separate sheet for each or compare them on the hourly column.
5. Read the summary for the highest annual and hourly figures, and remember these are before any deductions.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

How many weeks a year should I enter?

The weeks you are actually paid for. An employee with paid holiday is usually paid every week of the year; a freelancer is only paid for the weeks worked. The sheet uses whatever you enter and supplies no figure.

Is this before or after tax?

Before. Every figure is the gross equivalent of what you enter. For what you would take home, use the take-home pay worksheet with the deductions from your own payslip or estimate.

Why does a day rate look high next to a salary?

A day rate usually covers only the days worked, and someone on it may have no paid holiday, sick pay or pension. Entering the real paid weeks for each keeps the comparison fair.

How is monthly pay worked out?

Annual pay divided by twelve. Pay that arrives every four weeks gives thirteen payments a year, so each is a little smaller than the monthly figure shown.