View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default Greeting Function


edward,

I typed in my cut off times in A1:A3 (12:00:00 AM, 12:00:00 PM, 6:00:00
PM respectively).

=IF(AND(TIMEVALUE(TEXT(NOW(),"hh:mm:ss"))=A1,TIME VALUE(TEXT(NOW(),"hh:mm:ss"))<A2),"Good
Morning",IF(AND(TIMEVALUE(TEXT(NOW(),"hh:mm:ss")) =A2,TIMEVALUE(TEXT(NOW(),"hh:mm:ss"))<A3),"Good
Afternoon","Good Evening"))

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=555043