Converting Duration in minutes to hours and minutes

[JemmaD]

I have a duration column in minutes, so 1.5 hours = 90.00.

I want to show the duration in hours and minnutes, but not a decimal. I don't want 90 minutes to 1.50 and 30 minutes to be 0.50. I want 90 minutes to be 1.30. Is there any way to do this?

[Nathaniel_C · Accepted solution]

Hi @JemmaD ,
Please go to Power Query.
Divide and round down, Apply Modulo, Merge columns with a "." seperator.
Result"

step 1

step 2

step 3

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[JemmaD]

Thanks @Nathaniel_C this worked perfectly.

[Nathaniel_C]

Hi @JemmaD ,
You are very welcome!
Nathaniel

[NishPatel]

You can try this formula where you need to replace 90 with your number that you want it to convert it to decimal. =((90-(90-60))/60)+(90-60)/100

[Ahmedx]

Is this what you are looking for?