calworkhours() Function

Function

calworkhours( start_datetime, end_datetime, calendar_name )

This returns the actual number of work hours between two given Date and Times (both inclusive), according to the calendar defined for the system.

Parameters

Keyword Type Description

start\_datetime

Date and Time

The starting Date and Time.

end\_datetime

Date and Time

The ending Date and Time.

calendar\_name

Text

This optional parameter accepts the name of a system calendar; otherwise, the default calendar is used.

Returns

Integer

Usage considerations

Passing a calendar name allows you to calculate working hours using an alternate system calendar, if you have multiple calendars configured.

See also: Process Calendar Settings

Examples

You can experiment with this function in the test box below.

Test Input

calworkhours(datetime(2011,12,20,12,0,0),datetime(2011,12,21,12,0,0)) returns 8

Open in Github Built: Mon, Nov 29, 2021 (03:22:58 PM)

On This Page

FEEDBACK