Calculating Business Days

Respondida

19 de maio de 2022 19:00

Hi,

Does anybody know how to calculate business days between a tickets "Created date" and "Resolution Date"? I need to report on this. I see "full resolution - business hours" but nothing to do with business days. Right now I pull the two dates and have to calculate in Excel. I'd love to be able to NOT have to manipulate the data in Excel.

1 Comentários

Gab Guinto
- 28 de maio de 2022 04:51
Zendesk Customer Care
Hi Jay,

A workaround is to divide the value of the full resolution time business hours metric by 24 to get the the number of business days. Here's a sample metric formula:
```
VALUE(Full resolution time - Business hours (hrs))/24
```
0

Por favor, entrar para comentar.

1 Comentários

Não encontrou o que estava procurando?