? enter a static time (Excel) in a cell using the IF function
 

Is a macro ok?

Take a look at JE McGimpsey's site:
http://www.mcgimpsey.com/excel/timestamp.html

pmcfs111 wrote:

I am trying to automatically enter a static time into a cell based on another
cells content. I have discovered that the NOW() does not work and it defeats
my purpose to use "Ctrl Shift + ;" Any help would be appreciated, thanks

--

Dave Peterson