Inserting time inside cell

[Sachi Noma]

I use Office 2003 Excel Win XP

Can someone tell me how to insert time: hours, minutes and seconds inside a
cell?

sn

 

[Guest]

hi,
hh:mm:ss or 12:12:12
also see Format>cells>number tab. scroll down left to custom. scroll down
right to see other formats.
regards
FSt1

 

[MartinW]

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

 

[Sachi Noma]

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

 

[Gord Dibben]

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

 

[Sachi Noma]

Hello Gord

Thank you.

I assume without a customized macro, Excel does not have a method to insert
"seconds".

sn from Japan

 

[Gord Dibben]

Nothing that I know of.

Gord

Hello Gord

Thank you.

I assume without a customized macro, Excel does not have a method to insert
"seconds".

sn from Japan