Results 1 to 5 of 5
  1. #1
    somebody
    Guest

    Default Stopwatch in Excel

    I've been asked to design a program for recording results from a triathlon.

    I was wondering if there is a way to add a stopwatch function to MS Excel, and if so, how it can be done. I will need to be able to click a button and have it record a time for a particular participant.

  2. #2
    godfather
    Guest

    Default Re: Stopwatch in Excel

    try playing around with

    =NOW()

    this will return the PC date and time, by formatting the cell you can get to hubdreths of a second.

  3. #3
    somebody
    Guest

    Default Re: Stopwatch in Excel

    ok. Thanks godfather

  4. #4
    Russell D
    Guest

    Default Re: Stopwatch in Excel

    Be aware that the =NOW() function will update each time the worksheet is recalculated.
    Whereas if the VB function NOW is run, it will place that fixed time in the worksheet.
    If you have two buttons, one for "Start" and it enters NOW in a cell, another button can be for "Finish" and if each time the button is pressed it enters NOW - Starttime, you will get total elapsed time for each entrant.
    These cells will require Custom formatting to hh:mm:ss.


  5. #5
    somebody
    Guest

    Default Re: Stopwatch in Excel

    Ok. Thanks Russell. Now I have go to and hunt down help on VB.

    Luckily I don't have to have this "program" completed until this time next year, so I have plenty of time to learn

Similar Threads

  1. Replies: 1
    Last Post: 29-09-2008, 12:35 AM
  2. Excel 97 to Excel 2000 Files
    By Scott Vail in forum PressF1
    Replies: 1
    Last Post: 03-07-2003, 04:26 PM
  3. "Stopwatch" function
    By somebody in forum PressF1
    Replies: 0
    Last Post: 28-03-2003, 10:48 PM
  4. Replies: 2
    Last Post: 20-06-2002, 11:41 PM
  5. Excel 2000 & Excel 97 toolbars
    By in forum PressF1
    Replies: 0
    Last Post: 11-06-1999, 09:27 AM

Posting Permissions

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