Time value

J

Jithu

Hi,

Is it possible to get the time value while entering data.

for example when i enter data(date) at 2.00 pm, the cell(same cell or in a
different cell) should capture the time of data entry. And it should be
static. so that in future i can know the time of data entry
Thanks in advance for help.

Jithu
 
S

Sandy Mann

Press and hold the Ctrl key while you pess the semi-colon key ; then,
(without the Ctrl key being pressed) , enter a space then press and hold
both Ctrl & Shift while you press the full colon key :

This will enter the date then the time as a static entry.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
J

Jithu

Sandy Mann said:
Press and hold the Ctrl key while you pess the semi-colon key ; then,
(without the Ctrl key being pressed) , enter a space then press and hold
both Ctrl & Shift while you press the full colon key :

This will enter the date then the time as a static entry.
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
Top