=IF(C2=TIME(3,30,0),"ABC",(IF(C2=TIME(4,30,0),"DEF ",(IF(C2=TIME(5,30,0),"GHI","FL")))))

If C2 is the result of a calculation, be aware that if it is off only
1/100000 of a second, your comparisons will not evaluate to TRUE

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Issam LAdki" wrote in message
...
Can somebody help please.
I am trying to enter this formula but something does not seem to work.

Cell C2 containes a time data in the format HH:MM:SS
i am trying to enter in cell D2 the following formula:
=IF(C2=03:30:00,"ABC",(C2=04:30:00,"DEF",(C2=05:30 :00,"GHI","FL")))

This does not seem to work with time, though it does work with general
numbers.

Thanks in advance