Power Query
published
Search
⌃K

Duration.FromText

Duration.FromText

Returns a duration value from textual elapsed time forms (d.h:m:s).
function (optional text as nullable any) as nullable any

Description

Returns a duration value from the specified text, text. The following formats can be parsed by this function:
<br>
(All ranges are inclusive)<br>
ddd: Number of days.<br>
hh: Number of hours, between 0 and 23.<br>
mm: Number of minutes, between 0 and 59.<br>
ss: Number of seconds, between 0 and 59.<br>
ff: Fraction of seconds, between 0 and 9999999.

Category

Duration

Examples

Convert "2.05:55:20" into a duration value.
Duration.FromText("2.05:55:20")

duration(2, 5, 55, 20)