WorkHours function

WORKHOURS() Description

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

This feature is a powerful timekeeping tool that will make your spreadsheet work easier and help you use your time more efficiently. Use it to quickly and accurately determine the working hours on your project!

Main Features WORKHOURS Functions

Syntax:

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

Parameters:

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

Example Usage

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

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

We will have the following result:

This example uses the following values:

• StartDate: A8 - the starting date of the period.
• EndDate: B8 - end date of the period.
• StartTime: C8 - the beginning 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 that, this function will be available in all files that are opened in Excel (LibreOffice Calc) .