Duration Functions Overview

Delve into Duration Functions in Power Query M Language, essential when working with duration data. This page provides a comprehensive list and descriptions of Duration Functions available in the M Language.

Component Functions

Function	Description
Duration.Days	Returns the days portion of a duration.
Duration.Hours	Returns the hours portion of a duration.
Duration.Minutes	Returns the minutes portion of a duration.
Duration.Seconds	Returns the seconds portion of a duration.

Creation and Conversion Functions

Function	Description
#duration	Creates a duration value from numbers representing days, hours, minutes, and (fractional) seconds.
Duration.From	Creates a duration from the given value.
Duration.FromText	Returns a duration value from textual elapsed time forms (d.h:m:s).
Duration.ToRecord	Returns a record containing the parts of the duration.
Duration.ToText	Returns the text of the form “d.h:m:s”.

Extraction Functions

Function	Description
Duration.TotalDays	Returns the total days this duration spans.
Duration.TotalHours	Returns the total hours this duration spans.
Duration.TotalMinutes	Returns the total minutes this duration spans.
Duration.TotalSeconds	Returns the total seconds this duration spans.

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/duration-functions