When exported,Time Spent is a random number and is not the actual Time Spent.How do I get true time?

Jennifer Gordon
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 22, 2023

When I export Issues out of JIRA, the Time Spent is a random number and is not the actual Time Spent.JIRA.png It is a strange number in general format. How do I get true Time Spent?

2 answers

0 votes
Tim Perrault
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 22, 2023

Hi @Jennifer Gordon 

 

Those aren't random numbers. Jira stores duration as seconds and exports them as seconds. You could format the excel file to turn the seconds into hours or possibly look for an app solution in the marketplace.

0 votes
David Fischer
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 22, 2023

Hi @Jennifer Gordon 

It's not a random number, it's the time spent expressed as a number of seconds, which is the internal representation of this field in Jira. 

Jennifer Gordon
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 22, 2023

oh thank you so much!!!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events