Time to column
Item level
Text column
When a time entry is created/updated/deleted, add total (billable) time of an item in this time format to this item text column
This integration automatically updates the selected text column with the total selected time type of all time entries that are logged on the monday.com item, whenever a time entry with that item is created, updated or deleted. The integration will take the sum of all those time entries' time, format it to your chosen time format, to then overwrite the text column's value.
This integration is useful if you want to get a quick overview of the total time logged on an item.
Number column
When a time entry is created/updated/deleted, add total (billable) time of an item in this number format to this item number column
This integration automatically updates the selected number column with the total selected time type of all time entries that are logged on the monday.com item, whenever a time entry with that item is created, updated or deleted. The integration will take the sum of all those time entries' time, format it to your chosen time format, to then overwrite the number column's value.
This integration is useful if you want to get a quick overview of the total time logged on an item. Moreover, the number column allows you to use those values for further calculations (with a formula column for example), as well as reports and dashboards in monday.com.
Subitem level
Text column
When a time entry is created/updated/deleted, add total (billable) time of a subitem in this time format to this subitem text column
This integration automatically updates the selected text column with the total selected time type of all time entries that are logged on the monday.com subitem, whenever a time entry with that subitem is created, updated or deleted. The integration will take the sum of all those time entries' time, format it to your chosen time format, to then overwrite the text column's value.
This integration is useful if you want to get a quick overview of the total time logged on a subitem.
Number column
When a time entry is created/updated/deleted, add total (billable) time of a subitem in this number format to this subitem number column
This integration automatically updates the selected number column with the total selected time type of all time entries that are logged on the monday.com subitem, whenever a time entry with that subitem is created, updated or deleted. The integration will take the sum of all those time entries' time, format it to your chosen time format, to then overwrite the number column's value.
This integration is useful if you want to get a quick overview of the total time logged on a subitem. Moreover, the number column allows you to use those values for further calculations (with a formula column for example), as well as reports and dashboards in monday.com.
Time options
You can decide what "type" of time you want to write to a column. The available options are:
Time
Billable time
Non-billable time (= total time - billable time)
Approved time
Approved billable time
Approved non-billable time
Column formats
Column integrations require you to select in which format you want to see the total logged time. There are different formats for the two column types.
Text formats:
days/hours/minutes format (1d 2h 30m),
hours/minutes format (10h 30m),
hh:mm format (10:30),
dd:hh:mm format (1:2:30).
Number formats:
minutes (integer) (630),
hours (decimal) (10.5),
days (decimal) (1.3).
Last updated
Was this helpful?