View team worklogs, pick columns, group data, save your personal layout and then export to Excel on 7pace Timetracker's "Times Explorer" page
Even with a small team, you can quickly log hundreds or even thousands of worklogs each month. 7pace Timetracker's "Times Explorer" page allows you to organize all your worklogs in a way that makes the most sense for you.
Note: When an administrator adds a user to the "Team" user role, they can access a special version of "Times Explorer" that displays the logged-in user's personal data only. In addition, to see the Person filter, the user must have at least the "Product" role assigned. This filter is not available for "Team" role users. To check on your users' permissions, you can go to the "Settings" page of Timetracker -> User Management ).
Roles higher than team will see the *worklogs for the entire team.
*A worklog is created any time you start tracking time and then stop tracking time = one worklog.
On this page, you can:
- Add time (manually as a single time entry)
- Assign budgets (singularly or in bulk with selected rows)
- Add, edit and save as many of your own "Layouts" as you wish
- Click on editable blue text/links on the page for additional functionality
- Mark worklogs as "Billable" or "Non-Billable"
- Delete selected rows (singularly or in bulk with selected rows)
- Cherry-pick which columns display on the page from the Timetracker database AND your Azure DevOps project
- Ability to see when every worklog was created: when added, optional "Created Date" column displays on Times Explorer, Budgets Export and API.
- Export (worklog details to Excel)
- Import (external time tracked outside of Timetracker from Excel)
- Group worklogs (based on different fields like months, work item ID or users)
- Sort and filter columns (see exactly what you want to see on the page, how you want to see it)
- Resize and move columns (get a better look at the data that is important to you)
- Remove filters (resets all grid filtering/sorting/grouping)
- Assign activity type categories to your worklogs (when enabled by your admin) - Please note that Azure DevOps Activity and 7pace Timetracker Activity Types are separate entities.
"Times Explorer" Page: First Glance
Note: If, when making any changes to worklogs within the grid, below, you receive a message informing you that changes could not be made or that only certain rows updated, this is because you either don't have permissions to the associated work item to which the worklog belongs or it is locked or no longer exists.
Clicking on this button allows you to create a new customizable layout that will be available to you each time you navigate to the "Times Explorer" page:
Once you name your layout, you can customize it to show exactly what data and columns you want to see on the "Times Explorer" page. You can save your column order, column width, filters, groupings, sorting, etc. You can also click on an existing layout, make changes to it, and then click "New Layout" and your changes will be saved as a whole new layout.
List of "Times Explorer" Layouts
When you first navigate to the "Times Explorer" page, you will see a list of pre-configured "Layouts" that display for every user (the screenshot, above, shows pre-configured layouts for an administrator user). You can edit, rename, and/or delete these pre-existing "Layouts" as you choose. If you have already configured your "Times Explorer" page prior to the new "Layouts" feature being introduced, you will see an additional layout added to the list displayed in the above screenshot; "My Layout" will show the "Times Explorer" page as you last customized it before the "Layouts" feature was added.
Note: Pre-configured layouts are created and display per user and depending on the role that user has when they first visit the Times Explorer page. If a regular user accesses the page but then gets increased permissions (like an administrator, for example) later, the admin-specific pre-configured layouts are not added. IMPORTANT: To reset the default layouts on the page, simply delete all existing layouts and reload the page and the default layouts will appear.
The "Layout" section is collapsible. By clicking the "<" icon above the "New Layout" link, the list of layouts can be collapsed to give you more real estate on the "Times Explorer" page.
By clicking the ">" icon, the list of your "Layouts" displays again.
Clicking on this opens the Add Time dialog box so you can manually add time for completed work.
The date range or timeframe of worklog details currently displaying on the Times Explorer page. The grid pre-loads the defined number of rows into the browser's memory for the quickest response time.
By default, the page displays the worklog details for the timeframe that you set in Configuration -> Timetracker System Settings. This timeframe is the total number of months prior to the current date. For more information, see this section of Settings -> Rules.
By clicking this link, you can temporarily change the timeframe of displayed worklog details on the "Times Explorer" page. To learn how an admin can permanently change this, click here.
Timetracker calculates the timeframe in the following way:
The date of the last recorded time in the Timetracker database.
If today's date is
IMPORTANT: If you change the "To" or "From" date range on the calendar-picker, you must specifically click on a date within the calendar because the action of changing the month or year automatically de-selects any date from the calendar. Once you select a specific date within the calendar and click "ok", your selected date range will display in the results.
"Project" dropdown list
You can cherry-pick/check which projects you want to display on the "Times Explorer" page or use the following quick filters:
"All Projects" filter selects only DevOps projects and displays work items with work item IDs associated with them.
"Select All" filter will display all work items from all projects, including non-DevOps items.
When you navigate away from the page, Timetracker remembers your selection(s) when you return.
"Iteration" dropdown list
You can cherry-pick/check which iterations you want to display on the "Times Explorer" page. When you navigate away from the page, Timetracker remembers your selection(s) when you return. The Iteration column filter lists only the iterations where time was tracked on work items within those iterations.
When you click on this button, the "Select Columns to Display" box appears, allowing you to cherry-pick not only columns from the Timetracker database, but also custom columns from your Azure DevOps project.
Note: Some columns (Budgets, Billable and Billable hours) are visible only to user users with Product (and higher) role.
Click "Save" to maintain any changes to the list of columns and the specific details of tracked time you want to display on the "Times Explorer" page as part of your specific "Layout".
The columns on "Times Explorer" page's worklog details table are movable by simply dragging them to display in the order that you prefer.
They are also resizable by simply hovering your mouse to the right of each column header until a double-ended arrow icon displays and then dragging that to the right until the column is the width you prefer. You can also double-click the right column border to auto-resize the column to the maximum size of the content in that column.
Each column allows you to simply click in the field below the column header and enter or select the value you want to filter by and display in the table details.
You can also sort worklogs according to certain fields or columns by clicking the field name in the table header to sort the time details. Click the field name once to sort the time details in ascending order. Click the same field name again to sort the time details in descending order. The column header displays the appropriate icon to indicates the sorting order.
You can also sort by multiple columns. Press Shift + click to sort additional columns after the first one. Press Ctrl + click in a table heading to remove the sorting of a column once multiple columns have been sorted.
You can export worklogs to an Excel file. Before exporting, you can filter the worklogs on the page to suit your needs and then export only those worklogs displaying on the page after matching the filter criteria.
For more information, see Exporting Worklogs.
You can import worklog details that you have tracked outside of 7pace Timetracker, on the "Times Explorer" page.
For more information, see Importing Worklogs.
Clicking this button causes the page to once again display all worklogs, unfiltered.
At the top-right of the "Times Explorer" grid, the total number of worklogs listed and the total number of hours tracked for the listed worklogs display. If you have filtered the columns on the page to only display certain worklogs, this field displays the total number of filtered worklogs and the number of hours for those filtered worklogs.
For example, if the total number of worklogs before you apply filters is 1500 and the total number of hours for these worklogs is 1,150 hours, then this field displays 1500 (1,150 h). If you then filter the columns to view fewer worklogs, and the new total number of filtered worklogs is 750 and the total number of hours associated with those filtered worklogs becomes 350 hours, then this field displays 750 (350 h).
For more information, see Changing the Timeframe of Displayed Worklogs.
"Times Explorer" Page: A Second Look
With each worklog (row) that you select, this field updates - the first number displays the total number of worklogs you have checked/selected and the number in parenthesis displays the total time tracked in hours for those selected worklogs. For example, if you select three rows of worklog details and there is a total of 2.6 hours associated with those selected worklogs, this field will display as 3 (2.6h). If you have no rows selected, it displays as 0 (0 h), as depicted in the screenshot above.
The "Select All/Deselect All" checkbox.
The checkboxes by each row on the page allow you to cherry-pick the worklogs you want to view (with each worklogs you check or uncheck, the rows-selected and hours associated to those rows update in the "0 (0 h)" field at the beginning of the header row - see #1, above). You can also click anywhere on a row on the page and that row is automatically selected and the corresponding checkbox is checked.
When a row is checked, #4, #5, #6, and #7, below, display as options.
This selection only displays when a row or rows are selected/checked. This opens a dialog box that allows you to assign a budget to the checked worklogs.
By default, each work item inherits the budget assigned to the corresponding iteration. However, you can assign different budgets to a specific work item.
The Budget column displays assigned budgets in the following ways:
The Budgets filter list displays the following filter criteria:
For more information, see "Budgets" Page Overview and other articles related to "Budgets".
This selection only displays when a row or rows are selected/checked. You can cherry-pick/select specific worklog details on the page, click on the "Billable" button, and then choose "Mark as Billable". These specific worklogs can then be billed to your customer. Alternatively, you can also click this "Billable" button again and choose "Mark as Unbillable".
Once selected and marked as “Billable”, the billable hours data is then available when you create reports via the “Times Explorer” export, “Budgets” export, and the Reporting API export process.
"Change Activity Type"
This selection only displays when a row or rows are selected/checked and when your administrator has enabled the "Activity Types" feature in "Configuration". When both of these preconditions exist, the "Times Explorer" page displays a "Change Activity Type" button that allows you to select multiple worklogs and assign activity types to them in bulk. Additionally, "Activity Type" also displays as a selection when you click on the "Columns" button. Adding this column allows you to assign activity types to your v one-by-one, or filter and group by activity types like you do with other columns on this page.
For more information, see our Activity Types article.
This selection only displays when a row or rows are selected/checked. You can select multiple rows and delete worklogs in bulk with the "Delete" button.
You can click anywhere in the "Times Explorer" grid, on a row, and the row will automatically be checked/highlighted.
Editable blue links display where further action can be taken by the user. Click on a blue highlighted link and you will be prompted to take additional action if desired.
Making Changes to "Layouts"
When you make edits or changes to any of your "Layouts", (for example, moving a column to a different location, filtering certain rows to view specific time details, or cherry-picking certain columns to display on the page, etc.), those changes are immediately saved in the Timetracker database. If you open the "Times Explorer" page on a different PC or browser, you will still see the page in exactly the same state as you left it. If you make any changes to an existing layout, the "Save" button will display by the name of the layout:
You can then choose to "Save" by simply clicking the button or you can click the () icon to "Rename", "Delete", or "Undo Changes".
If you make changes to a layout and then navigate away from it without saving, you will receive the following prompt:
Work Item Form Integration
On the "7pace Timetracker" tab of the work item form, under "Work Item", an () icon displays next to "Hours" tracked on that work item.
Clicking on it opens its details on the "Times Explorer" page:
Grouping is powerful functionality that exists within the "Times Explorer" page that allows you to filter and group fields within existing worklogs data in a more concise but in-depth way. Each column header within the "Times Explorer" table contains different fields in its dropdown list (for example, the "Month" column header contains the calendar months in the dropdown during which time was tracked). By clicking on the grouping symbol () in the top-right corner of each column header, you can add the column - and subsequently, the fields - you want to group, in the details panel below. The column you group first is the top-level group, and every subsequent grouped column then displays one level below that. You can then get a filtered snapshot of the number of rows and the totals within each group that you create.
1. In the "Times Explorer" table, hover your mouse pointer over the top-right corner of the column header you want to be the top-level group.
2. Click the Add group icon -> The page filters and displays the time details of just that column, grouped accordingly (in this example, below, the "Person" column grouping displays the various Timetracker users and the worklogs associated with them.
Note: You can group time details only for the fields that display the "Add group" () icon by the column header. You can group time details for multiple fields by clicking the respective column headers. Once you group the time details of a specific column, the field names in the column header display the () icon without you having to hover over it.
3. (Optional) Click the group header icon arrow to expand the group and view the worklogs in that group.
4. (Optional) Click the group header icon arrow that points down to collapse group and hide the worklogs in that group.
5. (Optional) Click the Remove Filters button or simply click the grouping ( again to remove the grouping and display all worklog details in the table.
Adding a New Worklog
1. On the "Times Explorer" page, click the Add Time button.
The system displays the "Add Time" dialog box.
Note: The interface of the Add Time dialog box is based on the mode that you set in "Settings" -> "General" ->"Rules". For more information, see Settings: General: Rules
If a 7pace Timetracker administrator has enabled “Prevent Time Entry Against Closed Items” on the “Settings”, in the “Rules” section, if you try to add time to a workitem that is in closed status, the system will prevent you from saving.
The top username field defaults to the logged-in user. As an administrator, this field will display to you as a droplist list that contains team members who have access to 7pace Timetracker. Users with lesser permissions, such as "Team" will only see their own name here.
2. Enter the appropriate values in other fields.
3. Click the Save button.
Editing a Worklog
1. In the worklog details table, click or hover over the pencil () icon for the worklog/row that you want to edit.
Note: The pencil () icon is enabled only for the worklogs that the logged in user has tracked/added/imported unless you have a user role that has been configured to edit/delete the worklogs of others. If the pencil () icon is disabled/grayed out next to a worklog, that means that the workitem to which it belongs is closed and a 7pace Timetracker administrator has enabled “Prevent Time Entry Against Closed Items” on the “Settings”, in the “Rules” section.
If you try to bulk-edit worklogs by selecting multiple checkboxes/worklogs at the same time and some of the workitems of those worklogs were closed, the system will inform you that only "x number of worklogs out of <insert total> were updated".
The system displays the "Edit Time" dialog box.
2. Change the values you wish to change in the required fields.
3. Click the Save button.
Note: If a user is tracking time and edits (removes) the worklog currently being tracked by the Windows Client or the Timetracker Web Client, the system will automatically stop tracking.
Deleting a Worklog
Note: You can only delete the time details that you, yourself, have tracked on the system, however, an administrator can enable the option on the "Settings" page to allow another user role to edit or delete worklogs as well. For more information, see Settings: General: Rules
You can delete time two ways on the "Times Explorer" page.
1. To delete multiple worklogs simultaneously, in the worklog details table, select the worklogs that you want to delete by clicking on the checkboxes by the specific rules.
The "Delete" button is enabled on the toolbar.
2. You can either click the Delete button or you can also click the bin () icon for the worklogs that you want to delete.
Note: The bin () icon is enabled only for open worklogs that the logged in user has tracked unless you belong to the user group that has been configured to edit/delete time. If the bin () icon is disabled/grayed out next to a worklog, that means that the workitem to which it belongs is closed and a 7pace Timetracker administrator has enabled “Prevent Time Entry Against Closed Items” on the “Settings”, in the “Rules” section. If you try to bulk-delete worklogs by selecting multiple checkboxes/worklogs at the same time and some of the workitems of those worklogs were closed, the system will inform you that some of the worklogs can't be deleted and once you continue, you'll receive a message that only "x number of worklogs out of <insert total> were deleted".
If a user is tracking time and edits (removes) the worklog currently being tracked by the Windows Client or the Timetracker Web Client, the system will automatically stop tracking.
Changing displayed time worklogs temporarily
By clicking on the "Change Dates" link on the Times Explorer page, team members can temporarily change the date range of displayed worklog details. If that team member visits another page within Timetracker, however, and returns to the "Times Explorer" page, that temporary setting will return to the configured setting. This configured date range can be changed more permanently by an administrator within Timetracker's settings. We will show you how to do both, below.
1. On the 7pace Timetracker menu bar, click Times Explorer.
2. Click the Change Dates link.
Side-by-side calendars display:
3. On the left-side calendar, select the From date.
4. On the right-side calendar, select the To date.
5. Click the OK button.
The date range of displayed worklogs is updated temporarily on the "Times Explorer" page.
Changing displayed time worklogs permanently
Note: You have to have an administrator user role to do this.
1. On the 7pace Timetracker menu bar, click Settings -> Rules.
2. Under Times Explorer Preloaded Timeframe, type in the preferred number of months you want to be preloaded on the "Times Explorer" page prior to the current month.
The page refreshes automatically and the changes are saved. "Times Explorer" will now always show this date range on the page when you and your team members navigate to that page.
Single-Assigning a Budget
On the Times Explorer page, on the row/worklog to which you want to assign a budget, under the Budget column, click by "NA" or the name of the already-assigned budget if you want to change it.
When the list of budget names populate/display, click on the budget you want to assign to the worklog.
The selected budget is verified and assigned to the specific worklog.
To assign a budget to multiple worklogs, select multiple rows or worklogs. When you do this, additional menu items display on the toolbar next to the "Add Time" button, including the "Assign Budget" button:
When you click the Assign Budget button, the "Assign Budget" dialog box displays a list of configured budgets.
In the Title column, click the budget name that you want to assign and click "Assign to selected". The bulk budget assignment confirmation dialog box will display, asking you if you'd like to continue. If a 7pace Timetracker administrator has enabled “Prevent Time Entry Against Closed Items” on the “Settings”, in the “Rules” section, you’ll receive a message from the system that not all worklogs can't be updated.
When you click the Assign button, the Budget column now displays the chosen budget for the selected worklogs (that are not in a closed state).
Removing a Budget
To remove a budget from a worklog, select the worklog/row or highlight it with your mouse. In the Budget column, but still within the same row, click the budget name so that the list of budgets display.
In the budgets list, click the [Inherited budget] budget. The previously-assigned budget for the selected time worklog is removed.
Note: If the budget of the parent work item or the iteration is removed, the worklog, which inherits that budget, will display NA in the Budget column.
If a budget name is preceded by an exclamation mark (!), this indicates that the budget assigned to the work item is different than the budget assigned to the iteration of that work item. It displays if the work item is not inheriting the budget from the iteration.
To import worklogs that you've tracked outside of 7pace Timetracker, you simply copy data from the source application (like Excel) and paste it into the "Import Times" popup window of the Times Explorer page. You then associate each worklog detail to the specific field in the Timetracker database. Once verified, the imported worklogs are stored in our database.
Import can be performed via the UI, but it can also be performed by using the workLogs endpoint from our REST CRUD API and also our NPM package.
If the system finds any errors, the import process will stop and the errors will display for you to correct before attempting to import again.
1. On the 7pace Timetracker menu bar, click Times Explorer.
2. On the Times Explorer page, click Import.
The Import Times page displays:
3. Paste time details that you copied from the source application (like Excel).
4. Click the Next button.
Timetracker analyzes the data that you pasted and displays it in a tabular format so you can properly associate each time detail in the column headers to the appropriate Timetracker field.
5. (Optional) In the far-left column, check the boxes for the time details you want to import. By default, all are selected.
6. Select the "Date Format" and the "Time Format" of your preference for the import.*
*Note: If you'd like to customize or change the format for your import, please find additional information at this link - Custom Date and Format Strings - and/or simply use the most popular formats (we used standard .NET Framework DateTime object format settings):
Basic Format Specifiers:
dd: day of month
h: hour in format 1-12 without leading zero
hh: hour in format 1-12 with leading zero
H: hour in 24h format without leading zero
HH: hour in 24h format with leading zero
mm: minutes with leading zero
tt: am/pm designator
Templates for Date/Time Formats
|Date Format||Time Format|
7. Copy-paste the Date Format and Time Format of your choice into the corresponding fields.
8. In the Column Name headers, click the dropdown arrows on each and select the appropriate header names for the time details below.
9. Click the Import Now button.
While importing, if there are any issues with the data, those issues will be highlighted and an error message will display.
10. (Optional) Check "Rows With Errors Only" to see just the rows that are causing issues in your import.
11. (Optional) After correcting your errors, if any, click the Import Now button again.
Once the time details are successfully imported, you can view these details on the "Times Explorer" page.
You can export worklogs to an Excel file that will have the following naming convention format:
Before exporting, filter the worklogs on the page to suit your needs and then export only those worklogs displaying on the page after matching the filter criteria.
1. On the 7pace Timetracker menu bar, click Times Explorer.
2. (Optional) Filter the worklogs as per your requirements.
3. On the toolbar, click the Export to Excel button.
The browser downloads the Excel file containing the worklogs shown on the "Times Explorer" page.