In my application, I will have a field in an Access datatbase that will store the time it takes for a user to complete an external process. The duration will be presented from different devices via the serial port, and will come in different formats (ie.. HHMMSS....HMMSS). My question is, what will be the best format to place this duration time into, in the database, and what is the best method to add all of a users duration times together, for a total time and avg time?


Randy