Búsquedas recientes
No hay búsquedas recientes

Kaushik Chanda
Incorporación 13 may 2021
·
Última actividad 16 oct 2021
Seguimientos
0
Seguidores
0
Actividad total
2
Votos
0
Suscripción
1
RESUMEN DE LA ACTIVIDAD
INSIGNIAS
ARTÍCULOS
PUBLICACIONES
COMENTARIOS DE LA COMUNIDAD
COMENTARIOS DE ARTÍCULOS
RESUMEN DE LA ACTIVIDAD
Última actividad de Kaushik Chanda
Kaushik Chanda hizo un comentario,
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.
Ver comentario · Publicado 16 feb 2021 · Kaushik Chanda
0
Seguidores
1
Voto
0
Comentarios