Results 1 to 8 of 8

Excel Stopwatch to record bike laps

Threaded View

  1. #1
    Registered User
    Join Date
    10-07-2008
    Location
    Australia
    Posts
    4

    Excel Stopwatch to record bike laps

    Hi all, I hope someone can help please.

    What I'm after is similar to the attached file I've put up (which has been floating around on the net for a while), but instead of having the 'record' button to do the work, i'd like to be able to type the bike's number that's about to cross the lap line in cell A4 and then, as he does so, hit the enter button to record the data (just as the 'record' button currently does).
    It's only possible for one rider to cross the line at a time so that's not an issue.

    Then what i'd like is for the cell focus to move down to A5, ready for the next bike's number to be quickly typed in and entered, and so on, and so on.

    In other words at the end of the race I'll have a list of bike rider's numbers (same riders more than once) down column A in the order they crossed the line.
    Down the timer columns ("e,f,g,h & i") it will have the times with reference to the original starting time (Just as it already does)

    I could then take the rider's number from column A and deduct each recorded time from his previous to display his time for each 'Lap'

    Hopefully this makes sense and is achievable.

    And hopefully someone can be of help
    Thanks all.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Delete record in access database with excel VBA
    By Eureka in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2013, 02:15 PM
  2. Suggestions for Excel / Access interaction?
    By Malvaro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2008, 07:30 PM
  3. Search for duplicate record in 2 excel spread sheet
    By Jimi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2007, 10:12 PM
  4. Excel 2003 Not Excelling in Handling 2000 .xls File
    By pands in forum Excel General
    Replies: 4
    Last Post: 02-27-2007, 05:56 PM
  5. how to merge data from one excel into another excel
    By refreshplease3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2006, 08:51 PM

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