Athletic time calculations

R

Ryan

We are setting up a db to track performance of athletes at track meets. The
first question we have is how would we store times in the following format,
11:22.33 (minutes:seconds.hundredth of seconds). And the second how would we
calculate improvements in performance.
 
D

Douglas J. Steele

My recommendation for the first would be to store the times as hundreds of
seconds in Long Integer fields. Your sample time (11:22.33) would be stored
as 11*60*100 + 22*100 + 33 = 68233.

Write functions to convert back and forth between the two.

With your times stored like that, it should be pretty straightforward to
calculate percentage improvement.

Realistically, Access doesn't have a Time data type. While the Date data
type can store times as well, it's really intended for timestamps (i.e.:
specific date/time combinations), not elapsed times. As well, the Date data
type isn't guaranteed to be accurate to hundreds of seconds.
 
Top