What function can be used in place of NOW() that won't keep changing the time? Thank you
K kdsteff Mar 7, 2007 #1 What function can be used in place of NOW() that won't keep changing the time? Thank you
B Bob Umlas, Excel MVP Mar 7, 2007 #2 Ctrl/; then space then ctrl/: that puts in the date & time as constants. If you only want the time, just use ctrl/:
Ctrl/; then space then ctrl/: that puts in the date & time as constants. If you only want the time, just use ctrl/:
D Dave Peterson Mar 7, 2007 #3 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
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
K kdsteff Mar 7, 2007 #4 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.
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.
