Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Elapsed Time
Out of curiosity (mainly to experiment with different techniques),
what is the easiest way to guage elapsed time? The smaller the increments, the better. I am attempting to see which code runs faster on a few of my "learning workbooks". Thanks for any help with this matter. Random |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Elapsed Time
The precision of the built-in Timer function is (AIR) about 0.05 seconds -- probably not
adequate for a single iteration of a routine. Charles Williams has code for a microsecond timer "class". I think the url is www.decisionmodels.com. On 4 Sep 2003 19:04:28 -0500, Random <Random@nwhere wrote: Out of curiosity (mainly to experiment with different techniques), what is the easiest way to guage elapsed time? The smaller the increments, the better. I am attempting to see which code runs faster on a few of my "learning workbooks". Thanks for any help with this matter. Random |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Elapsed Time
http://support.microsoft.com/default...b;EN-US;172338
HOWTO: Use QueryPerformanceCounter to Time Code actually provides several different approaches. -- Regards, Tom Ogilvy Random <Random@nwhere wrote in message ... Out of curiosity (mainly to experiment with different techniques), what is the easiest way to guage elapsed time? The smaller the increments, the better. I am attempting to see which code runs faster on a few of my "learning workbooks". Thanks for any help with this matter. Random |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Elapsed Time
Perfect. Thanks a lot.
Random On Thu, 4 Sep 2003 22:27:56 -0400, "Tom Ogilvy" wrote: http://support.microsoft.com/default...b;EN-US;172338 HOWTO: Use QueryPerformanceCounter to Time Code actually provides several different approaches. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Elapsed Time
The class Myrna Refers to at Charles' site uses the QueryPerformancCounter
method - so if you want to see a sample implementation, that would be a source. It is at the bottom of his downloads page: http://www.decisionmodels.com/downloads.htm -- Regards, Tom Ogilvy "Random" <Random@nwhere wrote in message ... Perfect. Thanks a lot. Random On Thu, 4 Sep 2003 22:27:56 -0400, "Tom Ogilvy" wrote: http://support.microsoft.com/default...b;EN-US;172338 HOWTO: Use QueryPerformanceCounter to Time Code actually provides several different approaches. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time elapsed | Excel Discussion (Misc queries) | |||
Elapsed Time | Excel Worksheet Functions | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Elapsed time | Excel Discussion (Misc queries) | |||
elapsed time | Excel Worksheet Functions |