If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Time in Excel
I am trying to do something that seems impossible. I am a paramedic and use
a mobile device during the course of my job. I am trying to write a spreadsheet that will "time stamp" important times within a run. I have been using: =IF(A3=1,NOW(),"") I enter a 1 in Column A and the equation is in Column C, but it resets all time to the same since NOW() is a volatile function. Is there anyway to overcome this? |
#2
|
|||
|
|||
Time in Excel
http://www.mcgimpsey.com/excel/timestamp.html
-- Regards, Peo Sjoblom "Medic1712" wrote in message ... I am trying to do something that seems impossible. I am a paramedic and use a mobile device during the course of my job. I am trying to write a spreadsheet that will "time stamp" important times within a run. I have been using: =IF(A3=1,NOW(),"") I enter a 1 in Column A and the equation is in Column C, but it resets all time to the same since NOW() is a volatile function. Is there anyway to overcome this? |
#3
|
|||
|
|||
Time in Excel
See this:
http://www.mcgimpsey.com/excel/timestamp.html -- Biff Microsoft Excel MVP "Medic1712" wrote in message ... I am trying to do something that seems impossible. I am a paramedic and use a mobile device during the course of my job. I am trying to write a spreadsheet that will "time stamp" important times within a run. I have been using: =IF(A3=1,NOW(),"") I enter a 1 in Column A and the equation is in Column C, but it resets all time to the same since NOW() is a volatile function. Is there anyway to overcome this? |
#4
|
|||
|
|||
Time in Excel
You can use event code to timestamp an adjacent cell when data is entered in
any cell in column A Private Sub Worksheet_Change(ByVal Target As Excel.Range) 'when entering data in a cell in Col A On Error GoTo enditall Application.EnableEvents = False If Target.Cells.Column = 1 Then With Target If .Value "" Then .Offset(0, 1).Value = Format(Now, "hh:mm:ss") End If End With End If enditall: Application.EnableEvents = True End Sub This is worksheet event code. Right-click on the sheet tab and "View code". Copy/paste into that sheet module. Gord Dibben MS Excel MVP On Tue, 26 Aug 2008 19:01:00 -0700, Medic1712 wrote: I am trying to do something that seems impossible. I am a paramedic and use a mobile device during the course of my job. I am trying to write a spreadsheet that will "time stamp" important times within a run. I have been using: =IF(A3=1,NOW(),"") I enter a 1 in Column A and the equation is in Column C, but it resets all time to the same since NOW() is a volatile function. Is there anyway to overcome this? |
Thread Tools | |
Display Modes | |
|
|