Wanted to know the Timezone information involved with the Rally API responses

Products

• Rally SaaS
• Rally On-Premise

Issue/Introduction

What timezone is returned through the API?

Environment

Release : SAAS

Component : API FOR AGILE CENTRAL

Resolution

We store and export our times in UTC format.  In the UI, we perform the timezone offset calculation automatically using the timezone setting configured in the workspace settings.  But, for the API that calculation has to be done manually.

In Excel you can do a formula as follows (assuming the date string is in A1) and the timezone offset is -6 as highlighted below:

=DATEVALUE(LEFT(A1,10))+TIMEVALUE(MID(A1,12,8))-6/24