TAT Calculation

[pramodagroiya]

Hi, see if this formula does the trick in calculating the TAT:
=(NETWORKDAYS(B2,F2)-1)*("18:30"-"09:30")+IF(NETWORKDAYS(F2,F2);MEDIAN(MOD(F2,1),"1 8:30";"09:30"),"18:30")-MEDIAN(NETWORKDAYS(B2,B2)*MOD(B2,1),"18:30","09:30 ")

The formula to check f TAT is realized is:=IF(G2*24>4,"No","Yes")

Hi Joris,

thanks for help but this formulla is not working, giving #Value error.

Regards,
Pramod Kumar

[Excel Fox]

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.

[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