measuring 2 ALTERNATING activities - 2 stopwatch switched (paused / unpaused) by 1 button

I need to program custom stopwatch (HH:MM:SS) in excel. There are simple stopwatch examples on the Internet (using VBA) but I do not know how to edit them to acomplish what i need. If someone could solve this for me so it can run on PC and Mac (compatible VBA, xlsm) id be forever gratefull. Any Excel Pro who would take on the challenge. Thanks

Ive got 2 activities. Activity A (e.g. squating) and Activity B (e.g. resting).

Ive got a trainee who switches between Activity A and Activity B when the trainer in the room shouts "NOW"

The trainer randomly shouts "NOW" and the trainee switches between Activity A and Activity B everytime he/she hears a command.

After some time, an unspecified time (e.g. half-hour) its over, and I need to know how much time a person spent in Activity A and how much time he spent in Activity B.

So it's a stopwatch that SWITCHES between two counters at a press of a button.

SEE THE ATTACHED PICTURE FOR ILLUSTRATION:

1) Press START - TIME A starts from zero and runs and runs and runs
2) Press SWITCH - TIME A pauses and TIME B starts from zero and runs and runs and runs
3) Press SWITCH - TIME B pauses and TIME A continues from where it was left

and so on, all the time - Pressing SWITCH does not zero/reset the counters, it only PAUSES currently running counter and UNPAUSE the other counter

Alternating many times between activities, the counters keep adding and at the end (for example after 30 minutes) i see that trainee spent 18:22 in Activity A and 11:38 in Activity B. During those 30 minutes the trainer shouted "NOW" 50 times, so did i press SWITCH 50 times.

The HOLD pauses the currently running counter without starting the other counter, the CONTINUE unpauses the last active counter
The RESET button resets both counters to zero
The START key always starts TIME A (START button is only used at begining of measurement after RESET)

THANKS

https://www.excelforum.com/attachmen...1&d=1504736517


Attached is a ILLUSTARTIVE OUTLINE jpg

Want to get your question answered quickly?

• Ensure your question is not too vague. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
• On the other hand, skip irrelevant details. Be descriptive and concise. Short, direct, and to-the-point questions with apt thread titles are almost always answered promptly.
• Keep the scope reasonably narrow. Questions like, "How do I set up an accounting system in Excel?" might be a long time waiting.
• Explain what you've already tried. ("Calculation is set to automatic, but formulas still don't compute") so helpers don't waste your time or theirs.
• Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
• If your question has not been answered within a day, consider adding another post with any additional information you believe is relevant. If you think your post is good as is, just reply to your own thread with the words "Bump no response", which will bring it to the top of the forum.

---

Go to the Commercial Services section of this site http://www.excelforum.com/commercial-services/
And read the FAQ on how to solicit paid help.

Nevermind i was able to ask a collegue to program it. Issue Solved.

If anyone is interesetd to get the macro PM me.