Format Hour

[Jacy]

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

[v-huizhn-msft]

Hi @Jacy,

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

Best Regards,
Angelia

[MarcelBeug]

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.