Hi All,
Belated Diwali Wishes.
I have to Calculate Turn Around Time Missed or Not Missed. For this i have two File. One is Master and the other is Transaction table. In Master I have Start Time with Work Center No. There is also a Condition that if the Start time is always to be in Same day and the time Between 7 am to 4 PM. If that Crosses 4 PM, Then the Date will be consider for next working day. ie. If next day is Sunday or Holiday then we have to consider next working day. End time to be taken from transaction table and this is also has to be taken in the Same method. ie. Based on Sunday or Holiday. If the Time taken between Start time and End time > 48 hours then TAT Missed or TAT Not Missed. Please help ASAP. To be deliver on 02-11-2016.
Thanks and Regards,
Sakthivel.S
