Timestamp Button
 

Hello All,

I am creating a form in excel for some other users to use to help
collect data about how long each step in a process takes to do. What
Iwould like to do is have a timestamp button that would put the current
date+time in a cell each time a milestone in the project is completed --
that way we will end up with a big list of timestamps compare and see
how long it really takes to do each part of our process.

I have tried to use a volital command like "=(now), but each time i use
it, it changes ALL the timestamps. I need something that can put a
timestamp in a form without affecting other timestamps on the page.

I am willing to try anything, including VBA, but I'll warn you I really
haven't used it ever before so instructions would have to be pretty low
level.

Any ideas anybody might have will be very gratefully appreciated.

Thanks!


--
Eckleburg
------------------------------------------------------------------------
Eckleburg's Profile: http://www.excelforum.com/member.php...o&userid=23933
View this thread: http://www.excelforum.com/showthread...hreadid=375643

Manual

You can use a Shortcut for it

you can insert the time like this
CTRL : (colon)

the date like this
CTRL ; (semicolon)

CTRL : (colon) space bar CTRL ; (semicolon)
this will give you both in one cell

With code you can do this

ActiveCell.Value = Format(Now, "hh:mm:ss")
Or
ActiveCell.Value = Format(Now, "mm-dd-yy hh:mm:ss")


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Eckleburg" wrote in message
...

Hello All,

I am creating a form in excel for some other users to use to help
collect data about how long each step in a process takes to do. What
Iwould like to do is have a timestamp button that would put the current
date+time in a cell each time a milestone in the project is completed --
that way we will end up with a big list of timestamps compare and see
how long it really takes to do each part of our process.

I have tried to use a volital command like "=(now), but each time i use
it, it changes ALL the timestamps. I need something that can put a
timestamp in a form without affecting other timestamps on the page.

I am willing to try anything, including VBA, but I'll warn you I really
haven't used it ever before so instructions would have to be pretty low
level.

Any ideas anybody might have will be very gratefully appreciated.

Thanks!


--
Eckleburg
------------------------------------------------------------------------
Eckleburg's Profile: http://www.excelforum.com/member.php...o&userid=23933
View this thread: http://www.excelforum.com/showthread...hreadid=375643

Thank you for the tip, it seems to be working like a charm :)


--
Eckleburg
------------------------------------------------------------------------
Eckleburg's Profile: http://www.excelforum.com/member.php...o&userid=23933
View this thread: http://www.excelforum.com/showthread...hreadid=375643