exporting time to resolution in csv appears as a formula and is min:hours.

[Deb Keene]

How do I export in csv and have result look the same as it does in the ticket.  The ticket shows xx hours xx min.  An example- when it exports it shows as =-46:77.  I want it shown in excel as 77 h 46 m.  Or are there other options that are not an add-on purchase?

[Alex Koxaras -Relational-]

@Deb Keene hi,

Exports in Jira will have SLAs in that specific format and not in pretty print. However, what's stopping you of adding a formula to make it exactly like Jira? E.g. -46:77 will be -46h 77m

[Deb Keene]

 I would need to update the cell so it is no longer a formula, then flip the order of the information in the cell.  It appears in excel as =-46:77 but on the ticket it shows -77h 46m.   Is there an easy way to do that?

[Alex Koxaras -Relational-]

How is this possible? I've exported issues from Jira and on on my export this is not how it appears.

[Alex Koxaras -Relational-]

You could use a formula like:

=IF(LEFT(GD2,1)="-","-"&LEFT(GD2,FIND(":",GD2)-1)&"h "&MID(GD2,FIND(":",GD2)+1,LEN(GD2)-FIND(":",GD2))&"m",LEFT(GD2,FIND(":",GD2)-1)&"h "&MID(GD2,FIND(":",GD2)+1,LEN(GD2)-FIND(":",GD2))&"m")

and switch the left and right side for m and h correspondingly.

[Deb Keene]

when I export- the field itself has #VALUE! and when I put my cursor in that field- it does appear as:   =-46:77.  showing the minutes and then the hours.  This only happens in some rows-only the rows that are showing a breach in the SLA.  if the item has not breached it shows correctly in the cell as min:hours.  I am also noticing there is a circular reference error that is happening with the fields that have #VALUE! which is very strange because it is a straight export from the query- I have not put any formulas in the spreadsheet that I am exporting the data to

[Dan Breyen]

Hi Deb, my experience has found that without using some sort of add on, the format that the data is exported in isn't going to change.  If you're importing into excel, you should be able to define the field as a time field and then format it however you'd like.  

That's what I'd do anyway.

Hope that helps.