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.

Work Hours Calculator








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.

Month

Federal Holidays

Holiday Dates

Working Hours

January

New Year’s MLK, Jr.

Mon, Jan 2

Mon, Jan 16

128

February

President's

Mon, Feb 20

120

March

144

April

128

May

Memorial

Mon, May 29

144

June

Juneteenth

Mon, Jun 19

128

July

Independence

Tue, Jul 04

128

August

152

September

Labor

Mon, Sep 4

120

October

Columbus

Mon, Oct 9

136

November

Veterans Thanksgiving

Fri, Nov 10

Thu, Nov 23

136

December

Christmas

Mon, Dec 25

120

Total

11

1,584

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

2023 Work Hours By Month (Graph)

Here are the monthly work hours for the full year.

How many work hours per month

⬇️ Download this image

Other Work Time Calculators

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

Articles To Help You Calculator Work Periods

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

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

Work Schedule Articles

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

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).

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *