Sathisc;278308 Wrote:
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
Welcome to The Code Cage!

Are your cells formatted as time or have you entered times as text?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=77749