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 = 30120

 

Any ideas how can I transform it to hours?

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    My problem is resolved : 1 = 8 hours.

     

     

3 Replies

  • 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,



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

    Hi  Anonymous ,

     


    Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.

     


    Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    My problem is resolved : 1 = 8 hours.