It's all about the answers!

Ask a question

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

Jamie Schena (531521) | 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

permanent link
Krzysztof Ka┼║mierczyk (7.5k477103) | 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:

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

One other answer

permanent link
Jamie Schena (531521) | 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.