Averaging Times w/ AM PM
 

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

Averaging Times w/ AM PM
 

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