Time converting

[rajrajsha]

Hi, I have a requirment with Time format.

  - Time format in Excel is "6h 32m"

  - I want to convert this with Power query in the form of "6:53". Where minute(32) is divided with 60.

I tried this in many ways but no luck as of now.. Can someone guide me in this pleae. 

Thanks.

[Vera_33]

Hi @rajrajsha 

Text.BeforeDelimiter([Column1],"h")&":"& Text.From( Number.Round( Number.From(Text.BetweenDelimiters([Column1],"h","m"))/60,2)*100)

[rajrajsha]

@Vera_33,

Hi

First of all thanks for attempting my query.

From long time i have been trying with multiple steps to get the above result, but not found exact output. But you cracked it with only single step.. That was really awsome.

Please find the below image, where i see two dots in the result not sure how to get out of this. I tried with RoundDown and RoundUp but no use.  Could you please help me out of this.. Rest all works fine 

 

Thanks for the Support

[Vera_33 · Accepted solution]

Hi @rajrajsha 

My guess is that the original data contains decimal in m, like 0h 34.8m? Modify it a little bit

If you use 2, then 32m will be 53.33

Text.BeforeDelimiter([Column1],"h")&":"&  Text.From( Number.Round( Number.From(Text.BetweenDelimiters([Column1],"h","m"))*100/60,2))

Or you can go with

Text.BeforeDelimiter([Column1],"h")&":"&  Text.From( Number.Round( Number.From(Text.BetweenDelimiters([Column1],"h","m"))*100/60))