I Have a column of cells in excel of format hh:mm (The day is NOT included) like:
19:08 19:08 19:40 20:10 1:45 (Any Times before 12:00 noon are considered NEXT DAY)
one (or more of these) is after midnight.
The Average of these times is = 20:46
But Excel AVERAGE gives 15:58
I would like to calculate this average without adding extra columns or using VBA Just one formula at the end of the column. By the way, I also need to exclude any blank entries in the column for the calculations.
Thanks in Advance