| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Current Time
Hi
What I want to do is that if I enter a value in a cell (Ex A1), in cell A2, I want the current system time to automatically stamp and save it. Please advise if this is possible. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Current Time
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value < "" Then Range("A2").Value = Time End If End Sub "ub" wrote: Hi What I want to do is that if I enter a value in a cell (Ex A1), in cell A2, I want the current system time to automatically stamp and save it. Please advise if this is possible. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Current Time
=IF(A10,NOW(),0)
that will put the current time if a value of 0 is entered it will be a funny number, if you format the cell Time it will be a time "ub" wrote: Hi What I want to do is that if I enter a value in a cell (Ex A1), in cell A2, I want the current system time to automatically stamp and save it. Please advise if this is possible. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Current Time
.... but next time you open the sheet, NOW() will be a different time. Did
the OP want that? -- David Biddulph "dlw" wrote in message ... =IF(A10,NOW(),0) that will put the current time if a value of 0 is entered it will be a funny number, if you format the cell Time it will be a time "ub" wrote: Hi What I want to do is that if I enter a value in a cell (Ex A1), in cell A2, I want the current system time to automatically stamp and save it. Please advise if this is possible. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Current Time
Hi
Please advise, if the time will be saved. Because NOW(), gives thecurrent time. Example, If I had entered data in cell A1 yeterday and today when I go in the sheet. Will I see the time in cell a2 that of yesterday or the current time. "dlw" wrote: =IF(A10,NOW(),0) that will put the current time if a value of 0 is entered it will be a funny number, if you format the cell Time it will be a time "ub" wrote: Hi What I want to do is that if I enter a value in a cell (Ex A1), in cell A2, I want the current system time to automatically stamp and save it. Please advise if this is possible. Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Current Time
I dont want a different time , when I tab to another cell or reopen the sheet.
Is there any way I can store the value of now() in any cell. "David Biddulph" wrote: .... but next time you open the sheet, NOW() will be a different time. Did the OP want that? -- David Biddulph "dlw" wrote in message ... =IF(A10,NOW(),0) that will put the current time if a value of 0 is entered it will be a funny number, if you format the cell Time it will be a time "ub" wrote: Hi What I want to do is that if I enter a value in a cell (Ex A1), in cell A2, I want the current system time to automatically stamp and save it. Please advise if this is possible. Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Current Time
Control semi-colon, space, Control-shift-colon
-- David Biddulph "ub" wrote in message ... I dont want a different time , when I tab to another cell or reopen the sheet. Is there any way I can store the value of now() in any cell. "David Biddulph" wrote: .... but next time you open the sheet, NOW() will be a different time. Did the OP want that? -- David Biddulph "dlw" wrote in message ... =IF(A10,NOW(),0) that will put the current time if a value of 0 is entered it will be a funny number, if you format the cell Time it will be a time "ub" wrote: Hi What I want to do is that if I enter a value in a cell (Ex A1), in cell A2, I want the current system time to automatically stamp and save it. Please advise if this is possible. Thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Current Time
Thanks a lot, It works
Please advise if I can use to automaticaly enter time in my sheet. Example, if user has entered a value in cell a1, the current time should stamp autmatically in cell a2 and the time value should be saved. Thanks "David Biddulph" wrote: Control semi-colon, space, Control-shift-colon -- David Biddulph "ub" wrote in message ... I dont want a different time , when I tab to another cell or reopen the sheet. Is there any way I can store the value of now() in any cell. "David Biddulph" wrote: .... but next time you open the sheet, NOW() will be a different time. Did the OP want that? -- David Biddulph "dlw" wrote in message ... =IF(A10,NOW(),0) that will put the current time if a value of 0 is entered it will be a funny number, if you format the cell Time it will be a time "ub" wrote: Hi What I want to do is that if I enter a value in a cell (Ex A1), in cell A2, I want the current system time to automatically stamp and save it. Please advise if this is possible. Thanks |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Current Time
That would need VBA. You'll see suggestions in the archives of this
newsgroup. -- David Biddulph "ub" wrote in message ... Thanks a lot, It works Please advise if I can use to automaticaly enter time in my sheet. Example, if user has entered a value in cell a1, the current time should stamp autmatically in cell a2 and the time value should be saved. Thanks "David Biddulph" wrote: Control semi-colon, space, Control-shift-colon -- David Biddulph "ub" wrote in message ... I dont want a different time , when I tab to another cell or reopen the sheet. Is there any way I can store the value of now() in any cell. "David Biddulph" wrote: .... but next time you open the sheet, NOW() will be a different time. Did the OP want that? -- David Biddulph "dlw" wrote in message ... =IF(A10,NOW(),0) that will put the current time if a value of 0 is entered it will be a funny number, if you format the cell Time it will be a time "ub" wrote: Hi What I want to do is that if I enter a value in a cell (Ex A1), in cell A2, I want the current system time to automatically stamp and save it. Please advise if this is possible. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| current time member | Excel Discussion (Misc queries) | |||
| In Excel: is there a way of inserting the current time (what time it is right NOW) | Excel Discussion (Misc queries) | |||
| Having the current time inserted w/o updating the current time | Excel Worksheet Functions | |||
| how do I get a current time using =TODAY() instead of 12:00 AM | Excel Discussion (Misc queries) | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
Linear Mode
