Duration.Hours

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

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

Syntax

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

Description

Returns the hours portion of duration.

Examples

Extract the hours from a duration value.

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

Related functions

Other functions related to Duration.Hours are:

• Duration.Days
• Duration.Minutes
• Duration.Seconds

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