Duration.Seconds

This function extracts the seconds component from a duration.

Syntax

Duration.Seconds(duration as nullable duration) as nullable number

About

This function extracts the seconds component from a duration.

Explanation

To obtain the number of seconds from a duration value, you can use the Power Query MDuration.Seconds function with the syntax MDuration.Seconds(#duration(hours, minutes, seconds, milliseconds)). For example, when using the function with a duration value of 5 hours, 4 minutes, 3 seconds, and 2 milliseconds, the output will be 2 seconds.