Thank you both for the repsonses, between the two I got it nailed.

Thanks for your time.

D


David Biddulph wrote:
=IF(A2<TIME(9,30,),"morning",IF(A2<TIME(17,,),"Af ternoon",IF(A2<TIME(23,30,),"Evening",IF(A2="","Ig nore","After
evening"))))
I am assuming that your cells contain just a time, not a date and time. If
the latter, replace each instance of A2 in the formula by MOD(A2,1).
--
David Biddulph

Dear All

[quoted text clipped - 10 lines]

D

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1