Athletic time calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top