It's all about the answers!

Ask a question

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


Jamie Schena (531421) | 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.4k34796) | 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



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