The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

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

Time spent in seconds

Petr AST
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 Champions.
March 10, 2021

Hi there!
Can you help me with this moment?
I use Jira Time tracking to track time in Progress. All is ok, but there is a problem in exporting the result. 
In the filter I can see 50m or 1.75h. But when i export data to csv or html report I see this value in seconds, for example 50m = 3000, 1.75h = 6300

Is it possible to get the value in minutes or hours when exporting?
Thanks a lot!

Regards, 
Petr

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Answer accepted
Mohamed Benziane
Community Champion
March 11, 2021

Hi,

The easy way is to add a formula in you excel file to convert second to minutes or hours.

Hope this helps

Petr AST
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 Champions.
March 11, 2021

Hi @Mohamed Benziane 
Sure, one of the way, but it is not the solution:)

Can you tell me, if you know, how does time display format affect to system? Did not find the difference? I will be grateful!!

time tracking.png

Mohamed Benziane
Community Champion
March 22, 2021

This feature will only modify how the time will appear on an issue.

 

https://support.atlassian.com/jira-cloud-administration/docs/configure-time-tracking/

Petr AST
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 Champions.
March 23, 2021

@Mohamed Benziane

Good day!
It seems to me that it still does not work as it should? 

time.pngtime2.png 

Regards, 
Petr

Like Laube Daniel likes this
0 votes
Nina Marshall
July 30, 2021

Is there a story in the backlog to make sure that it doesn't export the data in seconds?

DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events