What function can be used in place of NOW() that won't keep changing the time?

Thank you

Ctrl/; then space then ctrl/:
that puts in the date & time as constants. If you only want the time, just
use ctrl/:

"kdsteff" wrote:

What function can be used in place of NOW() that won't keep changing the time?

Thank you

ctrl-;
will insert a static date

ctrl-:
or ctrl-shift-;
will insert a static time.

If you want a cell changed when something in the same row (say) changes, you
could use an event macro like the one that JE McGimpsey shares:

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

kdsteff wrote:

What function can be used in place of NOW() that won't keep changing the time?

Thank you

--

Dave Peterson

But how can that be done automatically such as in a function so one could
track employee break in and out time hidden on another worksheet.

"Bob Umlas, Excel MVP" wrote:

Ctrl/; then space then ctrl/:
that puts in the date & time as constants. If you only want the time, just
use ctrl/:

"kdsteff" wrote:

What function can be used in place of NOW() that won't keep changing the time?

Thank you