It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×11,924

question asked: Jun 06 '13, 2:52 p.m.
question was seen: 4,116 times
last updated: Feb 03 '14, 10:52 a.m.

Related questions

FAQ - How this Forum works

Web app Export Time without "hours" or "mins"

0
Jamie Schena (53●15●21) | asked Jun 06 '13, 2:52 p.m.
I need to be able to easily calculate the difference between my Estimate and my Corrected Estimate times when I export them to excel. However, the times show up as "4 hours 36 minutes", so I can't just do a simple calculation. Is there a way to fix this?

Accepted answer

0
permanent link
Krzysztof Kaźmierczyk (7.4k●3●74●103) | answered Jun 07 '13, 2:44 a.m.
Hello Jamie,
You can create new calculated value field which returns the value of Estimate attribute in s and export the value of that attribute. You will find more information here: https://jazz.net/library/article/1003/#calc-values

Best regards,
Krzysztof Kazmierczyki
Jamie Schena selected this answer as the correct answer

One other answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Jamie Schena (53●15●21) | answered Feb 03 '14, 10:52 a.m.
 I have also found an easy way to convert the string to a numerical value in Excel. For example, 4 hours 30 minutes will now read 4.5 (measured in hours). 

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.