Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
Jamie Schena
(53●15●21) 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?

0 votes

2 answers
4,574 views
0 votes

Accepted answer

Permanent link
Krzysztof Kaźmierczyk
(7.5k●4●80●103) 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

0 votes

One other answer

Permanent link
Jamie Schena
(53●15●21) 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). 

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,024

Question asked: Jun 06 '13, 2:52 p.m.

Question was seen: 4,574 times

Last updated: Feb 03 '14, 10:52 a.m.

Confirmation Cancel Confirm