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

  • Thread starter Thread starter pmcfs111
  • Start date Start date
P

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
 
You will have to go for a VBA solution....making use of the worksheet change
event.

If this post helps click Yes
 
Back
Top