When I export the time spent jira data to google sheet it gives me number instead of day hrs secs

[rahul_sindhe]

When I export the Jira data to google sheets , the time spent column whihc is in ddhhss format is getting converted to numbers format. Fx: 1 day, 1 hour, 55 minutes will show as number  84960

[Valerie Knapp]

Hi @rahul_sindhe , welcome to the Atlassian Community and thanks for your post.

If I understand correctly, this is the expected behaviour as times are exported in seconds from Jira - https://support.atlassian.com/jira/kb/understand-how-the-original-estimate-field-value-is-calculated-when-viewing-the-data-export-in-jira-cloud/ .

I don't think there is a workaround for this unfortunately, you just need to use a formula in the sheet to get the number back into the value you want so days / hours.

I hope this helps you.

Best wishes