The CTRL + SHIFT + ; will not enter the seconds in the cell as you have found.

For that I use a small macro.

Sub NOWTIME()
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
End Sub

You can have this on a button or shortcut key combo.


Gord

On Mon, 5 Mar 2007 09:17:08 +0900, "Sachi Noma" wrote:

Hello Everyone

Thank you kindly for the tips.

I am able to insert time (hours and mintues) however I also want to insert
the seconds as well, which I cannot seem to do.

sn

"MartinW" wrote in message
...
Hi Sachi,

Not sure if this is what you are looking for but if you
hit ctrl+; in a cell it will put the current date in that cell,
if you hit ctrl+shift+: it will put the current time in that cell.

HTH
Martin