Forum Discussion
singh71824
Feb 24, 2024Copper Contributor
How to calculate days a ticket is open/closed?
I want to calculate a TAT (turnaround time), which will give me the effective business hours in which the ticket came and closed.
for this, consider the following criteria
1. Shift starts from 6:00 am Monday and ends on the next day at 3:00 am
2. The working days are Monday to Friday.
3. The cut-off time is 3:00 am to 6:00 am which is nonbusiness hours.
so I want to calculate the TAT for:-
a) Coming in on Monday and closing on Wednesday and
b) another ticket coming on Friday and closing on Monday.
Kindly provide a valuable solution, I want to perform this activity in an SQL database.
- olafhelperBronze ContributorThat's really to less on information.
Please post table design as DDL, some sample data as DML statement and the expected result.