Thread: Time Stamp

Hi

i wish to record in my current cell (whichever i have selected) to record
the current time. I need to show hours, minutes and seconds. I have looked
atthe Ctrl-Shift-; option but it doesnt record seconds option.

How can record this information at a push of a button

Thanks

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

Assign the above to a button.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 20:21:01 -0700, Andrew C <AndrewC@discussions.microsoft.com>
wrote:

>Hi
>
>i wish to record in my current cell (whichever i have selected) to record
>the current time. I need to show hours, minutes and seconds. I have looked
>atthe Ctrl-Shift-; option but it doesnt record seconds option.
>
>How can record this information at a push of a button
>
>Thanks

Thank you works great

"Gord Dibben" wrote:

> Sub NOWTIME()
> ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
> End Sub
>
> Assign the above to a button.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 26 Jul 2006 20:21:01 -0700, Andrew C <AndrewC@discussions.microsoft.com>
> wrote:
>
> >Hi
> >
> >i wish to record in my current cell (whichever i have selected) to record
> >the current time. I need to show hours, minutes and seconds. I have looked
> >atthe Ctrl-Shift-; option but it doesnt record seconds option.
> >
> >How can record this information at a push of a button
> >
> >Thanks
>
>