keeping track of time

Is there a simple way to do the following.

Just 1 sheet.


I want to have a user click a command button and it puts the time at that moment in cell A2. I don't want it to be a now() or today() because when they are done working i want them to click another button that puts the time in cell B2, and my formula will figure the time difference.

Thanks for any help.


Josh

Josh-

Sub timedelay()
Cells(2, 1) = "=now()"
Cells(2, 1) = Cells(2, 1)
End Sub

this uses the "now" function then immediately writes over the "function" with the value... this way it is no longer a function (which will change with time), but the value.

Thanks Tad, works great!!!

Or, more simply,

Cells(2, 1).Value = Now()


On Tue, 4 Oct 2005 13:33:44 -0500, tad_wegner
<tad_wegner.1we62i_1128452737.6278@excelforum-nospam.com> wrote:

>
>Josh-
>
>Sub timedelay()
>Cells(2, 1) = "=now()"
>Cells(2, 1) = Cells(2, 1)
>End Sub
>
>this uses the "now" function then immediately writes over the
>"function" with the value... this way it is no longer a function (which
>will change with time), but the value.

jhahes wrote:
> Is there a simple way to do the following.
>
> Just 1 sheet.
>
>
> I want to have a user click a command button and it puts the time at
> that moment in cell A2. I don't want it to be a now() or today()
> because when they are done working i want them to click another button
> that puts the time in cell B2, and my formula will figure the time
> difference.
>
> Thanks for any help.
>
>
> Josh
>
>


Built into Excel is the "Ctrl ;" function. It does what you want. After it
time stamps the active cell you can format the cell to show date or time or
whatever it is you wanted.

Bill