need query for TAT report .. i Need total working hours only on office hours i.e, 09:00 to 06:00 if time is more that 6:00 the adjust the time to next day starts from 09:00 and also include public holidays . if there is any public holiday then time should add to next day of holiday
need query with example
New contributor