Results 1 to 3 of 3

Adding a Clever Timer to a Spreadsheet

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2023
    Location
    Wellington, NZ
    MS-Off Ver
    Office 365
    Posts
    1

    Adding a Clever Timer to a Spreadsheet

    Hi there, I'm hoping somebody might be able to help me please!

    I am watching live sporting routines (artistic swimming), where I create a string of characters, pushing 1, 2 or 3, depending on the error that I see.

    What I would like is the following for each routine:
    - When I press the 's' key, the timing begins.
    - When I press the 'f' key, the timing ends and clears,
    - Any time I press a '3' key, the stopwatch records the time it was pressed during the routine (see the last 5 cells in the screen shot)

    Basically, I have the spreadsheet set up with no timing function at the moment, but would like it to record when in the routine I see a type 3 Major error.

    This is way too difficult for me, but I'd really appreciate it if someone can work their magic for me!!

    Many thanks in advance...
    Attached Images Attached Images
    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. Countdown timer Working BUT starting the timer repeatedly SPEEDS UP TIMER!
    By Vinospam in forum Excel Programming / VBA / Macros
    Replies: 67
    Last Post: 03-30-2019, 06:42 PM
  2. [SOLVED] Get a countdown timer to start automatically when spreadsheet opens
    By zamirkaya in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2016, 11:29 AM
  3. Edit spreadsheet while VBA timer is running
    By jarredwyatt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2016, 07:50 PM
  4. save and close a spreadsheet by a controlled timer
    By Baz Kawar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2013, 06:11 PM
  5. Timer and timed close of a spreadsheet
    By jeffwest2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2009, 06:57 AM
  6. Open closed spreadsheet by timer???
    By EMoe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2007, 08:38 AM
  7. Adding the VB Timer Control...
    By Dinesh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2006, 10:10 PM

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