Ricerche recenti
Nessuna ricerca recente

Kaushik Chanda
Data ingresso 13 mag 2021
·
Ultima attività 16 ott 2021
Seguiti
0
Follower
0
Attività totali
2
Voti
0
Abbonamento
1
PANORAMICA ATTIVITÀ
BADGE
ARTICOLI
POST
COMMENTI NELLA COMMUNITY
COMMENTI AGLI ARTICOLI
PANORAMICA ATTIVITÀ
Ultima attività di Kaushik Chanda
Kaushik Chanda ha commentato,
Hello,
Is there a way I can get the duration in business hours between 2 status changes directly from Zendesk reports please?
Example: Audit log-
New to Pending - 2021-01-06 T16:42:33
Pending to Open - 2021-01-08 T03:30:07
Open to Solved - 2021-01-08 T17:39:37
I basically want to get the duration the ticket was sitting in 'Open' status. So basically the difference of time b/w 2021-01-08 T17:39:37 & 2021-01-08 T03:30:07.
If I need to do the calculation in excel, the data should be sorted and then getting duration in business hours (excluding weekends, holidays etc) in another complication to handle.
Can you help me figure this out please?
Thank you!
Kaushik Chanda.
Visualizza commento · Data ultimo post: 16 feb 2021 · Kaushik Chanda
0
Follower
1
Voto
0
Commenti