Time data in different units when exporting to excel

[Shachar Shain]

Exporting a list of issues to excel result time data in seconds not hours as appear in Jira

[Walter Buggenhout · Accepted solution]

Hi @Shachar Shain and welcome to the Community!

It is even in milliseconds. That is indeed the way time data is stored behind the scenes in Jira. When you run an export, it is the raw data that's exported, not the way it is formatted in the UI.

Hope this clarifies!

[Shachar Shain]

Thank you. it is clear. but when It comes to sharing the data in excel it will be very helpful to show it in hours.

[Walter Buggenhout]

Sure, @Shachar Shain. Be aware though that Excel is not part of Jira. You can manipulate the data any way you want by performing calculations on the result to transform the exported data into the desired format.

If you can bring your users into Jira instead of getting the data out of it, they will benefit of real time data formatted in a user friendly way.

That said, if you rely on exporting data on a frequent basis, there are marketplace apps available that enhance the out of the box export capabilities. 

[Shachar Shain]

Thank you very much for your detailed answer

[Levente Szabo _Midori_]

@Shachar Shain 

You just found one of Jira Cloud for Excel add-in's limitations as documented here with other things.

One option you can try instead is a native and dedicated Jira Cloud app (not an Excel add-in!) like Better Excel Exporter for Jira Cloud. It was created with use cases like yours in mind and presents the Jira data (including numbers, dates, versions, etc.) as you expect them.

(Please note that Better Excel Exporter is a paid and supported app and I'm part of the team developing it.)