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