Dear Sunder,
Please use..
*=IF(A3=TIMEVALUE("10:00:00 AM"),"Meet the TAT",IF(A3=TIMEVALUE("03:00:00
PM"),"Not Meet the TAT",""))*
On Thu, Jul 19, 2012 at 1:02 PM, Sundarvelan N wrote:
> Hi Friends,
>
> Please help me in calculating the TAT
>
> If my registration is 9 A.M
>
> and the despatch t
Hi ,
Kindly use below formula.
despatch Time
Acutal despatch Time
TAT Status
Formula 7/18/12 9:00 AM 7/18/12 10:00 AM TAT Meet =IF(TEXT(C2,"hh")="10","TAT
Meet","TAT not Meet") 7/18/12 9:00 PM 7/18/12 3:00 PM TAT not Meet
=IF(TEXT(C3,"hh")="10","TAT
Meet","TAT not Meet")
Regards
Amre
Hi Friends,
Please help me in calculating the TAT
If my registration is 9 A.M
and the despatch time is 10 A.M - Met the TAT
IF the despatch time is 3 P.M - Not Me the TAT
Thanks
N.Sundarvelan
9600160150
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate th
