Convert whole number representing minutes to duration hh:mm (hours:minutes)

[DAXRichArd]

Hello,

I work with Commercial Aviation Data.

• I want to convert a whole number that represents minutes into duration.
• The whole number that represents minutes is a measure that calculates the total flight time from an aircraft's point of origin to it's destination.

My table name is HAS Web Schedule Data.
My measure name is Flight Time.

My desired output is a matrix that shows

Airline Destination  Country Destination   City         Departure Time  Seats  Flight Time
China Airlines          China                          Beijing   11:00 am             311    hh:mm

I've looked through this forum but haven't found anything that directly addresses my question. I've tried reverse engineering similar questions / solutions but I haven't been able to. Thx in advance for your help and support.

Thx in advance for all your help.

DAXRichArd

Below is a screenshot of what my data looks like before I query it and clean it up.

[jdbuchanan71 · Accepted solution]

Hello @DAXRichArd 

Give this one a try, should with with a column or a measure.

Duration Fomatted = FORMAT(Table1[Duration Minutes] / 60 / 24, "h:mm")

[jdbuchanan71 · Accepted solution]

Hello @DAXRichArd 

Give this one a try, should with with a column or a measure.

Duration Fomatted = FORMAT(Table1[Duration Minutes] / 60 / 24, "h:mm")

[DAXRichArd · Accepted solution]

It works! Thx.