Wondering how much time you spend on each task? You now have the ability to track it with the time tracking column! ⏰
How to add it?
To add it, click on the + icon located on the top right of your board and select "more columns".
Once in the center, select the option "time tracking" as in the screenshot below:
How does it work?
Whenever you start a task, simply click on play to start the timer. You can pause it anytime and start it again.
If you would like to clear your timer and start over again, simply click on the "X" located on the right of the time.
How to get a Log History?
Clicking a specific time tracking cell will open the Timeline history and log.
You can easily view the progress of each task and the time intervals. All of the entries can be manually edited. Just click on the time and you will have the option to enter a different time and date. Edited values will turn red.
Hovering over the entry will also provide the ability to delete it. You can also add a new entry using the sign.
How to Export the Time Tracking Column to Excel?
To export the entire Time Tracking column to Excel, click the column menu dropdown and select "Export Column Data to Excel." This will allow you to export the entire column's data to one spreadsheet for easy reporting.
When exporting the entire column to Excel, you will see all details, including item name, user that recorded the time tracking, and time totals on both an item and board level.
You also have the option to export single items within the Time Tracking column to Excel rather than the entire column. To do so, click on the item within the Time Tracking column and select "Export to Excel" at the top right of the Time Tracking window.
This option will export only the details of this specific item to an Excel spreadsheet.
To learn more about importing and exporting from Excel, check out this article.
Calculations with the time tracking column
Our formula column supports the time tracking column. This is particularly useful if you need to calculate the time remaining or the billing rate.
To learn more about the formula column, check out this article.
If you have any further questions, feel free to reach out to our customer success team at [email protected].