Forum Discussion
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
2 Replies
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.
Hi Jacy,
Could you give an example sample table and list the desired result? Do you try the solution MarcelBeug posted?
Best Regards,
Angelia
