AnsweredAssumed Answered

Race times...millisecond

Question asked by mbenseman on Jul 30, 2012
Latest reply on Nov 25, 2012 by martinhstngs



Imam using FM 11 advanced Pro


I am trying to enter race times in a database and need to include milliseconds. When in enter say 1:30.45, fm seems to store the milliseconds, but I can't get a field to display it.


I have tried setting the Time format to mmss and the number format to 2 decimal places, but all it displays is 1:30.00; it always seems to display two zeros. Nthe data is correct because if I turn it into a number of seconds I get 90.45.


What am i doing wrong on my layout edit box formatting? Also although I have seen reference to custom formats for time layout boxes, that does not seem to be an option when I am in the navigator.


I could enter the race times as number of second, just using a number field, but would like if possible to use time.


Any help most appreciated.