Forum Discussion
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")
Hi Anonymous,
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
4 Replies
Hi Anonymous,
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 GuIn 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")
Hi Anonymous,
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
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