cancel
Showing results for
Did you mean:
Highlighted
Member

## Seconds to HH:MM:SS

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!!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Seconds to HH:MM:SS

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

Proud to be a Datanaut!

4 REPLIES 4
Member

## Re: Seconds to HH:MM:SS

@Greg_Decklerany idea? :-)

Super User

## Re: Seconds to HH:MM:SS

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:MMS. https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

Proud to be a Datanaut!

Member

## Re: Seconds to HH:MM:SS

@Greg_Deckler , thanks for replying, PB ninja.

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

Super User

## Re: Seconds to HH:MM:SS

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