Hourly to Salary Calculator

Convert an hourly wage to weekly, monthly, and annual salary using hours per week and paid weeks per year, with the spreadsheet formulas.

Numbers stay in your browser. The default is $25 an hour at 40 hours a week for 52 weeks, which is $52,000 a year. This does not include overtime; use the time card calculator for that.

Quick answer: with the hourly rate in B2 and hours per week in C2, Excel and Google Sheets use:

=B2*C2*52
=B2*C2*52/12

The first is the annual salary for a 52-week year; the second is the monthly amount. Change 52 if some weeks are unpaid.

$25 an hour, 40 hours a week

Weekly pay is 25 × 40 = 1,000. A 52-week year is 1,000 × 52 = 52,000. In Google Sheets on 12 November 2026, =25*40*52 returned 52000. Dividing that annual figure gave a monthly salary of 4333.333333333333 (=B33/12), a biweekly paycheck of 2000 (=B33/26), and a semi-monthly paycheck of 2166.6666666666665 (=B33/24).

Biweekly and semi-monthly are easy to mix up. Twenty-six checks a year is every two weeks. Twenty-four checks a year is twice a month, usually on a fixed calendar date. The semi-monthly amount is a little higher than the biweekly one because you receive two fewer checks.

A second check: $30 an hour at 35 hours a week is =30*35*52, which returned 54600. If that person is unpaid for two weeks, use 50 instead of 52: 30 × 35 × 50 = 52,500.

What this leaves out

The formula is gross pay before tax, benefits, or employer costs. It also assumes the same hours every week. Overtime at time-and-a-half is not annualized here — use the time card calculator with overtime for a week of mixed hours, then multiply a typical week only if that week really is typical.

Salaried job posts sometimes quote a yearly figure that already includes or excludes a bonus. This page only converts a straight hourly rate. Going the other way, an annual salary divided by (hours per week × paid weeks) gives the equivalent hourly rate: 52,000 ÷ 2,080 = 25.

Questions that come up

How do I convert an hourly wage to an annual salary in Excel or Google Sheets?

With the hourly rate in B2 and hours per week in C2, use =B2*C2*52. At $25 an hour for 40 hours a week, that is 52,000 a year. Change 52 if you are not paid for a full calendar year of weeks.

How do I get a monthly or biweekly salary from an hourly rate?

Divide the annual figure by 12 for a monthly salary, or by 26 for a biweekly paycheck (26 paid periods in a year). A semi-monthly paycheck (the 15th and the last day of the month) is the annual figure divided by 24, which is not the same as biweekly.

Is 2,080 hours the same as 40 hours times 52 weeks?

Yes: 40 × 52 = 2,080 paid hours in a full year with no unpaid time off. If you only work 50 weeks, use 50 in the weeks box instead of 52.

Oscar

스프레드시트 수식과 오류 해결을 소개합니다. 검증 환경과 미확인 사항은 각 글을 참고하세요.

Tested in Google Sheets on 12 November 2026 (25 × 40 × 52 = 52000, monthly 4333.333333333333, biweekly 2000, semimonthly 2166.6666666666665, and 30 × 35 × 52 = 54600). The same arithmetic is standard in Excel 365; I did not re-run these cases in Excel this session.