Forum Discussion
efilipe
Helper IV
Helper IVSeconds 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 colum...
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.
Greg_Deckler
Community Champion
Community ChampionWell, 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
efilipeHelper IV
Helper IV- Greg_Deckler
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.