You can export tracked time details from the "Budgets" page. By default, Timetracker exports these details in the form of an Excel file.
1. Sign into your Team Services or Team Foundation Services account.
2. On the main menu bar, click Time.
3. On the Time menu bar, click Budgets -> The system displays the Budgets page.
4. In the left pane, click -> The system displays the "Export Time Report" dialog box.
5. Click in the From field and select the start date from when you want to export the tracked time.
6. Click the To field and select the end date up to which you want to export the tracked time.
7 (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