How to export time without "hours" or "mins" spelled out
![]()
If I do a CSV export with any of the estimate or time columns, I get "XX Hours" in a text field in excel. What I really want is just the number so I can do math. Yes, I can highlight the column and do a replace of " hours" with nothing, followed by a replace of " hour" with nothing (for 1 hour tasks), but that becomes more problematic when I have "8 hours 30 minutes". Then after the first two replaces I have to replace " 30 mins" with ".5". With multiple denominations of minutes in use, it gets even more complicated and the margin of error goes up. Would be nice if I could just export the number. Is that possible?
|
One answer
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.