Wednesday, February 24, 2016

yogi_Compute Row By Sum And Average Of Time Durations Given In Hours Minutes and Tenths Of Minutes

Google Spreadsheet   Post  #2043
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Feb-24-2016
post by: Maddie7838:!topic/docs/vl5I5yALwBI;context-place=mydiscussions
Average Durations
I have a series of durations in my data sheet and I am unable to average them. Every time I try to average I get the #DIV/0. How do I fix this?
Here's the link to the sample data that I'm trying to average: .

I'm trying to average the times listed under Time 1, Time 2, and Time 3. I'd like them to appear in B3 (under average time), but I keep getting the following error: #DIV/0!. 

The answer should be 1:45.2.