Finding Average Times

[carmenh]

I am trying to find averages for times and have been unsuccessful in m
attempts to do so.

The times are in second increments

:56=56 seconds
1.15= One minute 15 seconds

1. I need to know the formula
2. I need to know the formatting for the cells

thanks

 

[Juan Sanchez]

Carmen

Times are numbers just as any other number, to get the
average you use =AVERAGE(RANGE)

However, all time need to be input as time, meaning that
for :15 (15 seconds) you need to type 0:15 and for 1.15 (1
minute, 15 seconds) you need to type 1:15, using the colons
( or what ever the name is for --->:, Mexican guy)

You can use some code to avoid using the ":" check:

http://www.cpearson.com/excel/datetime.htm

for more info...

Cheers
Juan

 

[Nimit Meta]

Dint get it, please elaborate.