Dear All

I have a worksheet which has a start time and an end time for visits
throughout the week, Some lines however are blank

I want a formula which tells me if the end of the visit is before 9.30 am to
return "morning", if its before 17:00 then return "Afternoon", if its before
23:30 return "Evening" and if its blank return "Ignore"

Could anyone help me please ?

D

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