Hi, I'm trying to develop a simple database to record results of swimming races. I am trying to establish a field to record times as minutes, seconds, hundredths - I've set the field type to TIME and the Format to MM:SS.00, but when I enter data (e.g. 1:23.45) the table automatically rounds to the nearest second (e.g. 1:23.00). Am I missing something obvious to stop this happening?
More broadly, I am slightly puzzled that Base - and probably SQL, though I'm unfamiliar with it - treats all Time values as points in time, whereas for many purposes 'Time' values actually refer to duration. I'm not sure if this has any practical implications as I'm just starting out, but conceptually, I will want to add and subtract times and possibly other operations (say, % reduction in personal best time for race X needed to achieve national qualification standard), and all of these sit better mathematically treating Time values as durations rather than points in time. I ramble, sorry. Hope you can help. Robin
