Enter Pay and Hours
Example Data Table
| Role | Pay Basis | Rate / Salary | Total Hours | OT Multiplier | Premium/Hour | Stipend | Notes |
|---|---|---|---|---|---|---|---|
| Lab Technician | Hourly | $28.50 | 46 | 1.5 | $1.25 | $0 | Shift premium as separate line |
| Admissions Coordinator | Hourly | $22.00 | 41 | 1.5 | $0.00 | $75 | Weekend open-house stipend |
| IT On-Call Support | Annual salary | $60,000 | 44 | 1.5 | $2.00 | $0 | Convert salary to hourly for budgeting |
These rows are examples only. Enter your own values above to calculate.
Formula Used
- Base Hourly (salary) = Annual Salary ÷ (Weeks/Year × Standard Hours/Week)
- Regular Hours = min(Total Hours, Overtime Threshold)
- Overtime Hours = max(0, Total Hours − Overtime Threshold)
- Regular Pay = Regular Hours × Regular Rate
- Overtime Pay = Overtime Hours × Base Rate × Overtime Multiplier
- Premium Pay (add-on) = Premium/Hour × Total Hours
- Gross Pay = Regular Pay + Overtime Pay + Premium Pay + Stipend
- Net Pay (estimate) = Gross Pay − (Gross Pay × Withholding %)
Premium handling depends on local policy. Some institutions include premiums in the overtime base; others pay premiums as separate lines.
How to Use This Calculator
- Select Pay Type: hourly or annual salary conversion.
- Choose Hour Entry Mode: enter total hours or manual regular and overtime.
- Set your Overtime Threshold and OT Multiplier per policy.
- Add any Premium per Hour and select how it should be treated.
- Optionally include a Stipend and an estimated Withholding %.
- Click Calculate to see the summary above the form.
- Use Download CSV or Download PDF for reporting.
Typical Overtime Scenarios in Higher Education
Campus overtime often spikes around admissions cycles, residence-hall move-in, lab maintenance, athletics events, and end-of-term grading support. Many institutions use a 40-hour weekly threshold, but some units track alternative thresholds for nonstandard schedules. This calculator splits total hours into regular and overtime hours using your threshold, then applies an overtime multiplier such as 1.5× or 2.0× for holidays. For biweekly pay periods, repeat the estimate for each week logged.
Salary-to-Hourly Conversion for Budgeting
For exempt or salary-based budgeting, the tool converts annual salary to an hourly base rate: salary ÷ (weeks per year × standard hours per week). Example: $52,000 ÷ (52 × 40) = $25.00 per hour. If an academic staff appointment is 39 weeks or a reduced FTE, adjust weeks and standard hours to mirror the appointment letter and avoid overstating overtime costs. Match the workweek definition HR uses for overtime calculations.
Premium Handling and Shift Differentials
Higher education payroll frequently includes premiums—shift differentials, hazardous lab duties, lead worker pay, or temporary assignment pay. Premium handling matters because it can change the overtime base. Choose “Include in base rate” when the premium should raise both regular and overtime rates. Choose “Add as separate line” when the premium is paid per hour regardless of overtime. The calculator shows premium pay separately for easier reconciliation. If unsure, compare both scenarios with a recent payroll statement.
Grant and Auxiliary Funding Considerations
Department and grant managers can use gross pay estimates to forecast supplemental labor costs on restricted and auxiliary funds. Add a one-time stipend for commencement, weekend workshops, or emergency coverage, and optionally estimate withholding to approximate net take-home. Because overtime can trigger downstream costs, export the CSV for cost-center uploads or attach the PDF to approval packets and labor distribution reviews. Note that fringe and indirect charges may apply outside this estimate.
Audit-Ready Documentation and Exports
Strong documentation reduces audit friction. Save the inputs (rates, thresholds, premiums, and stipend) alongside timesheet evidence, then compare calculated totals to payroll registers. The CSV captures both inputs and results for spreadsheet checks, while the PDF provides a clean, single-page summary for supervisors. If your policy rounds hours or rates, align the inputs to your institution’s rounding rules before exporting. Store versions by pay period to support retro adjustments and internal inquiries.
FAQs
Which campus roles is this estimate best for?
Best for hourly or time-tracked staff: facilities, labs, IT support, events, and auxiliary services. Overtime eligibility for faculty, graduate assistants, and some research roles varies, so use this as a planning estimate and verify with HR.
How do I convert an annual salary to an hourly rate here?
Select annual salary, then enter weeks per year and standard hours per week. The calculator uses Salary ÷ (Weeks × Hours) to produce a base hourly rate that drives regular and overtime pay estimates.
What should I use for the overtime threshold?
Many payroll systems use 40 hours per workweek, but some institutions use different thresholds for specific schedules. Enter the threshold your policy defines for the workweek you are budgeting, not the pay-period total.
Premium handling: included or add-on?
Choose included when the premium should raise the base rate that overtime is calculated from. Choose add-on when the premium is paid separately per hour. If you are unsure, compare both with a recent pay statement.
Does the stipend change the overtime rate?
No. The stipend is added as a flat amount to gross pay, separate from hourly calculations. Use it for commencement coverage, weekend events, or one-time assignments, then apply withholding if you want a net estimate.
Can I export my results for approvals or audits?
Yes. Download CSV for spreadsheet checks, budget uploads, and cost-center review. Download PDF for a clean, single-page summary to attach to supervisor approvals or payroll documentation.