You might need a small macro to do this instantly. If you have a cell with
the function =NOW() it will give you the time and date as of the time a
recalculation is done. As soon as you make your cell entry you could hit the
F9 recalc button, this will make the cell with =NOW() show the exact time it
is just after you made your entry. This cell will of course change the next
time you do another recalc so you would have to format a cell as time and
then copy...paste special...values to copy the time value so that it will not
change upon recalculation.

"Maverick" wrote:

I want to insert the exact time (hh:mm:ss) I entered data into another cell.
For example when I enter data in cell C:2 I need the exact time it was
entered displayed in cell C:1.