Averaging Time

[JP]

I've tried to figure out a way to average a column of times, but to no
avail.

3:03
:45
1:45

How would I average this column of times?

Thanks

 

[Matt Richardson]

I've tried to figure out a way to average a column of times, but to no
avail.

3:03
:45
1:45

How would I average this column of times?

Thanks

I've just tried it using Excel 2003 and the AVERAGE function seems to
work just fine. You need to make sure that the :45 time is entered as
00:45 however or it won't work.

Let me know how you get on.

Regards,
Matt Richardson
http://teachr.blogspot.com

 

[Stan Brown]

I've tried to figure out a way to average a column of times, but to
no avail.

3:03
:45
1:45

The same way you'd average anything else.

Maybe the problem is that :45 is text, and you need to enter it as
0:45 to make it be a time?

 

[Emmanuel Garcia]

I'd convert the time to a decimal, average the decimals and convert back to
time. If this isn't clear, tell me what part.

I believe times of the day are real numbers, where 1.0 is the entire day,
including day and night.

--
Regards from Los Angeles,

Emmanuel
Microsoft Windows Vista
Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.4 GHz 3GB RAM
NVidia GeForce 8500 GT 512 MB

 

[Earl Kiosterud]

JP,

The AVERAGE() function should work, but you need to be sure that your cells contain true
times, not text. And also, they should contain only times, not date-times formatted to show
only time. Check the formatting (FOrmat - Cells) to be sure, or change the formatting
temporarily to General and ensure that you see appropriate fractions, like 0.25 for 6 AM.
There should be no integer part, like 39476.25.

Also, be sure that the h:m:s are what you expect. Formatting them for h:m:s will ensure
that 2:3 (2 min, 3 sec) doesn't actually mean 2:3:0.