Hi,

I need a help in creating a formula :


COMPLETION TIME TARGET ACHIEVED
10:23
12:20
13:30
14:01
15:00

two seperate colums one for completion time and another for target
acheived. I need a formula in the target acheived column.

If the time completion is before 14:00 the target achieved should be
100%. if it corsses 14:00 then the target acheived should be 0%.

Cheers,
Sathish


--
Sathisc
------------------------------------------------------------------------
Sathisc's Profile: http://www.thecodecage.com/forumz/member.php?userid=187
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=77749