10 Mar 2016 at 09:40 #1 Colbaker Colbaker Associate Joined 8 Dec 2004 Posts 1,970 Location Paignton, Devon Hi all. What I want is a cell that says good morning or afternoon depending on what the time is. Can this be done? Thanks guys
Hi all. What I want is a cell that says good morning or afternoon depending on what the time is. Can this be done? Thanks guys
10 Mar 2016 at 09:56 #2 WillyNelson WillyNelson Soldato Joined 28 Oct 2003 Posts 5,510 Location Worthington-on-sea =IF(HOUR(NOW())<12,"Good Morning","Good Afternoon")