Just to be different:

=IF(NOW()<TIME(12,0,0),"Good Morning",
IF(NOW()<TIME(18,0,0),"Good Afternoon","Good Evening"))

It might make changing those cutoff times a little easier.

"T. Valko" wrote:

Well, it depends on when evening starts.

How about this:

12:00 AM to 11:59 AM = Good Morning
12:00 PM to 5:59 PM = Good Afternoon
6:00 PM to 11:59 PM = Good Evening

=IF(MOD(NOW(),1)<0.5,"Good Morning",IF(MOD(NOW(),1)<0.75,"Good
Afternoon","Good Evening"))

--
Biff
Microsoft Excel MVP

"Wesley" wrote in message
...
Been working on this for hours and just can't seem to figure it out.

TIA

Wesley

--

Dave Peterson