TAT Calculation

[pramodagroiya]

If what I asked is correct, then you could validate the TAT compliance using this formula

=IF(MOD(B2,1)>TIME(18,30,0),F2-WORKDAY(B2,1)+TIME(9,30,0),F2-B2)<=TIME(4,0,0)

But if you are looking for something else, let me know.

Hi,

Thanks this was really a great help, i really appreciate your efforts. earlier it took me hours to calculate the data, but now with this i can calculate thousands to rows within a minutes.

thanks once again.

Regards,
Pramod Kumar