Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PatriceGREN
Regular Visitor

Times / convert minutes beyong 24h

Hi, 

I have a table with minutes. I would like to convert those minutes into hours, minutes. As Excel does, I would like to go beyond 24h, without converting to day. Can you help me? Thank you

Patrice

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @PatriceGREN ,

Could you try adding a new column with this formula ? (I assumed your column name is 'Minutes')

Format = 
var hourNo=INT([Minutes]/60)
var minuteNo=MOD([Minutes],60)
var secondNo=INT(([Minutes]-INT([Minutes]))*60)
return
FORMAT(hourNo,"#00")&":"&FORMAT(minuteNo,"#00")&":"&FORMAT(secondNo,"#00")

I found this solution there : https://community.powerbi.com/t5/Desktop/convert-minutes-into-hours-minutes-and-seconds-Not-Days/td-...

 

Regards, 

Etienne

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @PatriceGREN ,

Could you try adding a new column with this formula ? (I assumed your column name is 'Minutes')

Format = 
var hourNo=INT([Minutes]/60)
var minuteNo=MOD([Minutes],60)
var secondNo=INT(([Minutes]-INT([Minutes]))*60)
return
FORMAT(hourNo,"#00")&":"&FORMAT(minuteNo,"#00")&":"&FORMAT(secondNo,"#00")

I found this solution there : https://community.powerbi.com/t5/Desktop/convert-minutes-into-hours-minutes-and-seconds-Not-Days/td-...

 

Regards, 

Etienne

Hi @Anonymous , 

Thank you,
I’m sorry I asked a question that was already resolved, I saw this solution and I didn’t understand its usefulness. 

Patrice

 

 

Anonymous
Not applicable

There is no problem, it was a pleasure to help. Have a nice day ! 

Etienne

and it’s text, so I can’t add the values, as I could do on Excel, I must find another solution

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.