Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?