The time tracking column represents the total time spent on a task. This column is partially supported by our API, so you can read the time tracking column via the API but cannot update it.

Reading the time tracking column

You can return the data in a time tracking column in two different formats. The text field will return the data as a simple string that displays the total time in HH:MM:SS format. The value field will return the data as a JSON string that shows all the data inside. This post from the developer community lists all of the keys in the value field.

{
  "value": "{\"running\":false,\"duration\":3600,\"startDate\":1659715755,\"additional_value\":[{\"id\":262839901,\"account_id\":12695383,\"project_id\":2973227079,\"column_id\":\"time_tracking\",\"started_user_id\":31855020,\"ended_user_id\":31855020,\"started_at\":\"2022-08-05T15:09:00Z\",\"ended_at\":\"2022-08-05T16:09:00Z\",\"manually_entered_start_time\":true,\"manually_entered_end_time\":true,\"manually_entered_start_date\":true,\"manually_entered_end_date\":true,\"created_at\":\"2022-08-05T16:09:15Z\",\"updated_at\":\"2022-08-05T16:09:15Z\",\"status\":\"active\"}]}",
  "text": "01:00:00"
}

📘

Have questions?

Join our developer community! You can share your questions and learn from fellow users and monday.com product experts.

Don’t forget to search before opening a new topic!