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

## Re: Times / convert minutes beyong 24h

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
Highlighted
Resolver III

## Re: Times / convert minutes beyong 24h

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

Highlighted
Regular Visitor

## Re: Times / convert minutes beyong 24h

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

Highlighted
Resolver III

## Re: Times / convert minutes beyong 24h

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

Etienne

Highlighted
Regular Visitor

## Re: Times / convert minutes beyong 24h

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

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

#### Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors