Averaging Time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JP - 27 Jan 2008 12:37 GMT

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

Reply to this Message

Matt Richardson - 27 Jan 2008 12:59 GMT

> I've tried to figure out a way to average a column of times, but to no
> avail.
[quoted text clipped - 6 lines]
>
> 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

Reply to this Message

Stan Brown - 27 Jan 2008 13:41 GMT

Sun, 27 Jan 2008 04:37:34 -0800 from JP <JohnP26@msn.com>:

> 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?

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Reply to this Message

Emmanuel Garcia - 28 Jan 2008 00:54 GMT

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.

Signature

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

> I've tried to figure out a way to average a column of times, but to no
> avail.
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Earl Kiosterud - 29 Jan 2008 16:19 GMT

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.

Signature

Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

-----------------------------------------------------------------------

> I've tried to figure out a way to average a column of times, but to no
> avail.
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message