Hello,

I'm trying to create a timer in excel that starts when a cell in range A2:A8 = "Start Timer".

I've managed to get it to work using this code here, although, I'd like it to only work in the range A2:A8.

Also, is it possible to have the time difference update automatically every minute.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then Target.Offset(0, 2) = Now
End Sub
Attached, is a copy of the spreadsheet I'm working on.

Any help would be appreciated.

Timer.xlsm