There are several errors, first the times are not seen as times you can
replace them with TIME(,,1) for one second for instance and 1 minute with
TIME(,1,)
The formula construction is also erroneous since the first condition will
block all the other as well

=IF(D4TIME(,5,),"Word 3",IF(D4TIME(,1,),"Word 2",IF(D4TIME(,,1),"Word
1","")))


or

=IF(AND(D4<=TIME(,1,),D4TIME(,,1)),"Word
1",IF(AND(D4<=TIME(,5,),D4=TIME(,1,)),"Word 2",IF(D4TIME(,5,),"Word
3","")))


or

=VLOOKUP(D4,{0.0000231481481481481,"Word 1";0.000706018518518518,"Word
2";0.0034837962962963,"Word 3"},2)


--


Regards,


Peo Sjoblom





"Lester Mosley" wrote in message
ps.com...
I am tyring this:

=IF(D40:00:01,"Word 1",IF(D40:01:00,"Word 2",IF(D40:05:00,"Word
3","")))
When the user puts in a time in Cell D4 - I want it to display in D5

I get errrors on this time.. How would I go about this?

Appreciate any help