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

surely

=if(now()-int(now())<.5,"Good Morning",if(now()-int(now())<.75,"Good
Afternoon","Good Evening"))

is simpler?!


"SteveG" wrote in
message ...

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