Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 124
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
time elapsed tomas Excel Discussion (Misc queries) 0 December 11th 08 04:00 PM
Elapsed Time KevinT Excel Worksheet Functions 9 July 2nd 08 08:27 AM
Calculate Ending time using Start Time and Elapsed Time Chief 711 Excel Worksheet Functions 5 May 13th 08 04:34 PM
Elapsed time LtFass Excel Discussion (Misc queries) 3 November 10th 07 11:45 PM
elapsed time Sweetpea60 Excel Worksheet Functions 6 March 2nd 05 04:41 PM


All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"