time: minutes, seconds, fractions

[Papabjoe]

I need some help. I'm still in 7 but I think you all can still offer some advice. I'm creating a solution for the coaches of my daughter's swim team. I need a time field that will record the swimmers times in minutes:seconds:hundreths of a second. I need to be able to sort by this field from slowest to fastest etc...,

So far, I can't figure out how to do this. Any suggestions would be greatly appreciated.

Papa.

[Genx]

Well, firstly you will need to choose a standard format: MM:SS:HS or just use seperate fields to record each i.e. Minutes, Seconds, Hundreds of a second (might be easier that way). Then just sort by the field as mentioned above - Do NOT USE A TIME FIELD... use a text field!

If you have any trouble getting a value such as 1:33:7 into 01:33:07 yell.

~Genx

[Genx]

... or a number field

[comment]

Do NOT USE A TIME FIELD..

Why not? Or should I say - WHY NOT? What's a time field for, if not for keeping time data? The only "problem" I see is that entering data into a time field can be a bit awkward, with colons and a decimal point. But that can be solved by using auto-entry for reformatting.

[Genx]

.. well, yes, but, we need hundredths of a second...

[comment]

Yes. So?

[Genx]

... Hmm dunno? I've never really dealt with anything smaller than seconds, you saying that 00:02:15.13 works?

[Orlando]

Hi Guys

Can you get hundreths of a second in FileMaker?

If so, How?

[Genx]

Turns out you can... if you try GetAsTime(0.25) you'll see that you get 00:00:00.25