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

latest? – Raystafarian Jul 21 '15 at 17:10