Convert to Time and SUM the value

[Filipe89]

Hi everyone, 

on my project i tryied i have the detail of the time that took the user to do an action. 

Inicialy it was a decimal value (BusinessTimeSpendWhitsubtasks), but i converted the value to time format (Tempo), but i cannot SUM the total, or gives me an error that the type is text so i cannot SUM 

I just want to sum the total of Tempo columm 

If i try to convert to type Hora(HOUR) it says it cannot do it because is text type. 

Could some one have any idea how to do it ? 

Thank you 

[v-rongtiep-msft]

Hi @Filipe89 ,

Please have a try.

Change the type to the time type.

Then create a measure.

su = SUM('Table'[time2])-SUM('Table'[time1])

I have also found a similar post, please refer to it to see if it helps you.

Solved: Sum up the time format - Microsoft Power BI Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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

[Filipe89]

Hi, Thanks for the reply,

I created a new collum and tryed to apply your exemple, once whit the collum "Businesstime spendwhitsubTasks" and once whit the collumn "Tempo", but might be something missing, because whit the first table gives me the warnig " cannot convert text to number  ", whit the column "Tempo" says it cannot work whit values of the type string.  Any ideia of what could be missing ?

thank you for the help 

[Greg_Deckler]

@Filipe89 Try something like this: Chelsie Eiden's Duration - Microsoft Power BI Community