Convert run times in PQ

[Sean29]

I am having trouble converting 2.4km run times, to correctly display data. Example run is 9:56 (min,sec). But when converted to PQ and transform represents as 12:09:56 AM.

Is there way to convert this is PQ to represent mm:ss?

[Omid_Motamedise · Accepted solution]

See this one
= [a=Time.From("00:9:56"),b=#duration(0,0,Time.Minute(a),Time.Second(a))][b]

[shafiz_p]

Hi @Sean29  You could try to add a custom column with this code:

= Text.From(Duration.From([YourTimeColumn]), "mm:ss")

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz 

[Sean29]

I received couldn't convert to Duration error?