View and add up to 24 hours!

[tiagotas]

I need to create a panel where I visualize the sum of hours worked, and these hours are mostly over 24 hours. Ex: 36:00 hours. Can I use this format in Power Bi?

[v-caliao-msft]

Hi @tiagotas,

In your scenario, you can use DATEDIFF function to get the total hours for each employee, this value can exceed 24 hours.

Reference
https://msdn.microsoft.com/en-us/library/dn802538.aspx

If this is not what you want, please provide us some sample data and expected result, so that we can make further analysis.

Regards,

Charlie Liao

[ImkeF · Accepted solution]

Yes, you split that field by the separator: ":" into 2 fields: First "Hours", second "Minutes". Perform all aggregations and transformations on these 2 fields separately before in the last step, you add them together again to create the total field, this time in a decimal format.