Skip to content
The title slide and first slides of the Hourly to Annual Pay Converter template

Hourly to Annual Pay Converter

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Modern
Difficulty
Beginner
Updated
November 16, 2026

Every slide (4)

Overview

Job ads quote an hourly wage, rent is due monthly and a mortgage lender asks for yearly income. This hourly to annual pay converter bridges them. Type an hourly rate, the hours you work in a week and the paid weeks in a year, and the Inputs tab shows weekly, biweekly, monthly and yearly pay at once. The Table tab repeats the sums for fourteen different weekly hour counts from ten to sixty, which shows what a part-time schedule or extra hours would add.

The monthly figure divides the year by twelve rather than multiplying a week by four, which is why it comes out higher than four weeks of pay. If you take unpaid time off, lower the paid weeks below fifty-two. All amounts are before tax. Type over any hours figure in the left-hand column of Table to test a schedule that is not listed.

Useful for

  • Check what a posted hourly wage means per year
  • Compare a full-time offer with a part-time one
  • Estimate monthly income for a rental application

What's included

  • 3 tabs: Inputs, Table, How to use
  • Inputs: a table with 4 summary figures
  • Table: a table
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Inputs tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I convert an hourly wage to an annual salary?

Multiply the hourly rate by the hours you work each week, then by the number of paid weeks in the year. At $24.50 an hour for 40 hours over 52 weeks, that is $50,960 before tax.

How do I convert hourly pay to monthly pay?

Work out the yearly amount first, then divide by twelve. This is more accurate than multiplying a week by four because most months have a little more than four weeks.

Should I use 52 weeks to work out yearly pay?

Use 52 if you are paid every week of the year, including paid holidays and leave. If part of your time off is unpaid, lower the number of paid weeks.

  • #financial-calculator
  • #hourly-to-annual-pay-converter
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More financial calculator templates

See all 29

Also in Finance

All finance templates
Get this template

Preparing your template…