First I would like to say hello to everyone here.



this is probably a simple question, having trouble finding an answer possibly because I am not using(don't know) correct term to find my answer.

Simply when creating a table entry for time I am using nn:ss:"00". However I want to ensure that in later queries Access can use this format properly. I am using the time as a sports sectional time field eg how long a particular lap or race or event took.

Besides the format (nn:ss:"00") is there a protocol to use to lock this form of time measurement in place so that times could be analyzed later for smilarity or differenc between times?

Thanks