I don't want all NOW() cells to recalculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings,

I'm trying to save event times in an openworkbook...i.e. time of one
arrival, then the next and so on. If I use NOW(), it gives me the current
time (which I want), but when I take the next time, it recalculates EVERY
cell so I lose the old data.

Of course, I don't have time between arrivals to copy and paste values. Any
ideas on how I could get Excel to return the current time in one cell while
leaving past cells alone?

Thanks,
Nate
 
Hi Nate,

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


--
Kind regards,

Niek Otten

| Greetings,
|
| I'm trying to save event times in an openworkbook...i.e. time of one
| arrival, then the next and so on. If I use NOW(), it gives me the current
| time (which I want), but when I take the next time, it recalculates EVERY
| cell so I lose the old data.
|
| Of course, I don't have time between arrivals to copy and paste values. Any
| ideas on how I could get Excel to return the current time in one cell while
| leaving past cells alone?
|
| Thanks,
| Nate
 
You must log in or register to reply here.

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

One-time NOW() function 3
want to track time while paste value in multiple column of same roe 1
Using the NOW() function without it recalculating 3
IF statement based on need to recalculate 1
Forcing to recalculate 7
UDF's & puzzling recalculation behavior 3
Stop specific cell from recalculating? 3
Automatically insert time in excel but not automatically updated 5

Back
Top