averaging time

[Escher]

looking for a formula to average time

i searched all yesterday but never found a formula

here are my times that i need to average

mm:ss

6:17
5:26
0:51
1:17
4:14
0:39
3:24
3:37
1:00
5:26
4:15
1:45
0:18
0:21
4:27
2:08
0:52
4:09
3:24
7:36
7:20
3:15
7:09

thanks for your help in advance!
:wink:

 

[dave3009]

Does =AVEARGE(range) not work for you.

KR


Dave

 

[erik.van.geit]

Hi,

you probably tried AVERAGE
or not ?
=AVERAGE(A1:A23)

if this isn't working there is a formatproblem
if the times or not rightalligned they could be text

then try this
select your data
menu data / text to columns
look carefully at the options in last box "datatype per column": set to "standard"

kind regards,
Erik

 

[Escher]

thanks, i couldn't figure it out, its working now after i realigned the information then went to data/text to columns

it changed the numbers to a different format but i changed them back...

long story short its working!! i thought there was a special formula needed.. haha!

thanks again guys!