You can export tracked time details from the "Budgets" page. By default, 7pace Timetracker exports these details in the form of an Excel file.
1. On the Time menu bar, click "Budgets".
2. In the left pane, click .
The "Export Time Report" dialog box.
3. Click in the "From" field and select the start date from when you want to export the tracked time.
4. Click the "To" field and select the end date up to which you want to export the tracked time.
5 (Optional) Select one of the following options to export your time details:
- Add sum of effort/storypoints to topmost parent items
- Group identical data for same TFS ID by dates
- Include Billable and Billable Hours columns in Export
Add Sum of Effort/Story Points to Top-Most Parent Items
When you select this option, Timetracker first adds the effort/story points of all child work items to the effort/story points of the respective parent work item and then exports the work items. With this calculation, the exported Excel file displays the effort/story point details as the total of the effort/story points of the parent work item and all corresponding child work items.
Timetracker also adds a new column - Top TFS SP - in the exported Excel file. The Top TFS SP column displays the total number of effort/story points of all child work items and their parent work item.
If you don't choose this option, Timetracker separately exports the time details of the parent and and child work items.
Warning: Selecting this option might take additional time to populate results, as Timetracker needs to calculate the efforts/story points of all child work items and their parent items.
Exported Excel File Without Selecting This Option
The exported excel file only contains the Parent TFS SP column and not the Top TFS SP column. The Parent TFS SP column displays the efforts/story points of all work items.
Exported File With This Option
The exported Excel file contains the additional Top TFS SP column. This column displays the total of the efforts/story points of the parent work item and all corresponding child work items.
Group Totals of All Tracked Time with Same TFS ID Together Per Calendar Day
If, on a particular date, you work on the same work item at different times during the day, Timetracker separately records each time you work on that work item and for how long.
When you select this option, Timetracker exports your time details by grouping the time of the work item that you tracked on a particular date, but at different times on that date, together. The exported file displays the work item only once, with the date and time details grouped into the "Record Date" column. In the Excel file, the "Tracked" column displays the total time tracked for the same work item at different times.
When you export your time details without selecting this option, the Excel file separately displays the date and time details of the same work item, tracked at different times during that date, in separate rows.
Exported File Without Selecting This Option
The exported Excel file contains separate entries for the same work item. The "Start" and "End" columns and the "Tracked" column display the tracking time details separately for the same work item.
Exported File with This Option
When you select this option, the exported Excel file contains the "Record Date" column instead of the "Start" and "End" columns.
In the "Projects" list, select the checkbox for the projects for which you want to export the tracked time.
Note: In the projects list, you can only view the projects to which you have access/permissions.
9. Click the "Get Report" button -> The system downloads the report as an Excel file with extension