Skip to main content

Using formula field in time tracker

  • February 25, 2019
  • 3 replies
  • 61 views

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?

This topic has been closed for replies.

3 replies

Forum|alt.badge.img+17

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.


  • Author
  • New Participant
  • February 26, 2019

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.


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


Forum|alt.badge.img+17

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


Check this for reminders: