cancel
Showing results for
Did you mean:
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

Accepted Solutions
Resolver III

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

4 REPLIES 4
Resolver III

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

Regular Visitor

Hi @EtienneOL ,

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

Resolver III

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

Etienne

Regular Visitor

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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform October Community Highlights

Check out the top community contributors across all of the communities

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors