Seconds to HH:MM:SS

[efilipe]

Hi guys,

I have numbers with decimals, like:

19,400

8,50

14,70

56,000

The are miliseconds of videos.

I need to transform that to HH:MM: SS. Is it possible? And after, will the column (power m) will work on the sum of that time?

I did see this solution, but It doesnt SUM: https://gist.github.com/jonbgallant/5b8dcf13ab957cecfec3932a42db0e58

Any ideas?

Thanks,

Ed!!

[Anonymous]

Hi, 

You can do it easily with custom column created and using duration function in M Script.

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

Step by step solution has been provided in the article link mentioned above. 

Kaushlendra Mishra 

www.powerbitalks.com 

[efilipe]

@Greg_Decklerany idea? 🙂

[Greg_Deckler]

Well, if you divide the number of milliseconds by 1000 you would have seconds and then you should be able to use the technique here to get it into HH:MM:SS. https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

[efilipe]

@Greg_Deckler , thanks for replying, PB ninja.

But the result wont sum up the column result, right?

[Greg_Deckler · Accepted solution]

Yeah, you have to SUM it when it is in seconds and then take that SUM and convert it to HH:MM:SS format. I know, pain.