Averaging Time

  • Thread starter Thread starter JP
  • Start date Start date
J

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
 
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
Click to expand...

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
 
Sun said:
I've tried to figure out a way to average a column of times, but to
no avail.

3:03
:45
1:45
Click to expand...

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?
 
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
 
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.
 
Back
Top