enter date&time into cell

[Valdemar]

Hello to all,
please help me.
How can I enter actual date&time into cell using keybord? I need to prepare
a simple sheet for evidence of events and I'd like to allow to users to enter
this data.
Many thanks and have a good day. Valdemar

 

[trip_to_tokyo]

EXCEL 2007

MS documentation says:-

to insert the current date and time, press CTRL+; (semi-colon), then press
SPACE, and then press CTRL+SHIFT+; (semi-colon).

Please hit Yes if my comments have helped.

Thanks.

 

[Valdemar]

Hi Russell,
I know about this function CTRL+; (semi-colon) and CTRL+SHIFT+;
but in my Excel (version 2003) it works only for date CTRL + ;
and not for time:-(( SA
So I'll use macro.
Thank you for your time, Valdemar.



Russell Dawson píše: