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