Syntax Duration.ToText(duration as nullable duration, optional format as nullable text) as nullable text Description Returns a textual representation in the form “day.hour:mins:sec” of the given duration value, duration. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.ToText
Syntax Duration.Days(duration as nullable duration) as nullable number Description Returns the day component of the provided duration value, duration. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.Days
Syntax Duration.ToRecord(duration as duration) as record Description Returns a record containing the parts the duration value, duration. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.ToRecord
Syntax Duration.Minutes(duration as nullable duration) as nullable number Description Returns the minutes component of the provided duration value, duration. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.Minutes
Syntax Duration.Seconds(duration as nullable duration) as nullable number Description Returns the seconds component of the provided duration value, duration. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.Seconds
Syntax Duration.Hours(duration as nullable duration) as nullable number Description Returns the hour component of the provided duration value, duration. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.Hours
Syntax Duration.TotalMinutes(duration as nullable duration) as nullable number Description Returns the total minutes spanned by the provided duration value, duration. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.TotalMinutes
Syntax Duration.FromText(text as nullable text) as nullable duration Description Returns a duration value from the specified text, text. The following formats can be parsed by this function: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Duration Functions / Duration.FromText
Syntax DateTimeZone.ZoneMinutes(dateTimeZone as nullable datetimezone) as nullable number Description Changes the timezone of the value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTimeZone Functions / DateTimeZone.ZoneMinutes
Syntax DateTimeZone.ToRecord(dateTimeZone as datetimezone) as record Description Returns a record containing the parts of the given datetimezone value, dateTimeZone. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / DateTimeZone Functions / DateTimeZone.ToRecord