Time formula

Giganews Newsgroups
Subject: Time formula
Posted by:  dd
Date: Fri, 3 Aug 2007


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


If I complete the activity at 09:30 AM

It should give me : ACHIEVED