Duration.Seconds Function of Power Query
The Duration.Seconds function in Power Query, returns the seconds portion of a duration.
Syntax
Duration.Seconds(duration as nullable duration) as nullable number
• duration: The input, which must be a duration type (e.g., created with #duration(days, hours, minutes, seconds)).
Returns: It returns an integer number specifies the number of seconds from the duration.
Example: Extract the seconds from a duration value.
Power Query M
let
source = Duration.Seconds(#duration(1, 2, 30, 10))
in
source The output of the above code is 10.