Updated on

Duration.TotalSeconds is a Power Query M function that calculates the total seconds spanned by a duration value. The function returns a decimal number representing the total seconds.

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


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


Duration.TotalSeconds returns the total number of seconds (including fractional seconds) spanned by the duration duration.


Find the total seconds spanned by a duration value.

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

Other functions related to Duration.TotalSeconds are:

BI Gorilla Blog

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