Exporting reports to excel sheets

[doaa87]

While exporting reports to excel sheets, it displays the time spent in (min), we want to export it in (Hours or Days), how can we do this?

[Nic Brough -Adaptavist- · Accepted solution]

You can't, it's hard coded at the moment.  There's a request to be able to alter the units open with Atlassian.

[Alana Fernando]

You should try using excel minute in to hour convert formula. hope this is ideal at the moment.

https://exceljet.net/formula/convert-decimal-minutes-to-excel-time