cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Post Prodigy

## Convert seconds into hours and their format

I have a graph that presents the phrases in internal numbers, these values are in seconds and I need to convert this number in hours and present these values in the graph in the format of hh: mm: ss.

It is possible?

Follows the graph and the measurement:

TotalOrganizational Failures = CALCULATE (SUM (IndicatorValue [Value]); Indicator [Name] = "Organizational Failures")

1 ACCEPTED SOLUTION
Employee

Hi @vitexo87,

To convert the second to hours, you only need to divide it by 3600.

TotalOrganizational Failures = CALCULATE (SUM (IndicatorValue [Value]); Indicator [Name] = "Organizational Failures")/3600

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Anonymous
Not applicable

You can do it easily with M script duration function

Please go to the below link. New custom column can be created using M script.

https://www.powerbitalks.com/2019/12/convert-seconds-to-hhmmss-format.html

Step by Step solution has been provided.

Kaushlendra Mishra

www.powerbitalks.com

Employee

Hi @vitexo87,

We are able to convert seconds into hours with format "hh:mm:ss".

```hh:mm:ss =
RIGHT ( "0" & INT ( Table[seconds] / 3600 ), 2 )
& ":"
& RIGHT (
"0"
& INT ( ( Table[seconds] - INT (Table[seconds] / 3600 ) * 3600 ) / 60 ),
2
)
& ":"
& RIGHT ( "0" & MOD (Table[seconds], 3600 ), 2 )```

But after formatting, values will be set to text data type. It is not possible to show actual values of text data in a bar chart, because it will be aggregated (Count/Count Distinct) automatically if adding it into values section in a chart visual.

So, your requirement cannot be achieved currently.

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Post Prodigy

@v-yulgu-msft

In this case I will then display the value in hours not displaying the format "hh: mm: ss", using the measure that I am already using what change should I make for it?

TotalOrganizational Failures = CALCULATE (SUM (IndicatorValue [Value]); Indicator [Name] = "Organizational Failures")

Employee

Hi @vitexo87,

To convert the second to hours, you only need to divide it by 3600.

TotalOrganizational Failures = CALCULATE (SUM (IndicatorValue [Value]); Indicator [Name] = "Organizational Failures")/3600

Best regards,
Yuliana Gu

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

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors