How to convert column from minutes to hours

[Anonymous]

Hi!

it sound simple but it is giving me error. I have one column with minutes and I want to convert it in Hours (hh:mm)

What I am doing wrong=

I have / I want:      

123123 / hh:mm

1232/ hh:mm

2445/ hh:mm

22/ hh:mm

4455/ hh:mm

What am I doing wrong?

Thx so much,
JFB

[AlB · Accepted solution]

@ingindustrial

He seems to complain simply because he's using ";" instead of "," as a separator

The rest should be fine, even if you keep in mind that it will flip if the result is longer than 24 hours

Please mark the resolved question when you are finished and consider giving a thumbs up if the posts are useful.

Contact me privately for assistance with any large-scale BI needs, tutoring, etc.

Bless you

[amitchandak · Accepted solution]

@Anonymous , Try like

time(Quotient([duration_agent_status],24),Quotient(mod([duration_agent_status],24),60))

also check these

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

[AlB · Accepted solution]

@ingindustrial

He seems to complain simply because he's using ";" instead of "," as a separator

The rest should be fine, even if you keep in mind that it will flip if the result is longer than 24 hours

Please mark the resolved question when you are finished and consider giving a thumbs up if the posts are useful.

Contact me privately for assistance with any large-scale BI needs, tutoring, etc.

Bless you