Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Duration format issue JIRA

Hi, I am getting this field from Jira                      In PBI it is appearing in this format. Changing to "Duration" format is giving me errors   1 Day, 32 Minutes = 3012...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    My problem is resolved : 1 = 8 hours.

     

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

Sorry for that, but we cannot understand the conversion logic behind "1 Day, 32 Minutes = 30120", could you please navigate to previous step in power query editor and see what is the origin format of “30120”, or explain the logic how to convert "1 Day, 32 Minutes“ to "30120" so that we can write a formula to convert it into hours?

 


Best regards,