Duration.ToText

This function will provide a text format showing the duration value in the format "day.hour:mins:sec". The duration value provided will be used to calculate this text representation. The 'format' para...

Syntax

Duration.ToText(duration as nullable duration, optional format as nullable text) as nullable text

About

This function will provide a text format showing the duration value in the format "day.hour:mins:sec". The duration value provided will be used to calculate this text representation. The 'format' parameter is optional, but it is deprecated and will cause an error if not null.

Explanation

Transform the duration value of 2 hours, 5 minutes, 55 seconds, and 20 milliseconds into a text format using the Power Query MDuration.ToText function. The resulting text value will be "2.05:55:20"