Functions by Category

Duration Functions

Functions for working with time duration values.

Duration.Days
Returns the whole days component from a duration value.
Duration.From
Converts a value to a duration.
Duration.FromText
Converts a text representation to a duration value.
Duration.Hours
Returns the hours component from a duration value.
Duration.Minutes
Returns the minutes component from a duration value.
Duration.Seconds
Returns the seconds component from a duration value.
Duration.ToRecord
Returns a record with Days, Hours, Minutes, and Seconds fields from a duration value.
Duration.TotalDays
Returns the total number of days represented by a duration value.
Duration.TotalHours
Returns the total duration expressed as a fractional number of hours.
Duration.TotalMinutes
Returns the total duration expressed as a fractional number of minutes.
Duration.TotalSeconds
Returns the total number of seconds represented by a duration value.
Duration.ToText
Converts a duration value to its text representation.
#duration
Creates a duration value from days, hours, minutes, and seconds components.