Hi, I would like to create the stopwatch where I can record the laps and have a total time as well. I would like to have data in cell to be recorded in minutes, seconds and milliseconds. I have attached the example I am looking for.
Any help is appreciated. Thank you.
Last edited by michals; 11-09-2009 at 06:56 PM.
To get milliseconds you will have to Custom Format your split cells as:
h:mm:ss.000
What's with the milliseconds.
If it's being clicked by a person, a thousandth of a second is irrelevant. Human error will negate that accuracy.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
So, can anyone help me to create the stop watch with splits that has accuracy mm:ss:00? The example of the format is attached. Thanks
Michals, SHG here on the forum has offered a technique I was able to apply to the LapCounter.xls file. I can't vouch for the accuracy, but it's giving more finite answers now, so...
Download it again to see the working solution.
LapCounter.xls
http://www.excelforum.com/excel-prog...ml#post2196213
Last edited by JBeaucaire; 11-10-2009 at 02:18 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks