What can we help you with?

The Time Tracking Column

Wondering how much time you spend on each task? You now have the ability to track it with the time tracking column! ⏰

Note: This feature is only available for the Pro and Enterprise plans.

 

 

How to add the Time Tracking Column

To add it, click on the + icon located on the top right of your board and select "More columns".

image_2__7_.png

 

Once in the column center, select the option "time tracking" as in the screenshot below:

timetracking2_en-us.png

 

How the Time Tracking Column works

Whenever you start a task, simply click on play to start the timer. You can pause it anytime and start it again. 

timetracking3_en-us.png

Note: The timer activity of each item can be found in the Activity Log.

 

You can also choose to add in a range of time manually by clicking into a cell within the Time Tracking Column and selecting 'Add session manually':

Frame_1__81_.png

Note: Keep in mind that you can't enter future values!

 

How to get a Time Tracking log history

Clicking into a specific time tracking cell will open the Timeline history and log.

timetracking4_en-us.png

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.

timetracking5_en-us.png

Hovering over an entry in the time tracking log will reveal an X to the right of the time, allowing you to delete the entry if you wish. 

 

Tracking time in Subitems

If your items or tasks have smaller steps within them which need to have their time tracked, you may consider adding the Time Tracking Column within the Subitems on your board! In order to do this, simply open up a Subitem and add in the Time Tracking Column just as you would for a normal item on your board.

image_1__30_.png

 

Get a visual overview of time tracked in the Subitems

In order to easily see a summary of the total time tracked within the subitems, you can choose to aggregate the subitem time tracking column data directly into the parent item. To do this, open up the Time Tracking Column settings from within the Subitems, and select "Show Summary on Parent Item":

captured__93_.gif

 

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.

timetracking6_en-us.png

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.

timetracking7_en-us.png

 

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.

timetracking8_en-us.png

This option will export only the details of this specific item to an Excel spreadsheet.

timetracking9_en-us.png 

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. 

Note: ROUND(MULTIPLY(({Billable}/3600),{Hourly Rate}),1)

 

timetracking10_en-us.png

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 support@monday.com