Inserting current time

Giganews Newsgroups
Subject: Inserting current time
Posted by:  Talltone (curete…@blueyonder.co.uk)
Date: Mon, 13 Oct 2003

I am trying to insert times into a Excel 2000 spreadsheet
in the format hh:mm:ss.  Because a number of events have
to be logged, some very close together, I am trying to use
the CTRL + SHIFT + : (colon) technique.  I have formatted
the cells to show hh:mm:ss but when I use the key
combination above, it only gives me hh:mm.  When I press
RETURN to move to the next cell the cell data then changes
to hh:mm:00.
In other words I cannot get it to record the seconds.
Please can somebody help! I seem to be close to the
solution but not close enough!  The computer clock shows
seconds, by the way.

Replies