Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

While exporting data in CSV file original estimate is calculated in seconds.

shaibaz Qureshi May 23, 2023

While exporting data in CSV file original estimate is calculated in seconds. is there any way we can export the original estimate in hours?

1 answer

1 accepted

2 votes
Answer accepted
Walter Buggenhout
Community Champion
May 23, 2023

Hi @shaibaz Qureshi and welcome to the Community!

The exported value is not calculated in seconds; that is how the data are actually stored in Jira. If you see them presented otherwise in Jira, it is because the UI transforms it into a better reading format.

Similarly, if you want to view the data in hours in Excel after exporting it, apply a calculation formula there to convert the seconds into any type of unit you like (e.g. seconds / 3600).

Hope this helps!

shaibaz Qureshi May 23, 2023

Hi @Walter Buggenhout  Thank you for your input.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, aafp, jira migration, marketing collaboration, end siloed work, streamline workflows, kerrie gottschalk, jira cloud admins, unified marketing, process visibility, team efficiency, cross-team collaboration

How Kerrie Gottschalk unified AAFP’s marketing team with Jira

At the American Academy of Family Physicians, siloed marketing teams faced delays and duplicate work. Kerrie Gottschalk shook things up by moving the department to Jira, streamlining processes, boosting visibility, and sparking stronger collaboration.

Read the story
AUG Leaders

Atlassian Community Events