Averaging Times w/ AM PM

[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 these times so that I get 12:00 AM as the mean bedtime?

Thanks a bunch for any help provided,
Kris

[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)


"krisennay" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>