---
title: "getWorkingInterval"
canonical: "https://support.appfire.com/space/PSJ/15483941/getWorkingInterval"
format: markdown
---
> Macro (aura-html)


|  |  |  |  |
| --- | --- | --- | --- |
| **Syntax** | getWorkingInterval(startDate, endDate, startWorkingHour, endWorkingHour, weekendDays, holidays) | **Package** |  |
| **Alias** |  | **Pkg Usage** |  |

## Description

> Macro (excerpt)
> 
> Returns the number of working hours from a time interval.

Returns the number of working hours from a time interval.

## Parameters

| Parameter name | Type | Required | Description |
| --- | --- | --- | --- |
| startDate | Date | Yes | Start working date. |
| endDate | Date | Yes | End working date. |
| startWorkingHour | String | Yes | Daily start working hour (HH:mm). |
| endWorkingHour | String | Yes | Daily end working hour (HH:mm). |
| weekendDays | Number array | Yes | Weekend days (day of week). |
| holidays | Date array | Yes | Dates of the free days. |

## Return Type

**Number**

The returned number represents the working hours from the given time interval.

## Example

```
number hours;
date startDate = "2012-01-10 12:00:00";
date endDate = "2012-01-20 10:30:00";
string startHour = "09:00";
string endHour = "17:00";
number[] weekend = {7, 1};
date[] holidays = {"2012-01-18", "2012-01-16"};

hours = getWorkingInterval(startDate, endDate, startHour, endHour, weekend, holidays);
```

Returns the number of working hours from 2012-01-10 12:00 to 2012-01-20 10:30, excluding the weekends (7 is Saturday and 1 is Sunday) and holidays (2012-01-18 and 2012-01-16).

## See also

> Macro (contentbylabel)