how to record time in minutes, seconds & milliseconds in a table

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

Guest

I am trying to record results for athletics meetings and cannot format the
time cell to accept the data in the above format. Any help much appreciated.
 
I am trying to record results for athletics meetings and cannot format the
time cell to accept the data in the above format. Any help much appreciated.
Click to expand...

Access Date/Time fields are only displayable to integer seconds. They're
actually stored as a Double Float count of days and fractions of a day since
midnight December 30, 1899 - which means that they're accurate to about 100
microseconds - but you can only *use* the data to the nearest second.

I'd suggest storing the race times in a Double Float number of seconds (e.g.
4min32.84sec would be stored as 272.84). You can format this for display
purposes with an expression like

[Runtime] \ 60 & Format([Runtime] - ([Runtime] \ 60) * 60, "\:00.000")


John W. Vinson [MVP]
 
Back
Top