Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time stamp in Excel Sheet
I am looking to entering a value into column A (Data Point), then on column B
(Time Stamp), the time that value A was entered. Then another value will be entered into A2 and would like the time that Data Point 2 was entered into B2 and so on. I have tried the IF statement =IF(A1,NOW(),"") in B1,B2, B3... but every time the work sheet reculculates, the Time Stamp column becomes the same. How can I stop this from happening or am I going about this the wrong way. |
#3
|
|||
|
|||
Take a look he
http://www.mcgimpsey.com/excel/timestamp.html In article , John M <John wrote: I am looking to entering a value into column A (Data Point), then on column B (Time Stamp), the time that value A was entered. Then another value will be entered into A2 and would like the time that Data Point 2 was entered into B2 and so on. I have tried the IF statement =IF(A1,NOW(),"") in B1,B2, B3... but every time the work sheet reculculates, the Time Stamp column becomes the same. How can I stop this from happening or am I going about this the wrong way. |
#4
|
|||
|
|||
Thank You JE McGimpsey. This answers my question. Again Thank you for your
time. John "JE McGimpsey" wrote: Take a look he http://www.mcgimpsey.com/excel/timestamp.html In article , John M <John wrote: I am looking to entering a value into column A (Data Point), then on column B (Time Stamp), the time that value A was entered. Then another value will be entered into A2 and would like the time that Data Point 2 was entered into B2 and so on. I have tried the IF statement =IF(A1,NOW(),"") in B1,B2, B3... but every time the work sheet reculculates, the Time Stamp column becomes the same. How can I stop this from happening or am I going about this the wrong way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Excel won't copy outside sheet | Excel Discussion (Misc queries) | |||
time card excel sheet | Excel Worksheet Functions | |||
create price list from excel sheet | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions |