|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
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.