+ Reply to Thread
Results 1 to 7 of 7

Timer in Excel

  1. #1
    Registered User
    Join Date
    11-06-2009
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    10

    Question Timer in Excel

    Hi,

    Please help me how to make a timer in excel.. For example, i will have a command button, everytime I click the button there will be a timer starting from 00:00:00 shown in a specific cell. If I click the button again, the timer will be reset to 00:00:00 and then start counting again.

    Please help me. What would be the appropriate codes for this...

    Thanks in advance...

  2. #2
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: Timer in Excel

    quite a no. of references are there in google search

  3. #3
    Registered User
    Join Date
    11-06-2009
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Timer in Excel

    Quote Originally Posted by venkat1926 View Post
    quite a no. of references are there in google search
    I actually did that, but i did'nt find any, that matches my preference, that is why I tried if I can find it here in this forum....

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Timer in Excel

    Here's a sheet I made for someone once. It allows MULTIPLE timers in column A which will go in the direction indicated in column B.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  5. #5
    Registered User
    Join Date
    11-06-2009
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Timer in Excel

    thank you so much JBeaucaire for your time, I realy appreciate your attachment, but im newby to excel that is why I can't get all the codes. I attach an excel file according to what I want to have...


    Thank you so much again....
    Attached Files Attached Files

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Timer in Excel

    Hi,

    See attached for one solution.

    The code is in the 'Timer' procedure. viz:

    Please Login or Register  to view this content.
    Rgds
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  7. #7
    Registered User
    Join Date
    11-06-2009
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Timer in Excel

    Thank you so much, but the code is not working, I mean the count is not pursuing. It stops at 0:00:01 or 0:00:01.

    Please help me for this problem, I realy Appreciate your time and effort
    Last edited by shg; 08-29-2010 at 11:11 AM. Reason: deleted spurious quote

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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