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 this is PQ to represent mm:ss?

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

3 Replies

  • 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

      I received couldn't convert to Duration error?

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