Thread: How do I calculate the average time from a group of TIMES in excel
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default How do I calculate the average time from a group of TIMES in excel
Times are just normal numbers, the fraction of a 24-hour day (e.g.,
6:00 = 0.25, 12:00 = 0.5, 18:00 = 0.75), so you can average them just
as you would "real" numbers. E.g.,

=AVERAGE(A1:A10)

Format the cell with the formula in it as [hh]:mm or [hh]:mm:ss.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Tue, 16 Dec 2008 10:57:01 -0800, CRMRAA
wrote:

I have a list of about 1500 times (in military format) that I would like to
get the mean of the list. Please advise and thank you in advance.
Reply With QuoteReply With Quote