How do I make the now() static and not change with calculation?

G

Guest

I want to get a computer time if certain conditions are met using the now()
function. Once the now() gives the day and time, I want to have that become
static and not change even if the calculate hot key F9 is pressed. On the
row, the same function will be repeated with a different time and date.
Again, one that new time and date are determined by the now(), it should
remain constant. The process is then repeated so that I will end up with a
series of different times and dates. Can you help? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I make "NOW" function static 2
Difference between NOW() and TODAY() 9
now() 5
NOW() function that won't change 4
How to make the Result of a TODAY Function static? 11
I need to change 4/21/1998 dates to 21/4/1998 HOW? 7
NETWORKDAYS calculation returns inconsistent results 1
How do I use NOW so that each cell displays a different time? 2

Top