Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,682
Community Members
 
Community Events
165
Community Groups

export a time field in csv

I have a time field named ''Time to close by Technician'' which gives values in DD:HH:MM

When i export in csv it gives values that are random numbers.

Anyone knows how to fix this?

 

Thanx

 

3 answers

2 accepted

0 votes
Answer accepted

Exports give you the actual data that is in the field, and you are not getting random numbers.  Date and time are held as "epoch offsets" - a number of seconds or milliseconds since a specific date.

Your field sounds like a dedicated length-of-time field, which stores a length of time in the same way (a number of seconds or milliseconds) but presents it in a more human friendly way.

Try dividing the number you are getting by 3600

0 votes
Answer accepted
Ivan Lima Community Leader Jun 08, 2022

Hi @George T, fields like time spent can be exported in seconds, so you need to convert the values to the format you expect. Random numbers sound like serial numbers when you open them in excel, which you need to convert to date format by selecting the column and applying the date format or a custom date format. If what I mentioned didn't help, It would be helpful if you could provide more details such as the custom field type you're using, screenshot, etc.

Thanx for the info guys, those numbers were indeed percentage of the working day

The easiest way was to create another field but instead of ''Calculated Number Field (by JWT)'' this time we chose ''Calculated Text Field (by JWT)''

The expression would be 

shortFormatDuration({issue.cf13012})

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you