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

[pmcfs111]

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

 

[Jacob Skaria]

You will have to go for a VBA solution....making use of the worksheet change
event.

If this post helps click Yes

 

[Dave Peterson]

Is a macro ok?

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