Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate an hourly rate in Excel and Google Sheets
Topic:Finance basicsExcel & Google Sheets
=A2/(B2*C2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Annual Salary | Hours/Week | Weeks/Year | Hourly Rate |
| 52000 | 40 | 52 | |
| 75000 | 40 | 52 | |
| 36000 | 30 | 52 | |
| 100000 | 45 | 50 |
=A2/(B2*C2)→25
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Set up three columns: Annual Salary (A), Hours per Week (B), and Weeks per Year (C, typically 52).
- 2In the Hourly Rate column, enter =A2/(B2*C2). This divides the annual salary by the total annual hours worked.
- 3Format the result as Currency. For example, a $52,000 salary at 40 hours/week × 52 weeks = $25.00/hour.
Tips
- To go the other direction — annual salary from hourly rate — multiply: =A2*B2*C2 where A2 is the hourly rate.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Should I include vacation time when calculating hourly rate?
For a true effective rate, subtract paid time off from weeks worked (e.g., use 50 weeks if 2 weeks are vacation), giving a higher hourly rate.
How do I account for overtime in my hourly rate calculation?
Add overtime hours separately and multiply by 1.5x the base rate, then divide the total annual pay by total hours (regular + overtime).
More on Finance basics
See all →How-to
How to calculate compound interest
Calculate a compounded closing balance from principal, annual nominal rate, compounding frequency and years, then separate the interest earned.
How-toHow to calculate the effective annual interest rate
Convert a positive nominal annual rate and a whole-number compounding frequency into an effective annual rate with EFFECT.
How-toHow to calculate the break-even point in units
Divide fixed costs by unit contribution margin and round up to whole units, with an explicit message when the margin is nonpositive.
How-toHow to calculate tiered commission
Apply different commission rates by sales tier using IFS. Works in Excel 2019/365 and Google Sheets.
How-toHow to calculate net pay
Calculate take-home (net) pay by subtracting every deduction from gross salary, with worked examples for fixed amounts, percentage tax, and slab-based tax. Excel and Google Sheets.
How-toHow to calculate gross margin
Compute gross margin percentage as (price − cost) / price. Identical in Excel and Google Sheets.