# Calculate the Work Hours Between Two Dates In Google Sheets

Google Sheets is a powerful spreadsheet application that you can use to track a variety of data, including work hours between two dates. To calculate the number of work hours between two days in Google Sheets, you can use the following steps.

## Steps to Calculate Hours

For this example, we will use the following inputs.

• `start_date`: March 1, 2023
• `end_date`: May 23, 2023
• `holidays`: April 7, 2023
• `work_hours_per_day`: 8

Make of copy of the example spreadsheet and change any of the inputs to fit your situation.

First, find the number of workdays less any holidays. The NETWORKDAYS function is the perfect fit for this.

Syntax: `=NETWORKDAYS(start_date, end_date, holidays)`

Using a start_date of `3/1/2023` and an end_date of `5/23/2023`, the formula counts 60 workdays. Then, the formula subtracts `4/7/2023` for Good Friday, leaving 59 workdays. Now that we have the number of work days, let’s convert the work days to work hours.

### Multiply by Work Hours Per Day

Now that you have the number of workdays, multiply that number by the number of work hours in each work day.

Syntax: `=NETWORKDAYS(start_date, end_date, holidays) * work_hours_per_day`

This formula multiplies the 59 days we found in the previous step by `8` work hours per day. This multiplication results in 472 work hours between `3/1/2023` and `5/23/2023`.