cancel
Showing results for
Did you mean:
Highlighted
Helper I

## Average Talktime in HH:MM:SS format

Hi,

I have a seconds column for the talktime, I would like to show average talktime for each catgory in the HH:MM:SS format.

Data in the tables

 Call_ID Team Talktime_InSeconds Talktime_InHMS 1 A 508 00:08:28 2 A 475 00:07:55 3 A 309 00:05:09 4 B 779 00:12:59 5 B 277 00:04:37

Would like below results

 Team Average Talktime A 0:07:11 B 0:08:48

Daven

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

## Re: Average Talktime in HH:MM:SS format

Hi @Daven ,

Would you please refer to the measure below:

Measure =
VAR _Duration =
AVERAGEX ( 'Table', 'Table'[Talktime_InSeconds] )
VAR Hours =
INT ( _Duration / 3600 )
VAR Minutes =
INT ( MOD ( _Duration - ( Hours * 3600 ), 3600 ) / 60 )
VAR Seconds =
ROUNDUP ( MOD ( MOD ( _Duration - ( Hours * 3600 ), 3600 ), 60 ), 0 )
RETURN
Hours * 10000 + Minutes * 100 + Seconds

Then change the data type to custom and 0:00:00 :

For more details ,please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ERNkGZGrCQxIs3eBOT...

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

Best Regards,

Dedmon Dai

4 REPLIES 4
Highlighted
Super User III

## Re: Average Talktime in HH:MM:SS format

Measure = FORMAT( CALCULATE(AVERAGE(Sheet13[Talktime_InHMS]),ALLEXCEPT(Sheet13,Sheet13[Team])),"HH:MM:SS")

Proud a to be a Datanaut!
Thanks and BR
Ryan
Highlighted
Super User IX

## Re: Average Talktime in HH:MM:SS format

@Daven , Try like New column

time = time(0,0,[Talktime_InSeconds])

or

Proud to be a Super User!

Highlighted
Microsoft

## Re: Average Talktime in HH:MM:SS format

Hi @Daven ,

Would you please refer to the measure below:

Measure =
VAR _Duration =
AVERAGEX ( 'Table', 'Table'[Talktime_InSeconds] )
VAR Hours =
INT ( _Duration / 3600 )
VAR Minutes =
INT ( MOD ( _Duration - ( Hours * 3600 ), 3600 ) / 60 )
VAR Seconds =
ROUNDUP ( MOD ( MOD ( _Duration - ( Hours * 3600 ), 3600 ), 60 ), 0 )
RETURN
Hours * 10000 + Minutes * 100 + Seconds

Then change the data type to custom and 0:00:00 :

For more details ,please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ERNkGZGrCQxIs3eBOT...

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

Best Regards,

Dedmon Dai

Highlighted
Helper I

## Re: Average Talktime in HH:MM:SS format

Thanks Dedmon

It works perfectly!

Announcements

#### Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021