Convert HH:MM format to text value (hours and minutes)

[ailiyasaeed]

Hello - I am new to Power BI.

I have been trying to convert HH:MM into the text format i.e hours and minutes 

Column name (Average_Hours HH:MM) - data type: Text

00:40 

01:22

I would like to convert this data into the following:

0 hours 40 mins 

1 hour 22 mins 

Any Dax formula available? Thank you!

[ailiyasaeed]

@Greg_Deckler thank you very much! it worked perfectly! 

[Greg_Deckler · Accepted solution]

@ailiyasaeed Maybe:

Column = 
  VAR __Hours = LEFT([Average_Hours HH:MM],2)+0
  VAR __Minutes = RIGHT([Average_Hours HH:MM],2)+0
RETURN
  __Hours & " hours " & __Minutes & " mins"