How to show total overtime of each user.. thanks

[Anonymous]

Hi, i have a column in my excel file called (Total Overtime) when i create dashborard in power query, instead of showing total overtime of each user it shows a number.. is there any solution for this,, thanks..

[Fowmy · Accepted solution]

@Anonymous 

In Power Query, select the Time column under the Transform tab, click on Duration and select Total Hours.
Then you can set the aggregation to SUM 

[Anonymous · Accepted solution]

Hi @Anonymous 

If you want to calculate the sum for overtime and show it in the bar chart ,you need change the format of the “Total Overtime” .

I found an article to convert time to digital form, maybe you can refer to it .

https://www.xelplus.com/power-query-time-calculations/

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy · Accepted solution]

@Anonymous 

In Power Query, select the Time column under the Transform tab, click on Duration and select Total Hours.
Then you can set the aggregation to SUM