Forum Discussion

bourne2000's avatar
bourne2000
Helper V
4 years ago
Solved

Convert the column into duration - Throwing an error

Hi   I have the below column   I am trying to convert it into duration. Getting below error message   Expression.Error: We couldn't parse the Duration literal. Details: 24:18:34   I c...
Need Help
Show and Tell
  • TheoC's avatar
    TheoC
    4 years ago

    bourne2000 this is the issue [[Talk Time]] instead of one lot of [Talk Time]

     

TheoC's avatar
TheoC
Community Champion
4 years ago

Hi bourne2000 

You need to add Custom Column and then use Duration.FromText ( [Your Column Name] ) then press okay.

 

Make sure to then click ABC123 and switch to Duration.

All the best,

Theo

  • bourne2000's avatar
    bourne2000
    Helper V
    4 years ago

    TheoC Thanks. I tried

     

     

    Getting below error message

     

    Expression.Error: We couldn't parse the Duration literal.
    Details:
    24:18:34

     

    Error coming only the duration is more than 24 hrs. Please advise

    • TheoC's avatar
      TheoC
      Community Champion
      4 years ago

      Hi bourne2000 

       

      I believe the error is in your data, not the code itself.  The error is basically saying that there is no such time as "24:18:34".  It should be 00:18:34 if it is 12:18pm.

       

      Basically what needs to happen here is that you need to split the column up into hours, minutes, seconds, and then divide hours by 24 to get days, hours.  From here, you can then merge them back together.  It's a quick process using Power Query.