Time formula

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

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

Replies