Re: Excel: How to insert current time (static) to the nearest seco

Tech-Archive recommends: Speed Up your PC by fixing your registry

Roger

That doesn't return 14:23:23

It returns 2:23:23

Need a custom format of "h:mm:ss;@" or "hh:mm:ss;@"


Gord

On Thu, 12 Jul 2007 17:02:20 +0100, "Roger Govier"
<roger@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi MarySue

just remove the AM/PM

ActiveCell.Value = Format(Now(), "h:mm:ss")

.