averaging time

Escher

New Member
Joined
Apr 4, 2002
Messages
13
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:
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,002
Office Version
  1. 365
  2. 2016
Does =AVEARGE(range) not work for you.

KR


Dave
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
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

New Member
Joined
Apr 4, 2002
Messages
13
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,723
Members
410,630
Latest member
JFORTH97
Top