Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Time less than 1 second in xl/vba?

This article should show you how:

http://support.microsoft.com/default...b;EN-US;172338
HOWTO: Use QueryPerformanceCounter to Time Code

--
Regards,
Tom Ogilvy


"shockley" wrote in message
...
Many times I would like to measure or to use an interval of time smaller
than 1 second in vba but I have not found a way. I know the computer is
capable since AutoIt does milliseconds. Is there a way?




  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 135
Default Time less than 1 second in xl/vba?

Tom, thanks much. Some interesting functions there . Gonna take me a
minute to understand and figure out how to use them...

Regards,
Shockley




"Tom Ogilvy" wrote in message
...
This article should show you how:

http://support.microsoft.com/default...b;EN-US;172338
HOWTO: Use QueryPerformanceCounter to Time Code

--
Regards,
Tom Ogilvy


"shockley" wrote in message
...
Many times I would like to measure or to use an interval of time smaller
than 1 second in vba but I have not found a way. I know the computer is
capable since AutoIt does milliseconds. Is there a way?






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 calculations for Scheduled Time vs. Actual Time Worked The Caterer Excel Discussion (Misc queries) 1 November 29th 09 08:08 AM
straight time, time and a half, and double time Jeremy Excel Discussion (Misc queries) 3 September 23rd 08 09:03 PM
Calculate Ending time using Start Time and Elapsed Time Chief 711 Excel Worksheet Functions 5 May 13th 08 04:34 PM
Subtracting Dates to get total time work time excluding weekends Jon Ratzel[_2_] Excel Discussion (Misc queries) 2 January 31st 08 10:36 PM
Calculating days & time left from start date/time to end date/time marie Excel Worksheet Functions 7 December 7th 05 02:36 PM


All times are GMT +1. The time now is 10:17 PM.

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

About Us

"It's about Microsoft Excel"