Formula Library
Income Formulas
Google Sheets formulas for converting salary between annual and hourly rates, calculating overtime, and estimating take-home pay.
Annual to Hourly Salary Converter
beginnerConvert between annual salary, monthly, weekly, and hourly pay rates using simple Google Sheets formulas and examples.
=annual_salary / 2080 Effective Tax Rate
beginnerCalculate the actual percentage of income that goes to taxes - often much lower than your marginal bracket.
=total_tax_paid / total_gross_income Overtime Pay Calculator
beginnerCalculate overtime earnings with the standard 1.5x rate, splitting regular and overtime hours in a Google Sheets formula.
=IF(hours>40, 40*rate + (hours-40)*rate*1.5, hours*rate) Take-Home Pay Calculator
intermediateEstimate your net pay after federal, state, and FICA taxes are deducted from gross income using Google Sheets formulas.
=gross_pay - federal_tax - state_tax - fica_tax - deductions