Time tracking - What am I doing wrong?

[Riccardo]

Hey everyone, 

Reaching out to ask for some help regarding an automation I have set up to track automatically the time once a task is moved to Done. 

Let me quickly guide you.

My board has the following columns

To Do
In Progress
PR
QA
Done

I have created a custom field called "Starting date" that has a date & time type.

When an issue (sub-tasks) is transitioned from To-Do to either In Progress or QA ("Validation" subtasks goes always from To-Do directly to QA, that's why) a Starting Date is automatically populated with {{now}}.




This seems working, but the problems come afterward. I want to log automatically time making the calculation using this automation described above.



This seemed working until I started noticing that for tasks that are moved after a few days, the calculation is quite off. Let's take this task for example.



This task has been picked up on the 19th of December at 16:00 (correct). And moved to do on the 20th in the morning. The time logged is 18 hours and 42 minutes. How is that possible? Does this take into account extra office hours? Is there any way I can account only the working hours or deduct them automatically from the calculation? 



Any suggestion is appreciated.

[John Funk]

Hi Riccardo,

It looks like you might have to use businessDays instead of minutes. This will probably result in a decimal, but that should still work for logging time.