Now function
 

I would like to use the now function to record the current system time with
seconds, but I do not want this function to update when I type another
instance of the now function. I need seconds so using ctrl+shift+; does not
work. Is there a short cut or syntax that I can use to keep the now function
static?

Now function
 

=NOW() (press F9 instead of ENTER)


"Albie" wrote:

I would like to use the now function to record the current system time with
seconds, but I do not want this function to update when I type another
instance of the now function. I need seconds so using ctrl+shift+; does not
work. Is there a short cut or syntax that I can use to keep the now function
static?

Now function
 

Hi Albie,

This might be what your looking for...

http://www.mcgimpsey.com/excel/timestamp.html

Regards,

Gav.

"Albie" wrote:

I would like to use the now function to record the current system time with
seconds, but I do not want this function to update when I type another
instance of the now function. I need seconds so using ctrl+shift+; does not
work. Is there a short cut or syntax that I can use to keep the now function
static?

Now function
 

Awsome, I was hoping there was something simple like that.

"Teethless mama" wrote:

=NOW() (press F9 instead of ENTER)


"Albie" wrote:

I would like to use the now function to record the current system time with
seconds, but I do not want this function to update when I type another
instance of the now function. I need seconds so using ctrl+shift+; does not
work. Is there a short cut or syntax that I can use to keep the now function
static?