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
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
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks