Possibility to automate time tracking of task to count only hours of working days

Hello guys!

We want to control SLA from some tasks from ours sales engineer. I want to create a automation that when the task status is Working, trigger the time tracking to count working days until the status changes to Done.

Thank you :smiley:

@amanda.borges,

You can use this automation to start and stop a Time Tracking column:
image

However, converting this to working days is not so simple. Starting with a formula like β€œ{Time Tracking#Hours}/24” would give you something akin to days. But this would not account for weekends, holidays, or working times.

If you use this automation:
image

to set a start date and end date when the status changes to β€œWorking” and β€œDone” respectively.

This formula will give you workdays (not accounting for holidays): WORKDAYS({End Datd }, {Start Date})

Jim

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.