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?