Help me on time format.

[rajaneesh1438]

Hi 

I want to calculate the average time taken for call answering. But time format in my table is different.  

Table:

id,location,time

101,hyd,3.0000

102,hy,4.0000

103,bangloare,36.0000

104,bangloare,23.0000

105,chennai,5.0000

106,chennai,374.0000

Need to calculate the average time taken for call answering based on location.

but in this above table 3,4,36,23,5,374 are the seconds. Need to remove the 4 zeros and numbers convert into time format and than calculate the average time taken for call answering based on location.

Please help me on this.

[Andrew_Delaney]

There are a variety of ways to tackle this kind of problem, have you had a chance to run through  getting started scripting section of our help?