oscarthestomatopod101
New Member
- Joined
- Sep 29, 2011
- Messages
- 1
Hello! I'm still very new to macros and excel and right now, I've been using: Private Sub Worksheet_Change(ByVal Target As Range) Dim x As Long x = Target.Row If Target.Column = 2 And Cells(x, 2) <> "" Then Cells(x, 1) = Time Cells(x, 1).NumberFormat = "hh:mm:ss" End If End Sub Since the time was based off the clock from my computer, I was wondering if there way to just change the time portion into a timer, whose beginning time I can modify and continue the counting up from where I left off? I'm not very good with explaining, so this example will most likely be a little clearer: For example: I want my start time to be 00:02:00 and the amount of time passed since then to be placed in column A. As I type data/observations/etc. into column B, the timer will automatically input the time since then. Any help is GREATLY APPRECIATED!!! Thank you so much!
The code came from someone, I forgot who, so just saying to credit them, just in case they felt offended.
The code came from someone, I forgot who, so just saying to credit them, just in case they felt offended.
Last edited: