how do I insert the current time (static) and date in a cell?
 

I want to use Excel as an automated timesheet.

how do I insert the current time (static) and date in a cell?
 

Ctrl + ; and Ctrl + :


--

Regards,

Peo Sjoblom

"DF" wrote in message
...
I want to use Excel as an automated timesheet.

how do I insert the current time (static) and date in a cell?
 

That instruction does not help; I have tried to do that, but nothing happens.

"Peo Sjoblom" wrote:

Ctrl + ; and Ctrl + :


--

Regards,

Peo Sjoblom

"DF" wrote in message
...
I want to use Excel as an automated timesheet.

how do I insert the current time (static) and date in a cell?
 

Ctrl + ; will return the date Ctrl + Shift + ; will return the time

"DF" wrote:

That instruction does not help; I have tried to do that, but nothing happens.

"Peo Sjoblom" wrote:

Ctrl + ; and Ctrl + :


--

Regards,

Peo Sjoblom

"DF" wrote in message
...
I want to use Excel as an automated timesheet.

how do I insert the current time (static) and date in a cell?
 

That is Ctrl and ;/: keys together, i..e Ctrl-; and Ctrl-Shift-;, not the +
key.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DF" wrote in message
...
That instruction does not help; I have tried to do that, but nothing
happens.

"Peo Sjoblom" wrote:

Ctrl + ; and Ctrl + :


--

Regards,

Peo Sjoblom

"DF" wrote in message
...
I want to use Excel as an automated timesheet.

how do I insert the current time (static) and date in a cell?
 

hi try this

ctrl + shift+;
and you will get the date

/jocke


--
jocke
------------------------------------------------------------------------
jocke's Profile: http://www.excelforum.com/member.php...nfo&userid=766
View this thread: http://www.excelforum.com/showthread...hreadid=480124