How to convert an hourly rate to an annual salary
✓ Verified in LibreOffice 25.8.7.3The 2,080 rule — hourly pay to yearly pay and back.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =A2*40*52 | A2=hourly rate, full-time 40h weeks. Reverse: =B2/2080 for hourly from salary. |
| Google Sheets | =A2*40*52 | Identical. |
| LibreOffice Calc | =A2*40*52 | Identical. |
How it works
Full-time is 40 hours × 52 weeks = 2,080 hours a year, so $25/hour ≈ $52,000 — and the handy mental shortcut is that hourly × 2 ≈ salary in thousands. Adjust the constants for reality: unpaid vacation shrinks the 52, part-time shrinks the 40, and =A2*H2*W2 with hours and weeks in cells makes the assumptions visible instead of buried. This is gross pay — taxes and benefits are a different spreadsheet.
Verified, not just documented
We ran =A2*40*52 in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 52000 — exactly the expected result. Every formula here is confirmed by actually executing it.