Time

[FMNext]

Hi,

I am using version 8 on XP.

I am trying to build a small DB to keep track my son's swim meet time results. The problem I have is that how do I define the TYPE of the field to hold time from swim meet. The data look like this 1.34.02 or 34.54. How do I compare which number is fatser than the other.

Like on 1/1/2005 50 yard Freestyle. His time was 1:36.54

on 3/1/2005 50 yard Freestyle. His time was 55.36

How do I tell FMP that 55.36 is faster 1:36.54

Please hlpe.

Thanks ;)

[Breezer]

define your field as TIME and thus you will be able to subtract, compare (max/min), or even add (sum) the TIME.

For your case, you may use to get the fastest time:

TimeMin = Minimum(TIME)

Edited November 2, 2005 by Guest

[mr_vodka]

Adding to the other post, you can change the way time time stamp is formatted by going into layout mode, right clicking on the time field and selecting time format.

This should work fine for fractional seconds comparisons too.

[FMNext]

Sorry I had a problem with log in to reply to you

Thank you very much for your help. It works