Suggested reading. John Walkenbach's Excel Bible books, $40.
Http:/j-walk.com/ss

Tyro

"Sergeant Henderson USAF"
wrote in message ...
Thank you very much guys - I do appreciate the time. I can work with this
information.
MSgt H.


"Dave Peterson" wrote:

If you want that time to be static, then you can't use a formula.

=now() will update whenever excel recalcs.

But you could use a macro.

In fact, JE McGimpsey has ready for you:
http://www.mcgimpsey.com/excel/timestamp.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Sergeant Henderson USAF wrote:

I'm creating a log sheet that will have entries every few minutes in
the
second cell or column B. I need the time to be automatically entered in
A
each time. Is this possible? I've tried several formulas with no luck.
The
closest formula that I can get is =IF(B1=1, "NOW()") however this will
return
an error. If this were to work then a 1 would have to be entered in B1.
I
tried using a wildcard with no luck also.
Time taken from the computer clock is entered as =NOW()
Please help if you can
Thanks
Tim

--

Dave Peterson