Hi Nate,
http://www.mcgimpsey.com/excel/timestamp.html
--
Kind regards,
Niek Otten
"Nate" wrote in message ...
| 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