Duration.FromText is a Power Query M function that parses a text value and returns a duration value. The function returns a duration value based on the specified text format.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Duration.FromText( text as nullable text ) as nullable duration


Returns a duration value from the specified text, text. The following formats can be parsed by this function:

  • (-)hh:mm(:ss(.ff))
  • (-)ddd(.hh:mm(:ss(.ff)))

(All ranges are inclusive)
ddd: Number of days.
hh: Number of hours, between 0 and 23.
mm: Number of minutes, between 0 and 59.
ss: Number of seconds, between 0 and 59.
ff: Fraction of seconds, between 0 and 9999999.


Convert "2.05:55:20" into a duration value.

// Output: #duration( 2, 5, 55, 20 )
Duration.FromText( "2.05:55:20" )

Other functions related to Duration.FromText are:

BI Gorilla Youtube Channel

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