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>
