Power Query
Search…
Duration.ToRecord

Duration.ToRecord

Returns a record containing the parts of the duration.
function (duration as duration) as record

Description

Returns a record containing the parts the duration value, duration.

Category

Duration

Examples

Convert #duration(2, 5, 55, 20) into a record of its parts including days, hours, minutes and seconds if applicable.
1
Duration.ToRecord(#duration(2, 5, 55, 20))
Copied!
[Days = 2, Hours = 5, Minutes = 55, Seconds = 20]
Last modified 3yr ago