Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Format Hour

Please, I need help,
I need to calculate overtime of employees, and the field has values ​​with time format, but pbi does not accept negative hours or values  >= 24:00:00

MarcelBeug Community Champion
Community Champion

Re: Format Hour

Only in Power Query, you can use data type duration for values <0 or >= 1 (1 = 1 day = 24 hours).


These will be converted to decimal values when loading into the datamodel.

Specializing in Power Query Formula Language (M)
Microsoft v-huizhn-msft

Re: Format Hour

Hi @Jacy,

Could you give an example sample table and list the desired result? Do you try the solution @MarcelBeug posted?

Best Regards,

Helpful resources

New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors