Forum Discussion

Sean29's avatar
Sean29
Frequent Visitor
1 year ago
Solved

Convert run times in PQ

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...
Show and Tell
Tips and Tricks
  • Omid_Motamedise's avatar
    Omid_Motamedise
    1 year ago

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

shafiz_p's avatar
shafiz_p
Super User
1 year ago

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's avatar
Sean29
Frequent Visitor
1 year ago

I received couldn't convert to Duration error?