exporting data in Hours/Mins and not seconds

[Danielle David]

Seen some old posts about this, however hoping there is a solution out of the box and not an app.

When export data it exports in seconds not Hours/Mins etc.

I have a work around in the excel, hoping there is a perm solution in JIra

[John Funk]

Hi Danielle,

I don't know of a way to do it other than creating a custom number field, add an automation rule to do the math (division) and store the value in that field. 

[Danielle David]

Thanks @John Funk , I will give this a go. can you share (without sharing anything data breaching) the automation rule for the math please

[John Funk]

Sure, it can be as simple as below.

[Hannes Obweger - JXL for Jira]

Hi @Danielle David

the easiest might be actually be to do the math in Excel, which I assume is your current workaround. Apart from an automation-based solution as suggested by John, the other alternative would indeed be to rely on one of the export-focused apps on the Atlassian Marketplace.

If I may add a concrete recommendation: The time spent format would also be easy to configure in the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It is highly configurable, meaning that you can specify the exact format of e.g. your time spent column - and of course, this format is respected in exports. This is how it looks in action:

I should add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Valeriia_Havrylenko_SaaSJet]

Hi @Danielle David  👋

As @Aron Gombas _Midori_ said the "time spent" value is stored internally as seconds and is exported without any transformation. Alternatively, Іf you consider installing third-party add-ons to help, you can try Time in Status developed by my team. 

In add-on for exporting data in Hours/Mins simply:

1. Choose right Time Format for you 
2. Click Export

And here is the data after exporting in an XLSX file.

You can also book a live demo - we'll show you the application inside out and answer all your questions.

Have a nice day 🥳

[Aron Gombas _Midori_]

@Danielle David The "time spent" value is internally stored as seconds, and it is exported "as is", without any transformation -- that is the explanation.

What @John Funk suggested would work, at the cost of adding an extra custom field.

You can also use the Better Excel Exporter app, which out of the box exports the values in hours (samples). For example, 90 minutes is exported as "1.5".

We decided to prefer this format, because that way you can do arithmetics on the values, like calculating totals, averages, min, max, do sorting and so. And, the unit is the most intuitive one ("hour"), see column "J":

If you don't like it is actually easy to change it to a textual presentation "1h 30m" though!

(Discl. it is a paid and supported app developed by our team.)