Thread: Format Time

How can I get the static time to include seconds? I can manually insert
using the Control+Shift+; and I can format the cell, but the seconds is
always 00.

Ctrl-Shift-; always gives hours and minutes, not seconds (don't know why).

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Maverick" <Maverick@discussions.microsoft.com> wrote in message
news:536B564B-DF91-40DF-92BC-C7B7F4B1ACBD@microsoft.com...
> How can I get the static time to include seconds? I can manually insert
> using the Control+Shift+; and I can format the cell, but the seconds is
> always 00.

Unfortunately, that is how Excel does it.

You can use =NOW() and copy/paste special>values immediately.

You could use a small macro attached to a button or a shortcut key.

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


Gord Dibben MS Excel MVP

On Thu, 27 Jul 2006 13:22:02 -0700, Maverick
<Maverick@discussions.microsoft.com> wrote:

>How can I get the static time to include seconds? I can manually insert
>using the Control+Shift+; and I can format the cell, but the seconds is
>always 00.