Duration functions

 

The Power Query Formula Language is a powerful query language optimized for building queries that mashup data. It's a functional, case sensitive language similar to F#, which can be used with Power Query in Excel, Get & Transform in Excel 2016, and Power BI Desktop. To learn more, see the PowerQueryName reference.

FunctionDescription
Duration.DaysReturns the day component of a Duration value.
Duration.FromReturns a duration value from a value.
Duration.FromTextReturns a Duration value from a text value.
Duration.HoursReturns an hour component of a Duration value.
Duration.MinutesReturns a minute component of a Duration value.
Duration.SecondsReturns a second component of a Duration value.
Duration.ToRecordReturns a record with parts of a Duration value.
Duration.TotalDaysReturns the total magnitude of days from a Duration value.
Duration.TotalHoursReturns the total magnitude of hours from a Duration value.
Duration.TotalMinutesReturns the total magnitude of minutes from a Duration value.
Duration.TotalSecondsReturns the total magnitude of seconds from a duration value.
Duration.ToTextReturns a text value from a Duration value.
Show: