Forum Discussion
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...
That's really to less on information.
Please post table design as DDL, some sample data as DML statement and the expected result.
Please post table design as DDL, some sample data as DML statement and the expected result.