Question
I exported a CSV file from Forecast. The time values do not match the values I see in the platform, why?
Answer
All "raw" data points for time values obtained via CSV or API appear as minutes while the platform displays the same values in hours. This is a conscious decision based on how clients choose to use the data outside of Forecast.
- Presenting time values as minutes provides greater flexibility to manage or manipulate the data when importing it into external tools, reports or other systems.
This applies to all data CSV export files within Projects and Standard Reports.
Best Practice: To convert minutes to hours, simply add a calculation to divide by 60.
For example:
- In a project, a task has an estimate of 2h.
- In the CSV export taken from Scoping, the task appears with an estimate value of 120.
- The CSV value is represented in minutes. To convert to hours, divide by 60. 120 minutes / 60 minutes = 2 hours.
Comments
0 comments
Article is closed for comments.