Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Duration.Days
Duration.From
Duration.FromText
Duration.Hours
Duration.Minutes
Duration.Seconds
Duration.ToRecord
Duration.TotalDays
Duration.TotalHours
Duration.TotalMinutes
Duration.TotalSeconds
Duration.ToText
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
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)

Previous
Duration.From
Next
Duration.Hours
Last modified 3yr ago
Copy link
Outline
Duration.FromText
Description
Category
Examples