Billable Hours, Shift Overtime & PTO Revenue Calculator
Edit your hourly rate, daily billable block, 1.5x overtime hours, and annual PTO/holiday days off below. Formulas recalculate weekly, monthly, and annual revenue instantly.
Click any bordered value cell to enter your own hourly rate, daily hours, or paid time off. Press ▶ Watch steps to trace how each formula builds the annual projection.
Powered by Arte Sheets live browser calculation engine — edits stay private in your browser. Open full spreadsheet in new tab ↗
More Free Cloud Calendars Calculators
Time-Zone Overlap Calculator
Find overlapping business hours across global cities.
Shift Rotation Generator
Generate 4-on-4-off, Pitman, DuPont, and 24/48 shift calendars.
Outdoor Event Weather Planner
Score outdoor event windows by precipitation and wind thresholds.
Frequently Asked Questions
How are active working weeks per year calculated?
A standard 5-day workweek calendar has 260 weekdays per year (52 weeks × 5 days). Subtracting your unpaid or non-billable PTO and public holidays and dividing by 5 gives your exact active billing weeks.
Can I customize formulas or add tax rows?
Yes. Click Open in Arte Sheets to launch your exact numbers in a full spreadsheet tab where you can add tax brackets, expenses, or export to .xlsx.