Inserting time inside cell

  • Thread starter Thread starter Sachi Noma
  • Start date Start date
S

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
 
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
 
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
 
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
 
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
 
Hello Gord

Thank you.

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

sn from Japan
 
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
Click to expand...
 
Back
Top