Duration.Seconds

Updated on

Duration.Seconds is a Power Query M function that extracts the seconds portion of a duration value. The function returns an integer representing the number of seconds.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

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

Description

Duration.Seconds returns the seconds portion (0-59) of the specified duration duration.

Examples

Extract the seconds from a duration value.

// Output: 2
Duration.Seconds( #duration( 5, 4, 3, 2 ) )

Other functions related to Duration.Seconds are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/duration-seconds