+ Reply to Thread
Results 1 to 2 of 2

Timer that starts counting up in mins soon as a cell is filled

Hybrid View

  1. #1
    Registered User
    Join Date
    07-20-2012
    Location
    utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    Timer that starts counting up in mins soon as a cell is filled

    I want a time tracker that will count time soon as a specific cell is filled.
    Example:
    a column has a drop down list of items, b column start counting minutes soon as the item is chosen from the dropdown list. soon as column c is filled the counter stops.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    935

    Re: Timer that starts counting up in mins soon as a cell is filled

    Have a try with these macros.

    To be pasted in a standard module:
    Option Explicit
    Public On_Off  As Boolean
    Public Tempo   As Double
    Public rowTarget As Range
    
    Sub Clock()
        DoEvents
        If On_Off = True Then Exit Sub
        Application.EnableEvents = False
        rowTarget.Offset(0, 1).Value = Format(Now - Tempo, "hh:mm:ss")
        Application.EnableEvents = True
        Application.OnTime Now + TimeSerial(0, 0, 1), "Clock"
    End Sub
    
    Sub S_tart()
        On_Off = False
        Tempo = Now
        Call Clock
    End Sub
    
    Sub S_top()
        On_Off = True
    End Sub
    To be pasted in the Sheet1's module:
    Option Explicit
    Private Sub Worksheet_Change(ByVal Target As Range)
        If Target.Row < 4 Then Exit Sub
        Select Case Target.Column
            Case Is = 2
                Set rowTarget = Target
                Target.Offset(0, 2).Select
                Call S_tart
            Case Is = 4
                Call S_top
        End Select
    End Sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Counting cells only if adjacent cell is filled
    By rwebb_5 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-04-2020, 03:48 PM
  2. How to start a timer whenever a cell is filled, stops whenever another cell is filled
    By PerplexedEngineer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2016, 11:58 AM
  3. Replies: 3
    Last Post: 01-22-2016, 01:44 AM
  4. Replies: 12
    Last Post: 07-10-2012, 05:04 PM
  5. Replies: 3
    Last Post: 05-22-2012, 03:26 PM
  6. VBA Timer Starts With Checkbox
    By kurozero in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2012, 01:27 AM
  7. Count down time and count up timer does not starts in another sheet(s)
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2010, 07:52 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1