Hi,

I am trying to write a timing system which will allow the timekeepers to enter the times in Hours:Minutes:Seconds:Hundredths Of Seconds. It all works fine except for the "Hundredths of Seconds" part which I cannot work out how to include. Any ideas/experiences appreciated.

Thanks

Roger

I believe Troi has a plug in that allows this.

http://www.Troi.com

Old Advance Man

I did a preliminary test with this calc, and it seemed to work:

Define a calculation field (number, unstored)

code:

---

(TextToNum(LeftWords(Time_Entered, 1)) * 3600) +

(TextToNum(MiddleWords(Time_Entered, 2, 1)) * 60) +

TextToNum(MiddleWords(Time_Entered, 3, 1)) +

(TextToNum(RightWords(Time_Entered, 1)) / 100)

Where Time_Entered is a text field. The time must be entered in the format hh:mm:ss:hundredths_of_seconds. The result will be the total number of seconds, which you can use in further calculations.

Hope this helps!

Yep - I've done some work on a similar method to The Bridge's suggestion except I used different text fields and tabbed between them to speed up data entry.

I'll have to check out the Troi Plugin. A lot depends on where you're getting your timing input from. If its from pressing a key, then your human reaction time of about 20 hundredths of a second makes timing to one hundredth a bit meaningless. But, if you're getting it from a light beam system or similar, then its OK.

Russ Baker

Canberra, Australia