I’d like to calculate duration by due date and current time like DATETIME_DIFF(Date, NOW()) and refer it from time tracker. However, this field is not selectable in time tracker. Of cource i configured format type to duration.
Does anyone know how to use formula in time tracker?
The Time Tracker block measures the duration and sets it in a Duration field, and optionally fill the Start Date (and Time).
You can’t use the block to calculate time from now to due date, the formula you typed already does that :thinking: . You can’t use that field in the Time Tracker because it is not a Duration type field, it’s a Formula type.
