Hi,
I did search tek-tips for answers but was not able to find anything BUT if the answer already exists, could someone guide me to the thread please?
I have
Work Start (Datetime)
Work Stop (Datetime)
When a resolver group starts working on a ticket, the datetime gets stored in the Work Start and when the ticket is resolved, the datetime gets stored in the Work Stop
To calculate the resolution time, I simply do Work Stop - Work Start BUT if the resolver starts working on the ticket at 4:05PM and resolves it the next day at 8:30, I would like the resolution time to show 55 minutes because the business hours are 8:00 to 5:00 PM.
How do I do this?
I would also like to do the same for the weekend (not count the weekend) and holidays.
Can someone help?
Thank you
Jocelyne
I did search tek-tips for answers but was not able to find anything BUT if the answer already exists, could someone guide me to the thread please?
I have
Work Start (Datetime)
Work Stop (Datetime)
When a resolver group starts working on a ticket, the datetime gets stored in the Work Start and when the ticket is resolved, the datetime gets stored in the Work Stop
To calculate the resolution time, I simply do Work Stop - Work Start BUT if the resolver starts working on the ticket at 4:05PM and resolves it the next day at 8:30, I would like the resolution time to show 55 minutes because the business hours are 8:00 to 5:00 PM.
How do I do this?
I would also like to do the same for the weekend (not count the weekend) and holidays.
Can someone help?
Thank you
Jocelyne