Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you store real time in excel when making an entry
Hello,
I want to store a date and time stamp in a cell when i enter a vale in another. For example: I have Col A .. called "id" .. in each row under that column i will enter a number and or letters I have Col B .. call it "date and time" .. i want it to store in the cell the exact date and time including seconds .. when the value was entered into the Col A Row 1 In other words I want to record the exact date and time when an entry was made from the adjacent column. I tried using NOW() but then when i made an entry the whole date and time was changed for every cell. I want to freeze (the date and time of every entry). The date and time for the each entry needs to be recored as I ener the value AND it need not chnage the rest. Can someone help? -- jhbarajas san antonio, texas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you store real time in excel when making an entry
See this:
http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "jhbarajas" wrote in message ... Hello, I want to store a date and time stamp in a cell when i enter a vale in another. For example: I have Col A .. called "id" .. in each row under that column i will enter a number and or letters I have Col B .. call it "date and time" .. i want it to store in the cell the exact date and time including seconds .. when the value was entered into the Col A Row 1 In other words I want to record the exact date and time when an entry was made from the adjacent column. I tried using NOW() but then when i made an entry the whole date and time was changed for every cell. I want to freeze (the date and time of every entry). The date and time for the each entry needs to be recored as I ener the value AND it need not chnage the rest. Can someone help? -- jhbarajas san antonio, texas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real-time clock in excel | Excel Discussion (Misc queries) | |||
how do i insert a real time clock in excel ? | Excel Discussion (Misc queries) | |||
Convert real time to a % in Excel | Excel Discussion (Misc queries) | |||
SUNDERA - Real Time Excel Collaboration | Excel Discussion (Misc queries) | |||
How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel |