Hi Pete,

I have incorporated the formula as per your instructions, however, even
though the time formats are same it is not giving me the desire results.

Could you please help me with this?

Thanks,
DD

"DD" wrote:

Hi,

I wish to incorporate a formula, by which I can find out whether the
activity is completed within the deadline or not.

For Eg:

My deadline for a particular activity is : 10:00 AM

I completed this activity at : 10:30AM

It should give me : MISSED

OR

If I complete the activity at 09:30 AM

It should give me : ACHIEVED