Power Query
Search…
Duration.FromText
Duration.FromText
Returns a duration value from textual elapsed time forms (d.h:m:s).
function (optionaltextas nullable any) as nullable any
Description
Returns a duration value from the specified text,
text. The following formats can be parsed by this function: 1
<br>
2
(All ranges are inclusive)<br>
3
ddd: Number of days.<br>
4
hh: Number of hours, between 0 and 23.<br>
5
mm: Number of minutes, between 0 and 59.<br>
6
ss: Number of seconds, between 0 and 59.<br>
7
ff: Fraction of seconds, between 0 and 9999999.
Copied!
Category
Duration
Examples
Convert
"2.05:55:20" into a duration value.1
Duration.FromText("2.05:55:20")
Copied!
duration(2, 5, 55, 20)
Last modified 3yr ago
Copy link