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]

     

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.