I am exporting a set of issues from a filter into a .csv file, In Jira the 'timespent' filed is correctly as "4 days, 3 hours," but in the .csv file it shows as "97200."
Does anyone know the formula for converting this to hours?
Hello @Scott Theus
I tried an export in my JIRA, and the timespent seems to be in second in the .csv files. In my issue i have 1minute and in my csv i have 60.
You can add a cell with this formula
="cell ref"/86400
And format this cell to time (37:30:55) or whatever you want.
Hope this helps.
Thanks @Mohamed Benziane I was guessing it was in seconds as well. Your formula got me 90% there, it turns out I forgot that my time tracking settings are using a 6 hour day, not an 8 hour day, so when I converted hours to days it was way off.
Using a 6 hour day got me the last 10%.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.