Creating a Stopwatch in Excel.

Hi,

I am new to the forum and this is my first post so hi to everybody.

Right to the matter in hand now. I would like help with creating a code to insert a stopwatch/timer into excel.

What I would like it for is so that I can log events in soccer matches that I watch on TV. I have already created simple macros to log a particular event at a certain time but the cell that I use for the time is currently me just clicking each minute up manually.

What I think would be idea to have a code that I could start when the match kicks off it counts up to 45 mins for HT and then stops. Then something for the second half where it starts at 45 mins and then counts up to 90 for the end of the match and then ends.

I have looked endlessly online and through forums for something similar but cannot quite find what I am looking for, so I am hoping that some kind person here could help.

Whilst the clock is ticking the spreadsheet will be making some simple calculations which I hope wont cause an issue.

Any help will be greatly recieved.

Many thanks,

Learning_XL

Please take a look at the attached. Is this approximately what you want?

Thanks Whizbang this is exactly what I am looking for.

Sorry for the naiveity but do I just copy the codes from the VBA and paste them into the workbook that I want them for?

Originally Posted by Whizbang

Please take a look at the attached. Is this approximately what you want?

You would have to create named ranges as well to match those used in the code (eg "StartTime", "RunningTime", "EndTime", StartTime2", etc.)

Excellent, I can do that.

Just for reference, can I change the range in the code to a specific cell rather then create name ranges?

I will look at this and have a go at it later and let you know how I get on.

Many Thanks.

Originally Posted by Whizbang

You would have to create named ranges as well to match those used in the code (eg "StartTime", "RunningTime", "EndTime", StartTime2", etc.)

Yes. This will work just fine.

Range("A1")

Hard coding like this means you'll have to update your code every time you change the layout of your worksheet. Also, by using named ranges, it make your code almost self-documenting (and therefore easier to read). But, it is up to you.

Thanks for this it is great.

I have it used for what I need it for.

There is just one slight problem, when the clock is running if I input data into a cell or change a value that is already there the clock/timer stops. Is there anyway around this?

Thanks.