cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
efilipe Member
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
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:MMSmiley FrustratedS format. I know, pain.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


4 REPLIES 4
efilipe Member
Member

Re: Seconds to HH:MM:SS

@Greg_Decklerany idea? :-)

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

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


efilipe Member
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
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:MMSmiley FrustratedS format. I know, pain.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!