Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Time value for an Average Column

Hello,

I created a summarized table and  am trying to convert an average time value (Average Hour Time in this case) to a time format (HH:MM:SS). See Screenshot:

So 12.11 for Medicine Emory A should convert to roughly 12:07.

Any help will be greatly appreciated.

1 ACCEPTED SOLUTION
Community Support

Hi @ranis1227 ,

You can try this method:

New a measure:

``````Average_Time =

var _hours = ROUNDDOWN(SUM('Table'[Average Hour Time]), 0)

var _minutes = (SUM('Table'[Average Hour Time]) - _hours) * 60

var _seconds = (_minutes - ROUNDDOWN(_minutes, 0)) * 60

return

TIME(_hours, _minutes, _seconds)``````

Need to change the type here:

The result is:

Hope this helps you. Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

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

3 REPLIES 3
Community Support

Hi @ranis1227 ,

You can try this method:

New a measure:

``````Average_Time =

var _hours = ROUNDDOWN(SUM('Table'[Average Hour Time]), 0)

var _minutes = (SUM('Table'[Average Hour Time]) - _hours) * 60

var _seconds = (_minutes - ROUNDDOWN(_minutes, 0)) * 60

return

TIME(_hours, _minutes, _seconds)``````

Need to change the type here:

The result is:

Hope this helps you. Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

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

Helper I

Thank you @v-yinliw-msft . This is exactly what I needed.

Super User

Check out the below links and you will find how to convert your number to time:
https://community.powerbi.com/t5/Desktop/Convert-Decimal-Duration-in-HH-MM-SS-format/m-p/959061
https://community.powerbi.com/t5/Power-Query/How-to-convert-decimal-time-to-hh-mm-and-summarize-that...

https://www.myonlinetraininghub.com/converting-decimal-time-to-days-hours-minutes-in-power-bi

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

Appreciate your Kudos!!

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors