If your target time is in A1 and actual time is in B1 (both in Excel
time formats) then put this formula in C1:

=IF(B1="","",IF(B1<=A1,"Achieved","Missed"))

Hope this helps.

Pete

On Aug 3, 12:38 pm, 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