Calculating Business Days

Beantwortet

19. Mai 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 Kommentare

Gab Guinto
- 28. Mai 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

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.

1 Kommentare

Sie haben nicht gefunden, wonach Sie suchten?