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

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

yogi_Sum Cells Of Column A Except For The Last Populated Cell

                                          Google Spreadsheet   Post  #1283
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 14, 2013
user Zack18 (http://productforums.google.com/forum/?zx=n821th1q4nl1#!category-topic/docs/spreadsheets/1dkj_owWhDA)
Sum all cells in range expect the last cell that isn't blank
Hello,

What formula should I write to sum all cells in a given range (A1:A13), except for the last cell in the range that isn't blank.  If, for example, cell A:10 is the last cell that isn't blank, then I only want to sum cells A1:A9 (although if A:11:A13 were summed too that wouldn't really matter because they'd be blank anyways).

Thanks in advance for your help,

Zack

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