code for time of less than 1 second please

[Derek]

Hi all

I am using this code to slow my macro:
Application.Wait Now + TimeValue("00:00:01")
for a wait time of one second. I should like to reduce this to one tenth of a second.
Please can someone tell me how I should word the code for this.
Many thanks
regards
Derek
This message was edited by Derek on 2002-05-28 17:10

 

[Jon Peltier]

How about a number format of hh:mm:ss.000?

 

[Somnonaut]

How about a number format of hh:mm:ss.000?

Actually, it still requires me truncating the column at xx:xx:xx.248 to start the next second's labels. I think it needs to be in 1/248th of a second so that when 248th entry happens it automatically rolls over to the next second.

 

[Somnonaut]

Actually, it still requires me truncating the column at xx:xx:xx.248 to start the next second's labels. I think it needs to be in 1/248th of a second so that when 248th entry happens it automatically rolls over to the next second.

Also, trying to increase the decimal points yields an error saying Excel cannot use that value. So .000 is the max clarity. I would like to use 1/248th = .0040322 so that 248 rows will equal 1 second and just pulling the copy and paste corner will put in correct number of labels.

 

[Jon Peltier]

Two points:

1. The maximum display resolution is hh:mm:ss.000, but Excel stores more digits.

2. Each cell has a distinct displayed value, separated by 0.004... from the previous value.

An Excel date is stored as the number of days since 1/1/1900, give or take a leap year approximation in 1900, and an Excel time is the fraction of a day since midnight. To add 1/248 of a second, you have to add 1/(248*60) of a minute, 1/(248*60*60) of an hour, or 1/(246*60*60*24) of a day. If you add 1/(246*60*60*24) to an Excel date-time value, you will be adding 1/248 seconds.

 

[Somnonaut]

Two points:

1. The maximum display resolution is hh:mm:ss.000, but Excel stores more digits.

2. Each cell has a distinct displayed value, separated by 0.004... from the previous value.

An Excel date is stored as the number of days since 1/1/1900, give or take a leap year approximation in 1900, and an Excel time is the fraction of a day since midnight. To add 1/248 of a second, you have to add 1/(248*60) of a minute, 1/(248*60*60) of an hour, or 1/(246*60*60*24) of a day. If you add 1/(246*60*60*24) to an Excel date-time value, you will be adding 1/248 seconds.

HA! Worked. Thanks.