Thread: Date Validation to get perfect TAT

Hi,

I have the data in the excel sheet, please find the attached file Time Management.



I guess it can be done with the help of Conditional format or by IF Function or by the VB but am not sure how to do..

Please suggest if you have a solution. I am really very Sad...

Thanks to all for the help.

Thank you...
...Marc Simpson

Please help me..

SHG Sir Good Morning

Simply i m looking for TAT (Turn Around Time), D5 is received time and E5 is completed time, in case, if file should be ON HOLD, user cant update the completed time that should be "Pending" And user update the date and time in Column G5 (Search Hold Start Time), Once if search received used update the search received time in H5. So now TAT Between H5-D5 Received time and search end time. else E5-D5 Completed time = E5, and Received time = D5.

Sir, now did you get my point...

Sir Once again i attached file, and i hope now you can understand what i want..

Thank you
Marc