Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
What function can be used in place of NOW() that won't keep changing the time?
Thank you |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|