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. 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 cells 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 Exolporer, 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)
"Times Explorer" Page: First Glance
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 (but can be created manually by the user).
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. 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.
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 "Times Explorer": Exporting Worklogs.
You can import worklog details that you have tracked outside of 7pace Timetracker, on the "Times Explorer" page.
For more information, see "Times Explorer": 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 "Times Explorer" Page: 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:
- "Times Explorer": Grouping Worklog Details
- "Times Explorer": Adding, Editing or Deleting a Worklog
- "Times Explorer" Page: Changing the Date Range of Displayed Worklogs
- "Times Explorer" Page: Single, Bulk-Assigning and Removing Budgets
- "Times Explorer": Importing Worklogs
- "Times Explorer": Exporting Worklogs
- "Times Explorer" (Personal Data Only) Page Overview
- "Activity Types"