I would like to create an input mask for swimming times. These are expressed as minutes:seconds.tenths/hundredths of a second written in the format mm:ss.tenshundredths when presented as information for club members. I've created an input mask but only as a text format as my help facility suggests that input masks are not available for numerical data. At the moment I don't want to calculate as such using this data but eventually may want to create charts of improvements in performance so may need to subtract one from the other preserving the validity of the data.
I do need to be able to ask a query to select only records which have the fastest time from a database table of each swimmer, the stroke they have performed and their time. The person who has given me the date has converted the swim times to seconds to do this and then used an expression to show the data in the format described above. Is their a way of inputting the data in my desired format but numerically so that the data can be processed properly?
Sorry this is long but nowhere have I read a solution that covers my problem.