WorkHours Function

WORKHOURS() Description

The WORKHOURS() function is designed to count the number of working hours between two specified dates, taking into account the working day period and specified holiday dates.

This function is a powerful tool for calculating working hours that will facilitate your work with tables and help you use your time more efficiently. Use it for quick and accurate determination of working hours in your project!

Main Characteristics of the WORKHOURS Function

Syntax:

=WORKHOURS(StartDate; EndDate; StartTime; EndTime; [Weekend]; [Holidays]; [WorkingDaysOff])

Parameters:

• StartDate: Cell with the start date of work.
• EndDate: Cell with the end date of work.
• StartTime: Cell with the start time of the working day.
• EndTime: Cell with the end time of the working day.
• [Weekend]: Optional. A list of day numbers for standard weekend days in text format (for example, if weekends are Friday and Saturday, then "5,6" is specified. By default, Saturday and Sunday are used as weekend days, i.e., the value "6,7". If "-1" is specified, all days will be working days.
• [Holidays]: Optional. A reference to a range with holiday dates that are considered weekends, in addition to the weekend days specified in the previous parameter.
• [WorkingDaysOff]: Optional. A reference to a range with dates that are exceptions to weekends (for example, rescheduling of working days due to holidays).

Example of Use

Suppose you have a table with start and end dates of the calculation period (for example, the beginning and end of the week, month, quarter, year, etc.), as well as other necessary parameters. You just need to enter the WORKHOURS formula, and Excel (Calc) will automatically calculate the number of working hours:

=WORKHOURS(StartDate; EndDate; StartTime; EndTime; Weekend; Holidays; WorkingDaysOff)

We will get the following result:

In this example, the following values are used:

• StartDate: A8 - start date of the period.
• EndDate: B8 - end date of the period.
• StartTime: C8 - start of the working day.
• EndTime: D8 - end of the working day.
• Weekend: B1 - days of the week that are considered weekends.
• Holidays: B2:B3 - list of holidays.
• WorkingDaysOff: B4:B5 - list of additional working days.

Download extension

You can use the function WORKHOURS() by installing the extension YLC Utilities.

After this, this function will be available in all files that will be opened in Excel (LibreOffice Calc).