Recent searches


No recent searches

Kaushik Chanda's Avatar

Kaushik Chanda

Joined May 13, 2021

·

Last activity Oct 16, 2021

Following

0

Followers

0

Total activity

2

Votes

0

Subscription

1

ACTIVITY OVERVIEW

Latest activity by Kaushik Chanda

Kaushik Chanda commented,

CommentBuilding reports

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.

View comment · Posted Feb 16, 2021 · Kaushik Chanda

0

Followers

1

Vote

0

Comments