Calculate your effective weighted hourly rate across multiple jobs, shifts, or pay rates. Track overtime premiums, shift differentials, total earnings, and project annual income instantly.
A weighted hourly rate is your effective average pay per hour when you work at different rates across multiple jobs, shifts, or clients. It accounts for how many hours you spend at each rate, giving you the true per-hour value of your time.
If you earn $28/hr for 32 hours and $55/hr for 5 hours, your weighted rate isn’t just ($28+$55)/2 = $41.50. It’s actually (28×32 + 55×5) / 37 = $31.65/hr — because you spend far more time at the lower rate.
Identify every hourly rate you earn — base pay, overtime rates, weekend premiums, freelance client rates.
Mark overtime hours with 1.5× or 2.0× multipliers. Regular hours use 1.0× (no premium).
Track how many hours per week you work at each rate. Accuracy here determines result quality.
For each entry: Rate × Multiplier × Hours = weekly earnings from that source.
Total earnings ÷ Total hours = Your weighted effective hourly rate.
Federal FLSA requires 1.5× pay for hours over 40/week for non-exempt employees. If base rate is $28/hr, overtime rate is $42/hr. This increases your weighted average above $28.
Some employers and union contracts pay 2.0× for holidays, 7th consecutive day, or hours beyond a daily threshold. A $28 base becomes $56/hr for double-time hours.
Night shift, weekend, and holiday differentials add a premium to base pay. Common differentials: $2–$5/hr for nights, $3–$8/hr for weekends, percentage-based for holidays.
A blended rate combines multiple pay rates into a single composite rate. It’s commonly used in consulting, legal billing, and staffing where team members at different rates work on the same project.
Your effective hourly rate is what you actually earn per hour after accounting for all rate variations. If you earn $1,540 for 50 hours of work, your effective rate is $30.80/hr regardless of how many different rates you worked at.
People holding 2+ jobs need to know their true per-hour earnings across all positions to evaluate which job provides the best return on their time.
Freelancers with different client rates use weighted hourly rate to understand their overall earning efficiency and set minimum acceptable project rates.
Nurses, factory workers, and service employees with rotating shifts need weighted rates to understand true compensation including night/weekend differentials.
Employers calculate blended rates for FLSA overtime compliance, project labor costing, and workforce budget planning across multi-rate employees.
Consulting and legal firms calculate blended billing rates for client proposals when teams include partners, associates, and analysts at different rates.
Staffing agencies compute blended rates for contract pricing, margin analysis, and rate negotiations when assigning workers across different client sites.
Column A: Hourly rates
Column B: Multiplier (1, 1.5, or 2)
Column C: Hours worked
Column D: Earnings (=A2*B2*C2)
Effective Rate: =SUMPRODUCT(A2:A10*B2:B10*C2:C10)/SUM(C2:C10)
Same formula works in Google Sheets. Add conditional formatting to highlight overtime rows for quick visual identification.
Averaging $28/hr and $55/hr gives $41.50, but if you work 32 hours at $28 and only 5 at $55, your effective rate is $31.65. Hours matter more than rates.
Entering overtime hours at base rate instead of 1.5× understates your effective rate. Always apply the correct multiplier for premium hours.
Combining weekly hours from one job with monthly hours from another produces nonsensical results. Use the same time period (typically weekly) for all entries.
Commute time, unpaid breaks, and admin time reduce your effective rate. Consider including total time committed (not just paid hours) for a realistic picture.
Your effective average pay per hour when working at multiple rates. It weights each rate by hours worked for an accurate per-hour value.
Multiply each rate by its multiplier and hours, sum all earnings, divide by total hours. Effective Rate = Σ(Rate × Multiplier × Hours) ÷ Σ(Hours).
Another term for weighted average hourly rate — it blends multiple pay rates into one effective rate based on hours worked at each.
Overtime at 1.5× or 2.0× raises your effective rate above the base. More overtime hours = higher weighted average.
Extra pay for working nights, weekends, or holidays — typically $2–$8/hr or a percentage premium on the base rate.
Yes. Enter each job's rate and weekly hours to find your combined effective hourly rate across all positions.
Total earnings divided by total hours. It accounts for all rate variations and shows what you actually earn per hour on average.
Weighted rate × total weekly hours × 52 weeks. This calculator shows the projection automatically in the results panel.
Yes — for FLSA compliance, labor costing, project budgeting, and determining blended billing rates for consulting teams.
=SUMPRODUCT(RateRange*MultiplierRange*HoursRange) / SUM(HoursRange). Three columns for rates, multipliers, and hours.
Base rate is standard hourly pay. Effective rate includes overtime, differentials, and multi-rate variations — your actual per-hour earnings.
Absolutely. Enter each client's rate and hours to find your overall effective rate across all engagements.
No. This calculates gross (pre-tax) weighted hourly rate. Subtract applicable taxes for your net effective rate.
Specialized purpose-built weighted average calculators — each tailored to a specific domain with unique inputs, outputs, and interactive visualizations.