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

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 II

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

Proud to be a Super User!

Super User IV

@Daven , Try like New column

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

or

Proud to be a Super User!

Highlighted
Microsoft

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

Thanks Dedmon

It works perfectly!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors