Calculate Timesheet Hours (duration) and display by month using stacked column graph

Hi,

I'm working with timesheet data pulled from Clockify.

They already push through the "Interval duration", which is the employees daily time captured in hh:nn:ss. So we don't have to work that out the duration with the start and end times.

My data looks as follows:

Name of file: "Clockify Time Entries"

- I'm aiming to use the "Interval Duration" and "Interval Start Date" columns

- Interval Duration format: Set to "Duration" type, and format (hh:nn:ss)

What I would like to achieve:

- Display the sum of the duration/ time captured per month

- This will then allow you to filter by Project/client/users to see more details on the sum of hours logged

Issue I'm facing:

- Seems like Power BI does not want to sum my "Interval Duration" column

- I selected a stacked column graph, then on X-Axis = Interval start date to get Year and Months, and on the Y-Axis = Count of Interval Duration

- The issue is for some reason it's counting the amount of rows, and not the actual Interval Duration for each row

- i.e. for the month of October it counted 35 lines of timesheet entries 😞 but i'm looking for the sum of the duratiuns captured for October

here is my current visual:

I face the same issue when trying to display the count of Interval duration by Employee.

- Again power BI thinks i'm looking for the rows of entries, and not counting the actual duration they've enetered

Does anyone know how to tell the query to SUM the duration values?