How to sum total Hours and Minutes in one column

[PowerBIData]

Hi,

Kindly advice, 

I have two columns Traveltime (hh: mm) id column 

*I want to calculate the total travel time which is 4.54+3.06+6.30+3.30=18.0Hrs

Below is the Datatable 

ID	TravelTime(hh:mm)
1	4.54
1	3.06
2	6.30
2	3.30

Many thanks 

[v-easonf-msft · Accepted solution]

Hi,  @PowerBIData 

You need to convert the relevant "minutes" in the data into "hours".

Please try the following formula to convert the data：

calculated column:

hour(h) = ROUNDDOWN('Table'[TravelTime(hh:mm)],0)

minute(m) = 'Table'[TravelTime(hh:mm)]-'Table'[hour(h)]

hour(hrs) = 'Table'[hour(h)]+'Table'[minute(m)]/60*100 

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

create a caluclated measure

measure1 = sum(TravelTime)

then drag ID and measure1 into a table.