Autodate and total hours

[jackel]

Hello,

When a description is entered into the first cell, I want the date &
time, to automatically insert into a different cell (Protected,Not to
be edited by the user). Then when the project is finished, the date is
entered (pops up automatically) which will display the now date & time.
The total project time only will be displayed in a different cell. I
know how to protect cells.

I do okay with this beautiful program but do not know anything about
Macros or VB. Hopefully, this will be easy for me to do!

Thanks for the assistance.

 

[Stan Brown]

Fri, 15 Feb 2008 22:26:56 +0000 from jackel <jackel.1fbf994
@officefrustration.com>:

When a description is entered into the first cell, I want the date &
time, to automatically insert into a different cell (Protected,Not to
be edited by the user). Then when the project is finished, the date is
entered (pops up automatically) which will display the now date & time.
The total project time only will be displayed in a different cell. I
know how to protect cells.

I do okay with this beautiful program but do not know anything about
Macros or VB. Hopefully, this will be easy for me to do!

Look into events in VBA.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?

 

[jackel]

Fri, 15 Feb 2008 22:26:56 +0000 from jackel jackel.1fbf994
@officefrustration.com:-
When a description is entered into the first cell, I want the date &
time, to automatically insert into a different cell (Protected,Not to
be edited by the user). Then when the project is finished, the dat
is
entered (pops up automatically) which will display the now date
time.
The total project time only will be displayed in a different cell. I
know how to protect cells.

I do okay with this beautiful program but do not know anything about
Macros or VB. Hopefully, this will be easy for me to do! -

Look into events in VBA.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?

What description would I look for

 

[Sandy Mann]

Try reading:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Gord Dibben]

jackel

Easy enough to do with event code.

The project starts when user enters a description in a cell and a static time
will be placed into a cell and that cell locked by event code.

I have one question first.

How will Excel know when the project is finished?

Maybe two questions........any particular cells for the times to be entered?


Gord Dibben MS Excel MVP