Time value

[Guest]

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

 

[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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk