Add Date And Time in a cell.

[Raymond]

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?

 

[Nigel]

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

 

[Bob Phillips]

Be aware that this will update if the sheet recalculates some time after you
login to the sheet. This may be what you want, but it will not be showing
your start time for that day.

 

[Don]

Hi Raymond,

To throw my 2 cents in the ring here.....depending on
whether or not you want the "Log On" time to remain
static, you might consider copying the cell and paste
special/value back onto the same cell.....that'll nail
down the time you logged on. But that'll lose you the Now
() formula on that sheet......so....use two cells...copy
the Now() cell and paste special/value into the second
cell. You could create a macro that did this
automatically for you if you're into VBA.

WOW......that was almost a quarters worth....

 

[Jan Mishkin]

Also, be sure your cell is formatted for both date and
time.