Work to with hundredths of seconds in Access?

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

Guest

I can get Excel to work with hundredths by formating to ss.00, How can I do
this in Access? I am trying to create a database to capture and calculate
swim times (35 seconds and 78 hundredths).
 
I can get Excel to work with hundredths by formating to ss.00, How can I do
this in Access? I am trying to create a database to capture and calculate
swim times (35 seconds and 78 hundredths).
Click to expand...

Store the times as seconds and fractional seconds in a Single or
Double Float Number - not in a date/time field. Date/time values are
accurate only to the second, and are best used for points in time, not
for durations.

John W. Vinson[MVP]
 
Back
Top