Using formula field in time tracker

#1

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?

#2

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.

#3

Oh i see. I misunderstood that time tracker is something like reminder.
Thank you for answering!

#4

Check this for reminders: