Power Query
Search…
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:
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)