use the Now() function - this is volatile and will be updated after each
sheet calculation takes place.

put the following in the cell required - it formats to date and time (which
you can change using cell format)

=NOW()

Cheers
Nigel

"Raymond" wrote in message
...
I want to add the time and date for a cell, but I want these date and time
to be automatically updated itself with each passing day, and second. So
when I log on this excel sheet later, the cell will show a different date
and time in which I am currently in. How do I accomplish this? Is this
possible at all?