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)
"krisennay" wrote
in message ...
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 these
times so that I get 12:00 AM as the mean bedtime?
Thanks a bunch for any help provided,
Kris
--
krisennay
------------------------------------------------------------------------
krisennay's Profile:
http://www.excelforum.com/member.php...o&userid=28760
View this thread: http://www.excelforum.com/showthread...hreadid=484505