Saturday, November 23, 2013

yogi_Compute Average Starting Time From A Table Of Starting Times

                                          Google Spreadsheet   Post  #1431
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 24, 2013
question by Zack18 (http://productforums.google.com/forum/?zx=983hltbeamzk#!category-topic/docs/spreadsheets/770nvlLkVb4)
Average time when crossing midnight
Hello,

I'm trying to take an average of a list of times, some are before midnight and some are after.  As I'm sure you know, using a simple average won't work in this case.

Using the following three times:

11:35 PM
1:00 AM
12:30 AM 

Using the AVERAGE function will yield an average of 8:41 AM which is definitely not correct.

Any help with the proper formula here?  Your assistance would be much appreciated.

Thanks,

Zack
----------------------------------------------------------------------------------------------------------------------------------------