I need to avg a group of times in a column/filed....the time is in hour:minute:seconds format....I thought about converting the times in each record to seconds then adding the seconds together then dividing to get the avg # of seconds...then lastly converting the seconds back to hour:minute:seconds format...I'm not sure if this is the best way or not...if it is I don't know how to go about the conversion to seconds then back....any ideas?
Thanks

You can create a query that would group by the first column and then average the second column, but the time part makes that a little tricky. What datatype do you have the time column set to in you table?

Mike
EchoVue.com

Format is long time....has to be as the time is important down to the second....and the time is in ONE column/field and part of 10 seperate records....thanks Mike

Sounds good, I just tried it on a sample database that I did, with the following query:

SELECT tblTimes.Person, Avg(tblTimes.time) AS AvgTime INTO tblTemp
FROM tblTimes
GROUP BY tblTimes.Person;

This is on a table called tblTimes a column for Person and time. It is a 'Make Table' query, so it will create a new table called tblTemp. In tblTemp, after the query has created it, you will need to go in and change the datatype of the AvgTime field back to Long Time, and that should give you your average. There may be an easier way, but this should get you going for now. As with any query, if you paste the SQL statement in and then go into Design mode, you can tweak it to add fields and change some of the names as needed. Yell if you need more clarification, since I know I tend to ramble on somewhat!

Good Luck

Mike
EchoVue.com