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


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=473084

Josh-

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

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

--
tad_wegne
-----------------------------------------------------------------------
tad_wegner's Profile: http://www.excelforum.com/member.php...fo&userid=2777
View this thread: http://www.excelforum.com/showthread.php?threadid=47308

Or, more simply,

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


On Tue, 4 Oct 2005 13:33:44 -0500, tad_wegner
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