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.
| Function | Description |
|---|---|
| Duration.Days | Returns the day component of a Duration value. |
| Duration.From | Returns a duration value from a value. |
| Duration.FromText | Returns a Duration value from a text value. |
| Duration.Hours | Returns an hour component of a Duration value. |
| Duration.Minutes | Returns a minute component of a Duration value. |
| Duration.Seconds | Returns a second component of a Duration value. |
| Duration.ToRecord | Returns a record with parts of a Duration value. |
| Duration.TotalDays | Returns the total magnitude of days from a Duration value. |
| Duration.TotalHours | Returns the total magnitude of hours from a Duration value. |
| Duration.TotalMinutes | Returns the total magnitude of minutes from a Duration value. |
| Duration.TotalSeconds | Returns the total magnitude of seconds from a duration value. |
| Duration.ToText | Returns a text value from a Duration value. |
Show: