Duration.TotalHours

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

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

Syntax

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

Description

Returns the total hours spanned by duration.

Examples

Find the total hours spanned by a duration value.

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

Related functions

Other functions related to Duration.TotalHours are:

• Duration.TotalDays
• Duration.TotalMinutes
• Duration.TotalSeconds

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/duration-totalhours
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.