Time field can not be summed in powerBI

[Anonymous]

Dear All,

My issue is what i can not solve, i have a time column in Excel in the format [h]:mm showing the duration of the call. It perfectly works in excel in Pivot table is can easily sum up them by period. Scrrenshot attached.

However in Power BI after import, the field appears in this very strange format :

and powerBI simpli can not handle it as a number. Can anyone please lighten me up, what i try not correctly? 

I already tried to add different kind of fields like 

IRTime = SUMX('2022',HOUR('2022'[Incident Resolution Time])*3600+MINUTE('2022'[Incident Resolution Time])*60)

or 

IncidentResolutionTime =

VAR _Hour = HOUR( SELECTEDVALUE( '2022'[Incident Resolution Time] ) )

VAR _Minute = DIVIDE(MINUTE( SELECTEDVALUE( '2022'[Incident Resolution Time] ) ), 60, 0 )

VAR _Result = _Hour + _Minute

RETURN

_Result

But didnt help.

[Anonymous]

Hi Ibendlin!

Thank you for the response. I created a sample data both in excel and in powerbi, but this field not supports nor xlsx nor .pbi files. Can you please advise how could i upload them here?

Thank you,

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

[Anonymous]

Thanks a lot Ibendlin for your fast response. i tried this already but duration type is greyed out unfortunately. I dont understand why either. 

[lbendlin]

Do the type conversion in Power Query, not in Power BI.

Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[lbendlin]

Use the Duration type instead.