Averaging Times w/ AM PM

K

krisennay

Say I've got two cells which hold the times that I go to bed. Further
say the values are 1:00 AM and 11:00 PM. How would I average thes
times so that I get 12:00 AM as the mean bedtime?

Thanks a bunch for any help provided,
Kri
 
B

Bob Phillips

Kris,

=AVERAGE((IF(A1:A20<>"",IF(A1:A20<--"12:00:00",A1:A20+1,A1:A20))))

which is an array formula, so commit as ctrl-shift-enter, and format the
target cell as h:mm AM/PM

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top