Hello all... before I start ………… please be kind and yes you will see I am very dumb... you are the guru’s
I am trying to get an accurate excel timer (or as BEST AS one can be) to help me with multiple timing
Basically, like a swim / track race I can have up ten competitors all starting at the same time.
I was able to find this one: XCTIMER.XLSM in this forum… (Thank you guys for this)…..in which seems to do most of what I wanted expect for the items below
So I need the following:
1. Global start event Trigger 1 X button = START
a. an assigned linked keyboard hotkey
2. Global Stop event Trigger 1 X button = STOP
a. an assigned linked keyboard hotkey
3. Global Reset event Trigger 1 X button = RESET
a. An assigned linked keyboard hotkey.
Now the part I would have more trouble with:
4. At least 10 split event triggers with 10 different assigned hotkeys running off the main timer, (i dont even know how to start or where to start)
Functional description
Start is activated and timer runs every split is recorded with its assigned hotkey next to it Cascaded down a column
Stop and Reset... do exactly just that
During whilts timer is running all non assigned keystrokes should be ignored
If you are unable modify the attached timer macro to do the same as the could you please at least send me in the right direction as how to assign multiple hotkeys to the same function (split) and the how I could get it to identify which hot key was used to trigger the split.
Any help will be very much appreciated
attached is the xctimer also found elsewhere in this forum and a picture of how i would like to see the end result with suggested hot keys..
Bookmarks