Work Hours Calculator: Calculate Hours Worked Between Dates

Use this work hours calculator to calculate the number of working hours between two dates. With a few inputs to customize, you’ll be able to calculate hours worked for your specific schedule, job, or company.

Instructions For The Hours Worked Calculator

Follow these steps to customize the working hours calculator:

1. Start Date: Click the calendar icon on the right side of the field to enter the first day of the time period you’d like to calculate.
2. End Date: Click the calendar icon on the right side of the field to enter the last day of the time period you’d like to calculate. By default, hours on this day will be counted as work hours.
3. Hours in a Typical Work Day: Set the amount of work hours that occur each day by typing in the number or tapping up or down arrows on the right. The default is eight hours of work per day.
4. Work Days: Select the days of the week you work. The calculator defaults to a standard work week, but can be adjusted for a four-day work week, seven-day week or other alternative schedules.
5. Holidays: This is the list of the current US federal holidays given each year. If you select holidays, hours on those days will excluded from the total hours worked.
   • Select all holidays: Click this option to exclude every US federal holiday from the work hours calculation.
   • Individual holidays: Click individual listed holidays to exclude only those from the calculation.
6. Include End Date in Calculation: This gives you one last way to customize the calculator. It defaults to include the last day toward your hour count. Uncheck the box to remove the final day from the calculation.

Hit “Calculate.”

Scroll down to view the results in the green box below. You’ll also see how many work days and how many work weeks are in the time period.

Uses For The Work Hour Calculator

There are a number of reasons to calculate work hours between two dates:

Calculate your own schedule: Answer the question, “How many hours am I working?”

Calculate weekly time sheets: Quickly determine how many work hours, days, and weeks occurred during a certain time period for standard weekly work schedules.

Calculate business hours for days you are open: Adjust the days of the week your business is open (one to seven days per week) and the hours per day to calculate total business hours.

Prepare payroll: See the number of work hours that occur during a specific payroll period.

Invoice clients: Calculate the amount of billable work hours during a time period.

Adjust monthly reporting for output, efficiency: Give context to monthly results based on the number of work hours that occurred during a given month.

Related Resources For Calculating Work Hours

Want to skip the calculator part and go right to some of the popular answers? We’ve built out some other resources to help answer common questions about working hours in certain time periods.

Work Hours In 2023

Here are the number of work hours by month for an eight-hour, five-day week in 2023.

Get more common answers about the work days and hours by month in 2023. Or, get answers for upcoming years:

• 2024
• 2025

2023 Work Hours By Month (Graph)

Here are the monthly work hours for the full year.

⬇️ Download this image

Other Work Time Calculators

Here are a few other free calculators we’ve built:

• Work Days Calculator
• Work Week Calculator

Articles To Help You Calculator Work Periods

Here are some additional articles you might find useful to calculate business hours, days, and weeks:

• How Many Work Hours Are In A Year?
• How Many Work Days Are In A Year?
• How Many Work Weeks Are In A Year?

Or, find some articles on about full-time versus part-time hours and average hours worked by country:

• How Many Hours Is Part Time? [Breakdown By Country]
• Average Work Hours Per Week For Every Country

Work Schedule Articles

Here are some articles to help you build the ideal work schedule for your company:

• Work Schedule Template Library
• 7 Free, Customizable Staff Schedule Templates
• 6 Free Monthly Work Schedule Templates
• The Weekly Work Schedule Template Library: 12 Free Options

How To Calculate Hours Worked

Manually Calculate Work Hours (Formula)

To calculate your own work hours in a year, follow this formula:

First, calculate work days: Work days = Total days in a year – number of company holidays – weekend days

Then, calculate work hours: Work hours = Work days * number of hours per work day

Calculate Hours Worked In Google Sheets Or Excel

We have data on working days and hours for every year from 2023 – 2032. We created a spreadsheet to customize your calculations for each year.  

Use this spreadsheet template.

• If you’re logged into a Google/Gmail account, you can use the Google Sheets workbook by making a copy (File > Make a copy).
• Or, you can use it in Microsoft Excel by downloading it (File > Download > Microsoft Excel).

Once you have a copy of the workbook, here is how to calculate your own work hours per year. 

1. Open the “Work Hours Per Year” tab. 
2. Select the number of work hours your company performs per day (D2).
3. Update the “Federal Holidays” column (column D) to your number of paid company holidays per year.
4. The number of work hours per year will calculate automatically (column G).