entering time intervals into a database ex: recorded race times

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

Guest

Can I format a field to only time interval so that I can use functions such
as average and sum to calculate average and total times.
 
Access Date/Time data type stores 'point-in-time' data, not duration.

Formatting the display of a field does nothing to change the underlying
value stored in the field.

If you want to do arithmetic on time intervals (i.e., duration), you'll need
to store numbers, not date/times. You can average a stored # of minutes
(seconds, hundredths, whatever), then format THAT for display however you
need to.

Check Google.com and the mvps.org/access website for examples of time
parsing routines.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top