http://www.mcgimpsey.com/excel/timestamp.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ups.com...
| Hello,
|
| I am trying to capture a date stamp in a cell when a certain option has
| been selected from a drop down menu. After searching on this forum i
| made use of
|
| Function DateAndTime()
| DateAndTime = Now
| End Function
|
| Essentially I have 2 options in my drop down list. "On Going" and
| "Complete"
|
| I have 2 further columns labelled Start Time and Finish Time. I am
| trying to capture a date stamp in each column using this formula in
| column f
|
| =IF(E3="On Going",DateAndTime(),"")
|
| and this formula in column g
|
| =IF(E3="Complete",DateAndTime(),"")
|
| when I select "On Going" from the drop down list the time is captured
| in column f perfectly. However when I select "Complete" it captures
| the time in column g but nulls the time previously captured in column f
| (when "On Going" was selected) as I have changed the value from the
| drop down list. Is there anyway that I can ensure the value captured
| in Column f stays?
|
| thanks in advance for any help.
|