Skip to main content
A Duration stores elapsed time, not a clock time. Constructors such as Hours create durations; converters such as ToHours return numbers.

​
Abs

Returns the non-negative magnitude of a number or duration.
  • Syntax: Abs(value)
  • Requires: a Numeric or Duration value.
  • Returns: the same type as the input.
  • Best for: unsigned differences and normalising reversed intervals.

​
Days

Creates a duration from a number of days.
  • Syntax: Days(number)
  • Requires: a Numeric value; fractions and negative values are allowed.
  • Returns: Duration.
  • Best for: service windows and adding days as elapsed time.

​
Hours

Creates a duration from a number of hours.
  • Syntax: Hours(number)
  • Requires: a Numeric value; fractions and negative values are allowed.
  • Returns: Duration.
  • Best for: labour, travel, and operating-time calculations.

​
Minutes

Creates a duration from a number of minutes.
  • Syntax: Minutes(number)
  • Requires: a Numeric value; fractions and negative values are allowed.
  • Returns: Duration.
  • Best for: appointment lengths and short service windows.

​
Mod

Returns the mathematical modulus after division.
  • Syntax: Mod(dividend, divisor)
  • Requires: two Numeric values or two Duration values. The divisor cannot be zero; do not mix numbers and durations.
  • Returns: Numeric or Duration, matching the inputs.
  • Best for: repeating cycles where a non-negative result is wanted with a positive divisor.
The non-zero result follows the sign of the divisor. This differs from Rem for some negative inputs.

​
Rem

Returns the remainder after division.
  • Syntax: Rem(dividend, divisor)
  • Requires: two Numeric values or two Duration values. The divisor cannot be zero; do not mix numbers and durations.
  • Returns: Numeric or Duration, matching the inputs.
  • Best for: direct remainder calculations that preserve the dividend’s direction.
The non-zero result follows the sign of the dividend.

​
Seconds

Creates a duration from a number of seconds.
  • Syntax: Seconds(number)
  • Requires: a Numeric value; fractions and negative values are allowed.
  • Returns: Duration.
  • Best for: precise integration delays and elapsed measurements.

​
ToDays

Converts a duration to its total number of days.
  • Syntax: ToDays(duration)
  • Requires: a Duration value.
  • Returns: Numeric, including any fractional day.
  • Best for: reports and comparisons expressed in days.

​
ToHours

Converts a duration to its total number of hours.
  • Syntax: ToHours(duration)
  • Requires: a Duration value.
  • Returns: Numeric, including any fractional hour.
  • Best for: timesheets and labour totals.

​
ToMinutes

Converts a duration to its total number of minutes.
  • Syntax: ToMinutes(duration)
  • Requires: a Duration value.
  • Returns: Numeric, including any fractional minute.
  • Best for: service-time and appointment reports.

​
ToSeconds

Converts a duration to its total number of seconds.
  • Syntax: ToSeconds(duration)
  • Requires: a Duration value.
  • Returns: Numeric, including any fractional second.
  • Best for: precise integrations and measurement exports.

​
ToWeeks

Converts a duration to its total number of seven-day weeks.
  • Syntax: ToWeeks(duration)
  • Requires: a Duration value.
  • Returns: Numeric, including any fractional week.
  • Best for: long service windows and age summaries.

​
Weeks

Creates a duration from a number of seven-day weeks.
  • Syntax: Weeks(number)
  • Requires: a Numeric value; fractions and negative values are allowed.
  • Returns: Duration.
  • Best for: long validity periods and elapsed-time rules.
Days(1) always means 24 elapsed hours. Use date functions such as AdjustMonth or Workday for calendar-aware movement.
Last modified on September 7, 2026