Data downloaded from a report is shown in incorrect format in pa

[YerragondaA3099]

Hi All,

When i export the data from the below dashboard in the finance request report in to the excel format the actual elapsed time shows the data in milliseconds .Here i want the data to be in same format as shown in report when downloaded too

How should i fix this issue ? please help 
Thank you in advance 

[AndersBGS]

Hi @YerragondaA3099 

This is standard behaviour when you export the data. You need instead to transform the data to the right format in Excel.

[YerragondaA3099]

Hi @AndersBGS ,
Thanks for the reply 

Could you please let me know how to transform these values?

I applied the formula Cell Value / 86400 and formatted the result as dd:hh:mm. However, as mentioned earlier, it works for some cells but not for others.

Could you please check the highlighted values and advise?