=LOOKUP(A1*24,{0,8,16},{"Early","Day","Late"})

Works for me.

A1 = 8:00 AM

Formula returns Day.


--
Biff
Microsoft Excel MVP


"Rick Rothstein (MVP - VB)" wrote in
message ...
That will assign 08:00 to Early rather than Late (see my follow up
posting).

That should have said...

"That will assign 08:00 to Early rather than DAY" (emphasis added).

Rick