Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the range of several averaging functions | Excel Discussion (Misc queries) | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Formula for averaging times | Excel Discussion (Misc queries) | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions |