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.ToText

Duration.ToText

Returns the text of the form "d.h:m:s".
function (optional duration as nullable any, optional format as nullable any) as nullable any

Description

Returns a textual representation in the form "day.hour:mins:sec" of the given duration value, duration. A text value that specifies the format can be provided as an optional second parameter, format.

Category

Duration

Examples

Convert #duration(2, 5, 55, 20) into a text value.
1
Duration.ToText(#duration(2, 5, 55, 20))
Copied!
"2.05:55:20"
Previous
Duration.TotalSeconds
Next
Error
Last modified 3yr ago
Copy link
Contents
Duration.ToText
Description
Category
Examples