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	Input	Output
Duration.Days	Returns the days portion of a duration.	Duration	Number
Duration.Hours	Returns the hours portion of a duration.	Duration	Number
Duration.Minutes	Returns the minutes portion of a duration.	Duration	Number
Duration.Seconds	Returns the seconds portion of a duration.	Duration	Number

Creation and Conversion Functions

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

Extraction Functions

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

Last update: November 24, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/duration-functions
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.