Suming Time

[chintusasmal123]

I want to calculate the sum of time taken my each employee and also days based on that total time.
For example 100 task(each record) takes 00:20:00 (20 min for each task) , so total will be 2000 min and days will be 3.9 days (2000/(8.5hr * 60))and there are 4 such employee 
I'm using table visual to show the record.
But can't able to sum the time value.
Below is the dataset field

[v-jingzhan-msft · Accepted solution]

Hi @chintusasmal123 

The time type in Power BI represents a point in time rather than a Duration. As the current column is in Time type, you can create a new column with below DAX to convert it into minutes. 

Time (Minutes) = HOUR('Table (2)'[TimeHHMM])*60 + MINUTE('Table (2)'[TimeHHMM])

Then use the new minutes column for calculation. Create measures:

Total Time (Minutes) = SUM('Table (2)'[Time (Minutes)])

Total Days = [Total Time (Minutes)] / (8.5*60)

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[ryan_mayu]

@chintusasmal123 

you need to convert to number and do the calculation then convert to text to show in days.

Solved: Re: [h]:mm:ss formatting calculating days rather t... - Microsoft Fabric Community