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